| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 01/09/2010 07:56:48
|
Jacobite
SysAider
Joined: 11/05/2010
Messages: 10
Offline
|
Hi, i'm trying to install syaid with mysql 5.1.46 on a server 2003 box.
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?
|
|
|
01/09/2010 10:34:42
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
Hi Jacobite,
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.
|
Best Regards,
Itay |
|
|
02/09/2010 03:15:20
|
dsherb628
SysAider
Joined: 12/07/2010
Messages: 1
Offline
|
the mysql is open source.
there are trial version?
|
More useful Guide for you:
avi to ipad | wmv on ipad | mkv to ipad | mpeg/mpg to ipad |
|
|
02/09/2010 03:41:58
|
Jacobite
SysAider
Joined: 11/05/2010
Messages: 10
Offline
|
Hello, I cant seem to create a mysql database, following the countless how-to's on the net they state to enter a few command lines to create the db, create a user and and then add privileges for the user. All of which don't seem to work.
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?
|
|
|
02/09/2010 07:51:03
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
Hi Jacobite,
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.
|
Best Regards,
Itay |
|
|
02/09/2010 08:24:16
|
Jacobite
SysAider
Joined: 11/05/2010
Messages: 10
Offline
|
Hi, I was unable to create the database with those basic commands, so have just gone with the Derby db, thanks anyway.
|
|
|
05/09/2010 03:57:17
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
You are most welcome. You should check if you have permissions because I was testing the commands I gave you to verify.
|
Best Regards,
Itay |
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
