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

[karimali831]

Hey,

I'm running linux full version. How do I unban myself?
Also how can I track who banned me.. is there a server log in the ts folder or something?

Thanks for any help

[nickill2]

There should be a TS log. I know there is for the windows one. Just check in there. I dont know tho, it may not say who did it. But, It mit. Its worth a try tho lol

[boebi]

1)ask one of your admins to unban you
2)edit the mysql ?
3)re.install server
4)wait till ur unbanned again (wont work if ur perma)

Im just a amateur, maybe there are more ways.

[Reedy Boy]

It would be recorded in the database who banned you

I believe


To fix it, you need to delete the row from the database



Are you using the sqlite db or mysql?

If mysql, its load easier

[karimali831]

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

[Kymmy]

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 which might be easier.

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

Kymmy

[karimali831]

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 which might be easier.

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

Kymmy

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]

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

[karimali831]

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

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

[Kymmy]

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

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

[karimali831]

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

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]

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

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

[karimali831]

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*]

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]

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