Ok I got banned of my own server.. what to do? [Archive]

Kymmy

03-03-2007, 10:43

I really don't know...
How can I check what I'm using?

Check your server.ini, do you have a section starting with the following?

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql

If so then you are running a MYSQL database and will need to use something like phpMyAdmin to edit the Database.

There is actually a couple of threads on this like this one (http://forum.goteamspeak.com/showthread.php?t=35457&highlight=banned) which might be easier.

Also can't you just use the Superadmin account to re-add you?

Kymmy :cool:

karimali831

03-03-2007, 16:19

Check your server.ini, do you have a section starting with the following?

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql

If so then you are running a MYSQL database and will need to use something like phpMyAdmin to edit the Database.

There is actually a couple of threads on this like this one (http://forum.goteamspeak.com/showthread.php?t=35457&highlight=banned) which might be easier.

Also can't you just use the Superadmin account to re-add you?

Kymmy :cool:

No I don't have those lines

a) How do I use a "MySQL" Database for my server.
b) By removing my SA account and adding a new one I am banned? Doesn't the IP ban not the account?

Thanks for your help!

Karim =)

Kymmy

03-03-2007, 17:01

No I don't have those lines

a) How do I use a "MySQL" Database for my server.
b) By removing my SA account and adding a new one I am banned? Doesn't the IP ban not the account?

Thanks for your help!

Karim =)

Answers :

a) check the INSTALL.mysql file that came with teamspeak, this will give you what to put in server.ini. Apart from that you'll need to set up a blank database and assign a user, easy to do with Cpanel, a bit harder with PHPmyadmin. (just be aware there are a few pitfalls like the need to use old mysql style passwords if you use V4.1 or above) also check the stickies as there was also a mysql query error that I don;t think has been corrected.)

b) Yep, and I remember you saying from another post that you have a VPS, I forgot and presumed that you had it on a home PC which the LAN IP addy is very easily changable. Follow the link here http://forum.goteamspeak.com/showthread.php?t=25690 (link by Reedyboy in another post) to a post on how to edit the server.dbs file, but if you;re going to MySQL then you might as well reset it all as you set up mysql anyway.

Kymmy :cool:

karimali831

03-03-2007, 18:25

Answers :

a) check the INSTALL.mysql file that came with teamspeak, this will give you what to put in server.ini. Apart from that you'll need to set up a blank database and assign a user, easy to do with Cpanel, a bit harder with PHPmyadmin. (just be aware there are a few pitfalls like the need to use old mysql style passwords if you use V4.1 or above) also check the stickies as there was also a mysql query error that I don;t think has been corrected.)

b) Yep, and I remember you saying from another post that you have a VPS, I forgot and presumed that you had it on a home PC which the LAN IP addy is very easily changable. Follow the link here http://forum.goteamspeak.com/showthread.php?t=25690 (link by Reedyboy in another post) to a post on how to edit the server.dbs file, but if you;re going to MySQL then you might as well reset it all as you set up mysql anyway.

Kymmy :cool:

Thanks Kymmy, ok I edited the server.ini file and created a databse. How do I assign a user to it? (using cpanel or phpmyadmin) I don't mind. Yeah I am hosting on a VPS and will be moving to a dedicated server soon.

Yeah I am aware of that, I first want to set up this mysql that's how far I've got.

Thank you very much for your help
- Karim :cool:

Kymmy

03-03-2007, 22:27

Thanks Kymmy, ok I edited the server.ini file and created a databse. How do I assign a user to it? (using cpanel or phpmyadmin) I don't mind. Yeah I am hosting on a VPS and will be moving to a dedicated server soon.

Yeah I am aware of that, I first want to set up this mysql that's how far I've got.

Thank you very much for your help
- Karim :cool:

Cpanel is the easiest, Just create a new database, create a user (unless you already have done for another db), then give the user ALL access to the database. it only takes a few clicks.

Make sure that when you specify the user and database name in server.ini that you include the prefix on both (it normally prefixes the names with the cpanel username)

BTW...what version of MySQL are you using? if 4.1 or above then you'll either have restart mysql with OLDPASSWORDS flag set, or convert the password you made into an old password style hash. Search for oldpassword in the forums.

Kymmy :cool:

karimali831

04-03-2007, 01:28

Cpanel is the easiest, Just create a new database, create a user (unless you already have done for another db), then give the user ALL access to the database. it only takes a few clicks.

Make sure that when you specify the user and database name in server.ini that you include the prefix on both (it normally prefixes the names with the cpanel username)

