PDA

View Full Version : ts not useing MySql

mrdeath
19-11-2005, 12:34
Hello ...

I'm trying to get Teamspeak to work with MySql and I get it to start just fine but its not writing the data into the MySql, it just create a new server.dbs every time I try.. And I get no errors in the server.log;

---------------------------------------------------------------
-------------- log started at 19-11-05 11:43 -------------
---------------------------------------------------------------
19-11-05 11:43:42,ALL,Info,server, Server init initialized
19-11-05 11:43:42,ALL,Info,server, Server version: 2.0.21.3 Linux
19-11-05 11:43:42,WARNING,Info,SQL, created table ts2_servers
19-11-05 11:43:42,WARNING,Info,SQL, created table ts2_server_privileges
19-11-05 11:43:42,WARNING,Info,SQL, created table ts2_channels
19-11-05 11:43:42,WARNING,Info,SQL, created table ts2_channel_privileges
19-11-05 11:43:42,WARNING,Info,SQL, created table ts2_clients
19-11-05 11:43:42,WARNING,Info,SQL, created table ts2_bans
19-11-05 11:43:42,ALL,Info,server, Starting VirtualServer id:1 with port:8767
19-11-05 11:43:42,WARNING,Info,SERVER, Default VirtualServer created
19-11-05 11:43:42,WARNING,Info,SERVER, admin account info: username: admin password: 2an2pv
19-11-05 11:43:42,WARNING,Info,SERVER, superadmin account info: username: superadmin password: 9cz5ws
19-11-05 11:43:42,ALL,Info,server, Server init finished
19-11-05 11:43:42,WARNING,Info,server, TeamSpeak Server daemon activated
19-11-05 11:43:44,ALL,Info,server, Server shutdown initialized
19-11-05 11:43:46,ALL,Info,server, Server shutdown finished
---------------------------------------------------------------
--------------- log ended at 19-11-05 11:43 --------------
---------------------------------------------------------------
---------------------------------------------------------------
-------------- log started at 19-11-05 11:43 -------------
---------------------------------------------------------------
19-11-05 11:43:49,ALL,Info,server, Server init initialized
19-11-05 11:43:49,ALL,Info,server, Server version: 2.0.21.3 Linux
19-11-05 11:43:49,ALL,Info,server, Starting VirtualServer id:1 with port:8767
19-11-05 11:43:50,ALL,Info,server, Server init finished
19-11-05 11:43:50,WARNING,Info,server, TeamSpeak Server daemon activated
Its not creating any tables in the mysql db, its just creating a new server.dbs.. All rights for the mysql user is set ok (GRANT ALL PRIVILEGES ON… and so on).. what I'm I doing wrong here?


TS Version: v2.0.r21.b3 Linux
server.ini (http://t4a.se/server.ini)
Server: FreeBSD 6.0
MySQL: 5.0.15
PHP: v4.4.1
Apache/1.3.34 (Unix) PHP/4.4.1 mod_ssl/2.8.25 OpenSSL/0.9.7e-p1

All runs just fine with the server.dbs, the only problem I have with that is that the WebAdmin only show 57 users and I can't add more users in the WebAdmin (img >> add-user.jpg (http://cpg133.xf9.co.uk/albums/userpics/10002/add-user.jpg)) !?! And beside from that (which I can work around) I liked to run it on MySql so its a part of the backup routine (more easily)..

Hope someone can help me, I'm loosing my mind here.. ;) thanks in advance, and sorry for my English …
marcelrx
19-11-2005, 12:56
Why you didn't post the server.ini settings?
This is the only intersting thing.
Have you activated mysql in the server.ini?
mrdeath
19-11-2005, 13:00
Why you didn't post the server.ini settings?
This is the only intersting thing.
Have you activated mysql in the server.ini?

Link in the QUOTE area.. --> server.ini (http://t4a.se/server.ini)
mrdeath
19-11-2005, 13:24
Finally I get an error ;)

---------------------------------------------------------------
-------------- log started at 19-11-05 13:19 -------------
---------------------------------------------------------------
19-11-05 13:19:47,ALL,Info,server, Server init initialized
19-11-05 13:19:47,ALL,Info,server, Server version: 2.0.21.3 Linux
19-11-05 13:19:47,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
19-11-05 13:19:47,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 19-11-05 13:19 --------------
---------------------------------------------------------------


I have try with the mysql user that I created for this server and mysql root user, same results.. I think I have seen topics about this problem.. heading down and reading.. hope I find something… :rolleyes:
mrdeath
19-11-2005, 13:42
System: Linux (logical)

I changed the hostname of local host on 127.0.0.1

Hostname=127.0.0.1
but it did not help me...
mrdeath
19-11-2005, 14:07
I got the server to start with MySql by;

first update the mysql user;

UPDATE mysql.user SET Password = OLD_PASSWORD('<new-passowrd>') WHERE Host = 'home' AND User = 'teamspeak';

and changed the "hostname" in the server.ini;

Hostname=home

-------------- log started at 19-11-05 13:57 -------------
---------------------------------------------------------------
19-11-05 13:57:18,ALL,Info,server, Server init initialized
19-11-05 13:57:18,ALL,Info,server, Server version: 2.0.21.3 Linux
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 19-11-05 13:57 --------------
---------------------------------------------------------------

but now I can't connect to the http://<Web Admin>:14534 ??? I'm going to try to "drop all" in the db and let the teamspeak scripts create a new one.. (don't know what I have hacked ;) )..

<edit>
Naaaa... its not starting at all ... its crashing;
--------------- log ended at 19-11-05 14:14 --------------
---------------------------------------------------------------
19-11-05 14:15:44,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
19-11-05 14:15:44,ERROR,All,SERVER, Start_Server: unable to open database
mrdeath
19-11-2005, 14:30
I'm back to "ts not creating any tables in the mysql db" (but its not creating any server.dbs either, and that’s a good thing, yes?)

Using mysql root user on localhost.. and its working localy with mysql, but the server.ini is saying "Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password"....

I'm giving up for today.. my users have been offline long enough.. Its sad, I rely wanted it to work... well well back to the server.dbs use.. .

<edit> where do I signup for beta testing teamspeak3 :rolleyes: ;)
siepel
23-11-2005, 22:46
Use the search please........

This problem has been asked then thousand times.

Make mysql user and password via command line (not thru phpmyadmin)

alter 2 sql files

get the libmysql.s0.10.0 in the same dir.
mrdeath
24-11-2005, 00:09
Use the search please........

This problem has been asked then thousand times.

Make mysql user and password via command line (not thru phpmyadmin)

alter 2 sql files

get the libmysql.s0.10.0 in the same dir.

I have used search... Never used phpmyadmin (I have direct access to my server) ... Have not seen a post about alter any sql files? and it seens to find libmysqlclient.so* just fine...