mysql password problem

[nathangoing]

I'm getting this:

---------------------------------------------------------------
-------------- log started at 12-06-04 06:38 -------------
---------------------------------------------------------------
12-06-04 06:38:42,ALL,Info,server, Server init initialized
12-06-04 06:38:42,ALL,Info,server, Server version: 2.0.20.1 Win32
12-06-04 06:38:42,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
12-06-04 06:38:42,ERROR,All,SERVER, Start_Server: unable to open database
12-06-04 06:38:42,ERROR,All,GENERAL, critical error, shutdown initiated

but the thing is that i have tried multiple users and passwords including root to see if it would work. is there a certain way that i have to encode the password in the server.ini file?

thanks.

[guldi]

no
have you given the user the right to access the specific TS database ? I had exactly this problem as well.
Connect to your mysql server and test the login !

[nathangoing]

The user i set up works from the command line with no problem. And i know i've given that user the correct permissions. I've even triend root, which i know has no problems, but no success. Is there something that i'm over looking? The DB stores passwords encoded right? should i have the encoded password in the server.ini?

here is what's going on:

C:\>mysql -u teamspeak -pasdfasdf
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.0.20a-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use teamspeak
Database changed
mysql>

but here's the response from ts. (server.log)

---------------------------------------------------------------
-------------- log started at 12-06-04 11:36 -------------
---------------------------------------------------------------
12-06-04 11:36:36,ALL,Info,server, Server init initialized
12-06-04 11:36:36,ALL,Info,server, Server version: 2.0.20.1 Win32
12-06-04 11:36:36,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
12-06-04 11:36:36,ERROR,All,SERVER, Start_Server: unable to open database
12-06-04 11:36:36,ERROR,All,GENERAL, critical error, shutdown initiated

And my current [dbexpress] section in server.ini

[DBEXPRESS]
sqldir=C:/Program Files/Teamspeak2_RC2/mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
Password=asdfasdf
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmysql.dll
LibraryName=dbexpmysql.dll
Active=1

thanks.

[McAfee]

how many files do you have on the teamspeak\mysql folder? i think you need to burrow some files from the sqlite folder.

[nathangoing]

I copyed the files over from sqlite_sql.

C:\Program Files\Teamspeak2_RC2\mysql_sql>dir
Volume in drive C is Local Disk
Volume Serial Number is 5855-CE0B

Directory of C:\Program Files\Teamspeak2_RC2\mysql_sql

06/12/2004 05:35a <DIR> .
06/12/2004 05:35a <DIR> ..
04/10/2003 10:34a 328 create_bans.sql
04/10/2003 10:35a 739 create_channels.sql
04/10/2003 10:35a 391 create_channel_privileges.sql
11/18/2003 02:14p 426 create_clients.sql
07/04/2003 08:19a 149 create_nicks.sql
06/06/2003 08:28a 1,405 create_servers.sql
04/10/2003 11:12a 3,499 create_server_privileges.sql
07/12/2003 05:34p 199 create_settings.sql
02/16/2003 10:43a 81 delete_ban.sql
02/16/2003 11:34a 78 delete_ban_ip.sql
02/03/2003 08:20a 204 delete_channel.sql
07/19/2003 07:19a 139 delete_channel_privilege.sql
02/03/2003 08:21a 194 delete_client.sql
05/24/2003 09:33p 315 delete_server.sql
02/01/2003 12:25p 467 edit_channel.sql
02/03/2003 08:09a 240 edit_channel_privilege.sql
02/02/2003 12:32p 195 edit_client.sql
09/16/2003 07:54p 121 edit_client_lastonline.sql
11/05/2003 07:38a 994 edit_server.sql
02/26/2003 06:38a 3,512 edit_server_privilege.sql
02/16/2003 11:22a 188 new_ban.sql
01/31/2003 12:23p 562 new_channel.sql
02/03/2003 08:08a 269 new_channel_privilege.sql
02/02/2003 09:16a 240 new_client.sql
06/06/2003 07:28a 968 new_server.sql
02/19/2003 09:42a 3,651 new_server_privilege.sql
02/04/2003 11:04a 60 read_active_servers.sql
02/16/2003 10:44a 58 read_bans.sql
07/02/2003 07:58a 97 read_channel.sql
01/31/2003 12:00p 66 read_channels.sql
02/03/2003 08:08a 141 read_channel_privilege.sql
07/19/2003 07:04a 609 read_channel_privileges.sql
02/02/2003 08:08a 63 read_clients.sql
02/10/2003 07:48a 92 read_clients_id.sql
02/02/2003 09:03a 90 read_clients_name.sql
07/21/2003 08:48a 710 read_client_channels_privileges.sql
02/02/2003 08:09a 124 read_client_login.sql
01/30/2003 10:36a 56 read_server.sql
02/10/2003 09:05a 26 read_servers.sql
02/10/2003 08:55a 57 read_server_port.sql
02/05/2003 08:46a 99 read_server_privilege.sql
09/14/2003 07:22a 58 remove_bans.sql
02/28/2003 07:05p 164 remove_moderatedattribs.sql
08/01/2003 07:37a 93 search_client.sql
05/21/2003 08:01a 1,696 upgrade_1.sql
06/06/2003 07:50a 1,935 upgrade_2.sql
11/18/2003 02:17p 656 upgrade_3.sql
47 File(s) 26,504 bytes
2 Dir(s) 13,539,016,704 bytes free

[nathangoing]

Any ideas?

[Similian]

I have the same problem !

I have a Teamspeak Server running at home and i want to have
it connected to the MySqlDB on my webspace.

I get the same reply but i can login manually.

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=teamspeakdb
Hostname=mypage.com
User_name= teamspeak
Password= abcdef
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmySQL.dll
LibraryName=dbexpmysql.dll
Active=1

....... really confusing

---------------------------------------------------------------
-------------- log started at 23-06-00 15:16 -------------
---------------------------------------------------------------
23-06-00 15:16:50,ALL,Info,server, Server init initialized
23-06-00 15:16:50,ALL,Info,server, Server version: 2.0.20.1 Win32
23-06-00 15:16:52,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
23-06-00 15:16:52,ERROR,All,SERVER, Start_Server: unable to open database
23-06-00 15:16:52,ERROR,All,GENERAL, critical error, shutdown initiated