BTW...what version of MySQL are you using? if 4.1 or above then you'll either have restart mysql with OLDPASSWORDS flag set, or convert the password you made into an old password style hash. Search for oldpassword in the forums.

Kymmy :cool:

Aghhh sorry, I am a total newbie when it comes to mysql on teamspeak basis and I'm totally lost.
a) How do I give the user all access to the database?
b) I created a user assigned it to the database if that's what you mean
c) How do I find out what version of php im using?

Thanks -

Kymmy

04-03-2007, 12:04

Aghhh sorry, I am a total newbie when it comes to mysql on teamspeak basis and I'm totally lost.
a) How do I give the user all access to the database?
b) I created a user assigned it to the database if that's what you mean
c) How do I find out what version of php im using?

Thanks -

Yes, giving a user access to the database is the same as ALL access, cpanel defaults to this when you give a user access, where as PHPmyadmin is a bit more complicated.

PHP version? Now that's not relevant to teamspeak so I refuse to answer :p

Only joking! It should say in the SERVER INFO section at the bottom left of the cpanel main page, if not just create a info.php file and place in it this one line

<?phpinfo()?>

Then upload it to your website and point your web browser at the file. That'll give you the full rundown on all your PHP ver and settings.

Kymmy :cool:

karimali831

31-03-2007, 12:55

Ok I did that and edited the variables of this and added this section at the end of the "server.ini" file but when running the start command I get

"
WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
starting the teamspeak2 server
Error starting daemon. Aborted
"

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=username_database
Hostname=localhost
User_name=username_username_of_database
Password=password_of_database
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmysqlclient_r.so.14.0.0
LibraryName=./libsqlmy.so
Active=1

Katana*GFR*

31-03-2007, 15:13

Create a user that will run the TS Server. Then start the server. ( dont forget to make it so that the user has the needed right's on the TS dir.

Kymmy

31-03-2007, 16:24

Also check your server.log and see exactly why the server failed to start as even though you were running as root it still should have started.

Kymmy :cool:

karimali831

01-04-2007, 03:24

Kymmy

01-04-2007, 11:35

ooo

31-03-07 12:02:10,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load libmysqlclient_r.so.14.0.0
31-03-07 12:02:10,ERROR,All,SERVER, Start_Server: unable to open database

OMG. I'm sure it's correct. I'll check with the host.

OK I had this problem to, Teamspeak doesn;t seem to like the 14.0.0 lib files, here's the link (http://forum.goteamspeak.com/attachment.php?attachmentid=705) to the 10.0.0 lib files just don;t forget to also change in server.ini the VendorLib=libmysqlclient_r.so.14.0.0

Kymmy :cool:

Kymmy

01-04-2007, 11:57

OK I had this problem to, Teamspeak doesn;t seem to like the 14.0.0 lib files, here's the link (http://forum.goteamspeak.com/attachment.php?attachmentid=705) to the 10.0.0 lib files just don;t forget to also change in server.ini the VendorLib=libmysqlclient_r.so.14.0.0

I noticed that the linked file doesn;t include both 10.0.0 files so here's a zip file with both.

Kymmy :cool:

karimali831

01-04-2007, 14:28

Hmm what must I do with these files?

karimali831

01-04-2007, 14:36

Ok well I told my host to use these files instead, and I must change ::

VendorLib=libmysqlclient_r.so.14.0.0
to
VendorLib=libmysqlclient_r.so.10.0.0

right?

Kymmy

01-04-2007, 15:07

Ok well I told my host to use these files instead, and I must change ::

to

right?

If you;re on a VPS just put these files in the /USR/LIB/ directory and change your server.ini to point to them

VendorLib=/usr/liblibmysqlclient_r.so.10.0.0

Kymmy :cool:

karimali831

01-04-2007, 15:45

If you;re on a VPS just put these files in the /USR/LIB/ directory and change your server.ini to point to them

VendorLib=/usr/liblibmysqlclient_r.so.10.0.0

Kymmy :cool:

Thank you very much,
but now the error is:

[/quote]01-04-07 14:42:07,ALL,Info,server, Server init initialized
01-04-07 14:42:07,ALL,Info,server, Server version: 2.0.23.15 Linux
01-04-07 14:42:07,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
01-04-07 14:42:07,ERROR,All,SERVER, Start_Server: unable to open database[/quote]

I am sure the information is correct.

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=username_database_name
Hostname=localhost
User_name=username_username (of database)
Password=password (of database)
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient.so.10.0.0
LibraryName=./libsqlmy.so
Active=1

Kymmy

01-04-2007, 15:50

Thank you very much,
but now the error is:

01-04-07 14:42:07,ALL,Info,server, Server init initialized
01-04-07 14:42:07,ALL,Info,server, Server version: 2.0.23.15 Linux
01-04-07 14:42:07,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
01-04-07 14:42:07,ERROR,All,SERVER, Start_Server: unable to open database[/quote]

I am sure the information is correct.

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=username_database_name
Hostname=localhost
User_name=username_username (of database)
Password=password (of database)
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient.so.10.0.0
LibraryName=./libsqlmy.so
Active=1[/quote]

OK, yet another teamspeak fault coming up :)

