![]() $ sudo systemctl start httpd # start now $ sudo systemctl enable httpd # start at boot $ service httpd status & curl localhost # check length - 2 ) // remove last ,\n sql += ' \n ) ' logInfo ( sql ) f. BuildSqlSchema ( ' default ', table ) var sql = ' CREATE TABLE ' + table + ' ( \n ' for each ( var field in sqlSchema. open ( ' w ' ) var table = ' nmsextaccount ' var sqlSchema = NLWS. ![]() Var f = new File ( ' /sftp/my-instance/incoming/my-ftp-folder/my-tables.sql ' ) f. We’ll set up an instance named instance1, with default user internal and password internal (See Adobe doc for nlserver config). To do so, some extra steps need to be taken, see Allow external PostgreSQL access at the end of this article. You can check your PostreSQL setup by connecting to your Guest via SqlEctron (or any SQL client). Host all all ::1/128 ~]$ sudo su - ~]$ createuser -interactive # create a PostgreSQL role (user) ~]$ createdb dbuser1 # create a PostgreSQL database with the same name ~]$ psql # open the PostgreSQL shell postgres=# ALTER USER dbuser1 PASSWORD 'dbpwd1' # set a password for the SQL user postgres=# \q ~]$ exit ~]$ sudo adduser dbuser1 # create a Linux user with the same name ~]$ sudo systemctl start postgresql # start PostgreSQL now ~]$ sudo systemctl enable postgresql # and at boot ~]$ sudo vim /var/lib/pgsql/data/pg_hba.conf # replace ident by md5 host all all 127.0.0.1/32 md5 We have to allow the ACC default port 8080 (Which is the Tomcat default ~]$ sudo yum install postgresql-server postgresql-contrib # not needed if already installed via the Centos package selection ~]$ sudo postgresql-setup initdb To be able to connect from our Host, we need to create new Firewall rules.īy default CentOS uses firewall-cmd to block incoming connections. 14 neolane neolane 187 Feb 13 14:01 nl6Įxport LD_LIBRARY_PATH=/usr/local/neolane/nl6/lib/:/usr/lib/jvm/java-1.8.0-openjdk/jre/lib/amd64/:/usr/lib/jvm/java-1.8.0-openjdk/jre/lib/amd64/server/Įxport PATH=$PATH:/usr/local/neolane/nl6/bin/Īlias ll="ls \w]\$ ~]$ nlserver start webġ4:01:32 > Application server for Adobe Campaign (6.1.1 build 8864) of ġ4:01:32 > Launching task ('nlserver web -instance:default -detach -tomcat -autorepair') in a new processġ4:01:32 > Starting Web server module (pid=9376, tid=9376).ġ4:03:23 > Application server for Adobe Campaign (6.1.1 build 8864) of (9376) - 143.4 MB ![]() Install Virtual Box Guest Addition to enable ~/ac]$ sudo su - neolane.Youtube tutorial to install CentOS 7 on VirtualBox.Restart the machine, accept the licence and log in.Server with a GUI > Add PostgreSQL Database Server & Development Tools.Then, install it with the following settings: Spin up a Red Hat instance with the ISO loaded and a 8gb disk.Install VirtualBox from /wiki/Downloads.Note: Official AC7 Adobe installation guide. ![]() Configure ~/.profile for user neolane and start AC Application server.Plus, access to any VM feature such as snapshots and duplication. Main use case is data scientists / data analysts / SQL power users.Local install Adobe Campaign to set up your own development environment! Useful for testing and demo. Perhaps a fork with the admin features stripped out, some additional plumbing added, and read-only connections, I'm not sure. I've seen a few applications that are coming close listed on HN lately, but would be nice to have something as pretty as this and which is open source. Something lighter weight than BI tools such as Power BI, Tableau, Qlik, etc., definitely lighter weight than tools such as SSMS, DBeaver, SQuirrel, etc. And not embedded in MS Excel, like PowerQuery or PowerPivot (although it's powerful!). A simple "SQL notebook" that was cross platform, if you will, but worked more like a traditional query tool. On a side-note, I'd love to see an even more minimalist stripped-down, read-mostly query/tabular result only (with pivot tables) tool, which had some local columnar storage caching/query engine, and simple import/export to common file formats as well. I observed the fact that SQL Server had no management tool that was cross-platform, and thought perhaps I would build such a thing. ![]() I guess it's a good thing I didn't do the project I was thinking about. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |