[SOLVED] beta 15 server crash

[Crackerjam]

The server starts up for a few seconds, then just closes. Here are the contents of the log:

2010-01-18 21:31:51.078125|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta15 [Build: 9884]
2010-01-18 21:31:51.093750|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, (c)TeamSpeak Systems GmbH
2010-01-18 21:31:51.093750|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
2010-01-18 21:31:51.109375|INFO    |DatabaseQuery |   | checking database integrity
2010-01-18 21:31:52.875000|INFO    |Accounting    |   | Licensing Information
2010-01-18 21:31:52.937500|INFO    |Accounting    |   | type              : Non-profit
2010-01-18 21:31:53.062500|INFO    |Accounting    |   | starting date     : Wed Dec 23 18:00:00 2009
2010-01-18 21:31:53.187500|INFO    |Accounting    |   | ending date       : Thu Dec 23 18:00:00 2010
2010-01-18 21:31:53.437500|INFO    |Accounting    |   | max virtualservers: 10
2010-01-18 21:31:53.531250|INFO    |Accounting    |   | max slots         : 512
2010-01-18 21:31:54.093750|CRITICAL|PermissionMgr |   | SERVERINSTANCE_TEMPLATE_SERVERADMIN_GROUP points to an not available sgid: 3

How can I fix this issue?

[Jonybat]

Hi

SERVERINSTANCE_TEMPLATE_SERVERADMIN_GROUP points to an not available sgid: 3

Means that you deleted the Server Admin Template Group...

...in other words:

i know peopel refuse to read, so here its again:

! make sure that the changes below reflect your setup else you will break your server
+ added SERVERINSTANCE_TEMPLATE_SERVERDEFAULT_GROUP, SERVERINSTANCE_TEMPLATE_CHANNELADMIN_GROUP,
SERVERINSTANCE_TEMPLATE_CHANNELDEFAULT_GROUP this properties are used now while creating
a new virtualserver for selecting the needed groups.


this counts for all people who thought its a nice idea to remove template groups. if you not familar with sql the only way for you to get a working server is to remove the database / reinstall the server. this would also give you the latest default permissions...

Regards

[Crackerjam]

Crap.

Can anyone be so kind as to give me a nice little SQL query that'll restore the server admin template group?, or both template groups for that matter.

[Crackerjam]

Well, got it fixed. Turns out I had to export the sqlite database into an sql file, reinstall the server, and run a query of all the INSERT lines into the newly created database. That sucked, and I will never delete group templates again.

[GrexAut]

Have you deleted the old database?, or have you imported the new database into the old ?

[Crackerjam]

imported the old into the new

[GrexAut]

with sqliteman ?

[Crackerjam]

sqlitebrowser

I had to export the old to an sql file, then go through it with notepad and delete every line that wasn't an INSERT line.

Then, open the new ts database in sqlitebrowser, go over to the SQL query tab, and past all the code that's in that edited sql file.

[xcalibur]

Can someone help me fix this using mysql?

I have a .sql of my database and of a new install database. What sql command do I need to run to fix the missing groups?

[ANR Daemon]

If you already have new database created by b15 server, just import server data from a backup SQL. (I.e. don't delete/create tables)

[xcalibur]

When I try to upload the edited sql I get this error.

Error

SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `bindings`
--
--
-- Dumping data for table `bindings`
--
INSERT INTO `bindings` ( `binding_id` , `ip` , `type` )
VALUES ( 1, '0.0.0.0', 0 ) , ( 2, '0.0.0.0', 1 ) , ( 3, '0.0.0.0', 2 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'

[Jonybat]

I got that also when doing some tests converting sqlite database in mysql. I solved that by removing all the "DROP" and "CREATE" lines in the SQL file (so, all but all the INSERT lines) and cleaning all the tables (not deleting), with "TRUNCATE" command ("truncate table 'tablename';").

[xcalibur]

Isn't there a way of adding the missing groups to my existing database?
This entire merging thing isn't working very well for me..

[xcalibur]

I got my channels back by deleting the channels and channel permissions tables in my database, importing those from the good database. That's good enough for me. I don't need the rest of the server group permissions or other changes.

Would doing this with the channels cause any problems?


EDIT: This didn't save any permissions per channel.

[ANR Daemon]

When I try to upload the edited sql I get this error.

Error

SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `bindings`
--
--
-- Dumping data for table `bindings`
--
INSERT INTO `bindings` ( `binding_id` , `ip` , `type` )
VALUES ( 1, '0.0.0.0', 0 ) , ( 2, '0.0.0.0', 1 ) , ( 3, '0.0.0.0', 2 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'

Hint: REPLACE