Kueri, A Natural Language Database Tool - Part Three

_________________________

Kueri installation - Windows 7 PC
_________________________

installed Kueri on a Windows 7 PC. In the on-line Kueri referencethis page shows how to do it. Everything went well and I'll share my experiences here. Kueri also works in a Linux environment; this page has further details.

First, be sure to first install at least Java 1.7 before you start the Kueri installation. Kueri relies on Java for its own system management. Kueri works perfectly with a locally installed MySQL / SQL Server / etc. database, but it does not need these resources for its own operation. Because the install package downloads in a tar.gz archive file, the suggested 7-Zip (a free download) really helped. The Windows environment instructions worked well and I quickly installed Kueri SDK Enterprise. Now, Kueri will not show in the Windows Control Panel. If you need to uninstall Kueri for some reason, first drill down to the folder / directory location where you installed it and delete it. Next, drill down to

     C:\Users\{user name}

as in this example


1. Look for the .kueri folder / directory in C:\Users\{user name}
and delete the

     .kueri

folder.

Kueri will work perfectly with a MySQL database stored anywherelocally or in the cloud somewhere. For MySQL, however, Kueri will need a MySQL Java connector, available here from the MySQL website. Copy the connector JAR file, named

     mysql-connector-java-5.1.39-bin

here, from the package, and place it in the

     kueri\tomcat\jdbc

directory as shown in this


2. Place the MySQL Java Connector in the
kueri\tomcat\jdbc
directory
example. 

To run Kueri, first launch the

     startup.bat

file as step 5 explains. To make things easier, I created a desktop shortcut out to this batch file and in its Advanced . . . (AKA properties)

3. Shortcut Advanced properties

I picked

4. Run the batch file as an administrator
"Run as administrator". When startup.bat launches, a DOS command prompt (DOS box) will open; at first, "a lot" of "stuff" will happen inside that box but soon enough, all that will ease off and it will look something roughly like

5. Running startup.bat
this. Keep this box open every moment Kueri runs. Minimize it if you want, but don't close it.

We're almost there. Point a new browser tab to

     127.0.0.1/admin

and the Kueri admin login

6. Kueri admin login
will open. Use

     admin / admin


as the first email / password for the first login, but that, Kueri will want a new password. After a little more configuration in step 8 here, you can use Kueri in production. Next, I'll set up a Kueri connection to the Google Cloud SQL resource I built in Part Two.
_______________

Part three here showed how to set up Kueri in a Windows environment. Part four will show how to configure a Kueri Data Source.