Quote:
Originally Posted by LeatherNeck
Excellent work, working like a charm on 3.8.1
Hope it's ok, but a lot of people have trouble getting TS to work on linux with mysql, so here is how I did it (tested on Centos5 and mysql 5  )
Add the following to the very bottom of your server.ini
Code:
[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=*************
Hostname=127.0.0.1
User_name=**********
Password=*****************************
GetDriverFunc=getSQLDriverMYSQL
VendorLib=FULL/SERVER/PATH/TO/LIBS/libmysqlclient_r.so.10.0.0
LibraryName=FULL/SERVER/PATH/TO/LIBS/libsqlmy.so
Active=1
WITH THIS YOU NEED TO RUN AT THE MYSQL PROMPT
mysql>
Code:
SET PASSWORD FOR
'TheTSdbUser'@'localhost' = OLD_PASSWORD('***************');
ATACHED ARE THE LIBS NEEDED TO CONNECT TO MYSQL
|
I have done exactly the same on my server, and it works, now im moving servers, copied all files from my old server, changed the database user / pass, en now i get:
Code:
-------------- log started at 23-02-09 15:29 -------------
---------------------------------------------------------------
23-02-09 15:29:57,ALL,Info,server, Server init initialized
23-02-09 15:29:57,ALL,Info,server, Server version: 2.0.24.1 Linux
23-02-09 15:29:57,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
23-02-09 15:29:57,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
I am 100% sure my user/pass is correct, and my config and files are eactly the same as my old working server.
any idea what i could be missing?