MY SQL interigration

[kang157]

I am trying to get TS use a remote SQL database, but I cant seem to get it to work.

Witch modules does the TS server need to have installed? I have read some topics in this forum, but I can only find help for local SQL servers..

-------------- log started at 16-03-07 11:59 -------------
---------------------------------------------------------------
16-03-07 11:59:38,ALL,Info,server, Server init initialized
16-03-07 11:59:38,ALL,Info,server, Server version: 2.0.20.1 Linux
16-03-07 11:59:38,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient.so.12.0.0
16-03-07 11:59:38,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 16-03-07 11:59 --------------

---------------------------------------------------------------



I have installed the mysql-client package for debian.. this is my config:

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=norgam_tspeak
Hostname=hostname/IP for my remote server
User_name=*****
Password=*****
GetDriverFunc=getSQLDriverMYSQL
VendorLib=./libmysqlclient.so.12.0.0
LibraryName=./libsqlmy.so
Active=1

[Reedy Boy]

I am trying to get TS use a remote SQL database, but I cant seem to get it to work.

Witch modules does the TS server need to have installed? I have read some topics in this forum, but I can only find help for local SQL servers..

-------------- log started at 16-03-07 11:59 -------------
---------------------------------------------------------------
16-03-07 11:59:38,ALL,Info,server, Server init initialized
16-03-07 11:59:38,ALL,Info,server, Server version: 2.0.20.1 Linux
16-03-07 11:59:38,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient.so.12.0.0
16-03-07 11:59:38,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 16-03-07 11:59 --------------

---------------------------------------------------------------



I have installed the mysql-client package for debian.. this is my config:

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=norgam_tspeak
Hostname=hostname/IP for my remote server
User_name=*****
Password=*****
GetDriverFunc=getSQLDriverMYSQL
VendorLib=./libmysqlclient.so.12.0.0
LibraryName=./libsqlmy.so
Active=1

16-03-07 11:59:38,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient.so.12.0.0

It cant find the library


Does /usr/lib/libmysqlclient.so.12.0.0 exist?

[kang157]

Yes, it do exist, I have also tryed to use the mysql 3, and then it says:

-------------- log started at 16-03-07 12:31 -------------
---------------------------------------------------------------
16-03-07 12:31:25,ALL,Info,server, Server init initialized
16-03-07 12:31:25,ALL,Info,server, Server version: 2.0.20.1 Linux
16-03-07 12:31:25,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
16-03-07 12:31:25,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 16-03-07 12:31 --------------

I get the same message even if I do not have the right Hostname set.. so I don't think it checks for username and password at all?

[Tomas]

omg MAN need more info
can be also TS <-> MySQL conflict in versions
write your version of MySQL at least
( take a look to the change log of MySQL if you using the new version >4.4 , 5 ??:-/ don't know exactly the version ... )

it was written somewhere change in password hashing function so if you use lib and MySQL with+without these changes ... you can get username/password problem
//to solve this(MySQL server is new ver..) use old hashing function and enter password to the database again

libmysqlclient.so.12.0.0
last time I use only 10.0.0

sry for that en