http://www.ilient.com/Sysforums/posts/list/57.page JForum - http://www.jforum.net Admittedly I know very little about mysql, however it seems to have installed successfully?
My problem arises when I go through the syaid setup and select mysql, there is no info in the sysaid docs that guide you through creating a mysql database so I assume the wizard does it for you?
However, I get access denied when I 'check connection', so I enter the root username and password then I get 'unknown database ilient' ?
I'm sure its something simple?]]> http://www.ilient.com/Sysforums/posts/preList/5388/23390.page http://www.ilient.com/Sysforums/posts/preList/5388/23390.page GMT
Please follow the instructions:


Note: If you are using MySQL version 4.0 or below, please skip step 1.

In order to setup SysAid with a MySQL database:

1. In order to install SysAid with MySQL v4.1 and above, you need to replace the included driver used to connect to the database. Please download a new driver at http://dev.mysql.com/downloads/connector/j/3.1.html.

Download and extract the files, and look for the mysql-connector-java-3.1.12-bin.jar file. Rename it to mysql.jar

Now start installing SysAid (go to step 2) and when getting to the database selection in the wizard, replace the ...\SysAidServer\root\WEB-INF\lib\mysql.jar with the newer one, and then resume installation. Use the Check Settings button to ensure that connection to the database is OK.


2. Create an empty database on your server. Set its collation to Unicode (UTF-.

3. During installation, in the database settings dialog specify the JDBC URL to your empty database (replace localhost with SQL server hostname or IP address, replace Ilient with the database name).

4. Specify a username and password which have sufficient privileges on that database (DBO). Alternately, you can use the root account.

5. Click "Check Settings" to verify successful connection.

If anything goes wrong, please send me a screenshot of the information you have entered and the error message. In addition, please attach the ...\SysAidServer\root\WEB-INF\logs\sysaid.log file.]]> http://www.ilient.com/Sysforums/posts/preList/5388/23402.page http://www.ilient.com/Sysforums/posts/preList/5388/23402.page GMT
there are trial version?]]> http://www.ilient.com/Sysforums/posts/preList/5388/23406.page http://www.ilient.com/Sysforums/posts/preList/5388/23406.page GMT I get no response from the command line except a >
I know this is not a mysql support forum, but if someone can state the obvious - which I am missing, it would be appreciated?]]> http://www.ilient.com/Sysforums/posts/preList/5388/23407.page http://www.ilient.com/Sysforums/posts/preList/5388/23407.page GMT
In order to create new database please connect to your MySql command line client > run the following:
create database SysAid;

In order to check if the DB was created please run the following:
show databases;

Let us know if this helps.]]> http://www.ilient.com/Sysforums/posts/preList/5388/23412.page http://www.ilient.com/Sysforums/posts/preList/5388/23412.page GMT http://www.ilient.com/Sysforums/posts/preList/5388/23414.page http://www.ilient.com/Sysforums/posts/preList/5388/23414.page GMT http://www.ilient.com/Sysforums/posts/preList/5388/23465.page http://www.ilient.com/Sysforums/posts/preList/5388/23465.page GMT