I presume you;re using a MYSQL version of 4.1 or higher, which uses an extended md5 hash to encrypt passwords, Teamspeak only seems to work with the old style passwords. You need to set the OLD_PASSWORDS flag to on and then restart Mysql or the whole server. Best if you ask your hoster to do this but if you have WHM access it is on the TWEAK SETTINGS section.

Kymmy :cool:

karimali831

01-04-2007, 18:38

01-04-07 14:42:07,ALL,Info,server, Server init initialized
01-04-07 14:42:07,ALL,Info,server, Server version: 2.0.23.15 Linux
01-04-07 14:42:07,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
01-04-07 14:42:07,ERROR,All,SERVER, Start_Server: unable to open database

I am sure the information is correct.

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=username_database_name
Hostname=localhost
User_name=username_username (of database)
Password=password (of database)
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient.so.10.0.0
LibraryName=./libsqlmy.so
Active=1[/quote]

OK, yet another teamspeak fault coming up :)

I presume you;re using a MYSQL version of 4.1 or higher, which uses an extended md5 hash to encrypt passwords, Teamspeak only seems to work with the old style passwords. You need to set the OLD_PASSWORDS flag to on and then restart Mysql or the whole server. Best if you ask your hoster to do this but if you have WHM access it is on the TWEAK SETTINGS section.

Kymmy :cool:[/QUOTE]

Wow now you have confused me completely. How do I set OLD-PASSWORDS flag ?
I know how to restart the mysql or the whole server. I have WHM ok, from the TWEAK SETTINGS I'll restart it but how do I set old passwords flag?

karimali831

01-04-2007, 19:27

OMG DID THAT and still don't work.. from tweak settings I ticked the box "use old stlye passwords"

restart mysql service... type in start command.. aborting :(

Kymmy

01-04-2007, 19:58

OMG DID THAT and still don't work.. from tweak settings I ticked the box "use old stlye passwords"

restart mysql service... type in start command.. aborting :(

Don;t panic, we're taking it step by step :)

Have you checked the server.log to see if it's the same error, as there are a few other faults in the general teamspeak install in reference to MySQL.

Kymmy :cool:

karimali831

01-04-2007, 21:34

The reason I am panicing is because I got the same error :(

01-04-07 20:32:02,ALL,Info,server, Server init initialized
01-04-07 20:32:02,ALL,Info,server, Server version: 2.0.23.15 Linux
01-04-07 20:32:02,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
01-04-07 20:32:02,ERROR,All,SERVER, Start_Server: unable to open database

Hey I trust you :)
Can you look into my ROOT FTP PLease?

Kymmy

01-04-2007, 23:02

OK, a few simple steps.

Check using the phpinfo that old passwords flag is set to on
if not on try the methods posted earlier to get it to on, rebooting if needed
delete the database and db user and readd to make sure that the password is correct
make sure the user and db has the prefix in server.iniif you do all that and it's still not working then we'll go from there

Kymmy :cool:

karimali831

02-04-2007, 03:01

Still not working :(
Shall I PM you with the root/whm details?

Kymmy

02-04-2007, 09:49

Still not working :(
Shall I PM you with the root/whm details?

Upto you. I'll certainly have a look for you.

Kymmy :cool:

karimali831

02-04-2007, 13:28

Check your PM :cool:

karimali831

04-04-2007, 13:39

Kymmy you around?

Kymmy

04-04-2007, 14:26

Yeah sorry just getting hammered with work.
Kymmy :cool:

karimali831

04-04-2007, 20:00

No problem.

N176DL

05-04-2007, 03:00

Ya know, you can just get Kymmy(spelled right?, sorry)a SA thing for your server and she'll get you unbanned. All you need is the IP, and a SA username and password.

karimali831

05-04-2007, 03:17

Ya know, you can just get Kymmy(spelled right?, sorry)a SA thing for your server and she'll get you unbanned. All you need is the IP, and a SA username and password.

What on earth are you on about? Off topic????
My server has been down for days now because Kymmy is helping me setup my MySQL databse for my teamspeak sever or have a look at it and see if there are any issues. I'll be back in a couple of days.