Need some help setting TS up with MySQL 5 database.

[PlymWS]

I'm trying to get my TS server to use a MySQL DB rather than the SQLite DB so I can integrate the admin into my VBulletin forum. I am running Fedora Core 6 with MySQL 5 and PHP 5.

My config file reads :

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=imts
Hostname=localhost
User_name=xxx
Password=xxx
GetDriverFunc=getSQLDriverMySQL
VendorLib=/usr/lib/libmysqlclient_r.so.14.0.0
LibraryName=./libsqlmda.so.4.20
Active=1

libsqlmda.so.4.20 is the DBExpress file I downloaded from here (http://crlab.com/dbx/download.html). When I run the server I get this error :

02-03-08 19:27:09,ALL,Info,server, Server init initialized
02-03-08 19:27:09,ALL,Info,server, Server version: 2.0.23.19 Linux
02-03-08 19:27:09,ERROR,All,SQL, Database initialization error: EDatabaseError.MySQL client library couldn't be loaded. Please place libmysqlclient.so (libmysqlclient.so.X) file to system folder (included to LD_LIBRARY_PATH) or to the folder with executable unit of main program.
libmysqlclient.so.7: cannot open shared object file: No such file or directory
02-03-08 19:27:09,ERROR,All,SERVER, Start_Server: unable to open database

This is reporting that I need libmysqlclient.so.7 which I can't find anywhere. I have searched these forums and no one else has even mentioned this version of the VendorLib.

Why am I (apparently ) the only one getting this error ? If there's someone who runs MySQL 5 who has managed to get a server running with MySQL I would appreciate any help.

[ozman]

ubuntu 6.0.6 mysql compiled 5.0.51a

frist thing get the right libs wse libmysqlclient_r.so..10.0.0 or libmysqlclient.so..10.0.0 the goto ypur my.cnf in /etc/my.cnf and add
"safe-user-create" ans "use-old-passwords" then post back when when you restart mysql

use apt-get or dpkg or what ever you have to get the right lib
if you cant find them i have the supper libs that workes on almost all unix based systems i can ZIP up and post here

[PlymWS]

OK I got the correct libs for my version so I'm using the same as you attached. I now get the error :

04-03-08 13:10:19,ALL,Info,server, Server init initialized
04-03-08 13:10:19,ALL,Info,server, Server version: 2.0.23.19 Linux
04-03-08 13:10:19,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Find Procedure getSQLDriverMySQL
04-03-08 13:10:19,ERROR,All,SERVER, Start_Server: unable to open database

If I then retype the .ini file to read :

GetDriverFunc=getSQLDriverMYSQL

with a capital 'Y' I then get :

04-03-08 13:25:28,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./libmysqlclient_r.so.10.0.0

which is strange as the file is in the directory and CHMOD 777.

Also tried absolute paths for files. Still get the Unable to load ... error.

[ozman]

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=tspor8767
Hostname=127.0.0.1
User_name=dbuser
Password=xxxxxxxxxxxxxxxxxxxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/libs/libmysqlclient_r.so.10.0.0
LibraryName=/libs/libsqlmy.so
Active=1

notice the 172.0.0.1 insted of localhost if the lookup fubction is shutoff or disabled in mysql use it
ant i also use absolute paths just because i feal better in the morning :)

and see if you have all the mysql files in the mysql_sql dir if not i know someone has poster them in this forum it's where i got them there should be about 47 files i would zip mine but i'm set with MD5 hash

I decided to post my Mysql set that is setup with md5 enc anyways

[PlymWS]

I tried localhost and 127.0.0.1 but I still get the error. I'm not that worried about the SQL files atm as I can't even get TS to connect to the DB sucessfully :)

[ozman]

use this command at the mysql prompr

SET PASSWORD FOR
'thedbuser'@'localhost' = OLD_PASSWORD('xxxxxxxxx');

this will activate old password auth after the use-old-passwords in my.cnf has beeen changed

if you are usind the dist package it might be old-passwords=1 in my.cnf

to set password


please post the server.ini and the my.cnf file contents here minus passwords

[PlymWS]

But the error I'm getting says that the file libmysqlclient.10.0.0 can't be loaded. I'm not getting a password error as TS isn't evn able to connect to the database.

[ozman]

did you try the libs i posted?

libmysqlclient.10.0.0 see the R libmysqlclient.r.10.0.0

[PlymWS]

Yes, that just brings up the same "Unable to load" error with that file.

[ozman]

you will need the mysql files to connect as it is how TS talkes to mysql
and can you login to mysql via the user you created?

and privildges on the db just give him all for now

selece insert update create drop alter index etc...

[PlymWS]

I'm just going to roll back to MySQL 4 I think as this is proving too problematic tbh.

[ozman]

if you can do it from 4+ you can do it from 5 with a little work

[PlymWS]

My forums need 4+ so that's the earliest I can use.

[ozman]

Thank you for waisting my time.
I took time out of my day to help someone i don't even know
and now you want to stop trying hell i wont even quit smoking because i'm not a quitter ////bookmarked as useless

[PlymWS]

You're telling me to change the database settings even though I clearly said that the problem is that the libs don't work.

The error messages were clear in that all the libs didn't work and yet you say change DB setting. What's the point when I can't even connect to the DB ?

Change privs, change to old passwords. It's not even running the libs let alone connecting to the DB.

[ozman]

with mysql 5 you need to change server and user settings to connect if it said cant find libs libs i would say it is a libe prob if it said unable to connect but it sais Unable to Find Procedure getSQLDriverMySQL

where do you thing the procediures are at?

[ozman]

Done!!!!!!!!!!!!!!!!!!

[PlymWS]

Database initialization error: EDatabaseError.Unable to Load ./libmysqlclient_r.so.10.0.0

Was the last error I posted, not a procedure error