ts3server.sqlitedb Channel Rebuild

[McGriffin]

Hello,
first of all, sorry 4 the bad english...

my problem is...
it seems that i don't have a possibility to copy all my work from one server to another
i create a lot of channels and some different user-groups & rights on one machine
i can't log into that machine online
what i want to do is, getting all the work on a usb pen, travel to the other server,
putting the work, i did before, on a different machine / server

can anyone please explain, by listing the all the steps, how to do that?

what i tried...
i already tried to replace the ts3server.sqlitedb and so on
if it is replaced i cant log into the server - seems like different token problem
but don't really know
line in log sais

2012-03-25 07:28:33.198059|WARNING |Accounting | | Unable to find valid license key, falling back to limited functionality



got no system-problems ...some kind of an ubuntu
got no hardware problems

i just installed the ts3 server & got it to work on different machines many times,
just for fun & learning
i don't know anything about mysql ore other programs like that
& i don't have really so much time 4 learning stuff like this... anyway

please help & thank you

[florian_fr40]

Hello

What is the operating system of both machine ?
Basicaly, you just have to copy/paste the sqlitedb file (and files "folder").
(Copy - stop old server - paste in the new - start the new)

About the license message, this is just to inform you that there is no license file in the server folder (not really an error message - except if you have one).

[McGriffin]

Thank you for fast answering.
Systems are Zorin OS 5.2 64bit (Ubuntu based)
first of all i set up a fresh server to make sure there is no data-mismatch...
than i followed your steps - did it right the way you told to do...
after that...
ts3server_startscript.sh start...
Starting the TeamSpeak 3 server
TeamSpeak 3 server started, for details please view the log file
& the relevant lines are...
2012-03-27 13:38:44.343021|ERROR |DatabaseQuery | | db_connect () failed unable to open database file
2012-03-27 13:38:44.343087|CRITICAL|ServerLibPriv | | Server() DatabaseError out of memory

think i don't have to tell you that there is no possibility to log in to that server any more

[florian_fr40]

Please post the "ls -al" result (from the server folder)

[McGriffin]

... same result
Good morning
this is exactly what I try to do this morning on a different machine but same system
Paste Expiration: 1 Day

it contains all the steps including "ls -al" result (from the server folder) & the whole log entries
hope anyone can find the error (I produce?)

this is the last log etry
2012-03-28 05:48:55.486291|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.2 (2012-02-29 05:39:32)
2012-03-28 05:48:55.577095|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2012-03-28 05:48:55.578025|INFO |DatabaseQuery | | dbPlugin version: 3.7.3
2012-03-28 05:48:55.602387|INFO |DatabaseQuery | | checking database integrity (may take a while)
2012-03-28 05:48:55.777384|WARNING |Accounting | | Unable to find valid license key, falling back to limited functionality
2012-03-28 05:48:55.807478|ERROR |DatabaseQuery | | db_exec failed attempt to write a readonly database
2012-03-28 05:48:55.807647|ERROR |DatabaseQuery | | db_exec() delete from instance_properties where string_id = '' ; error: attempt to write a readonly database
2012-03-28 05:48:55.807757|ERROR |ServerLibPriv | | Server() error while starting servermanager, error: database error
2012-03-28 05:48:55.808097|ERROR |DatabaseQuery | | db_exec failed attempt to write a readonly database
2012-03-28 05:48:55.808219|ERROR |DatabaseQuery | | db_exec() delete from instance_properties where string_id = '' ; error: attempt to write a readonly database

got no more ideas & stop here (maybe because of don't or misunderstanding this posts)
& yes my english is to bad - but I'm workin' on it

[florian_fr40]

Ok thank's for this good report

But for me it's normal :

118.-rw-r--r-- 1 lorenz    lorenz     290816 2012-03-26 21:10 ts3server.sqlitedb
...
...
121.root@royalroutpw:/opt/ts3# sudo -u teamspeak /opt/ts3/ts3server_startscript.sh start

172.2012-03-28 05:10:44.350340|ERROR   |DatabaseQuery |   | db_exec failed attempt to write a readonly database
173.2012-03-28 05:10:44.350467|ERROR   |DatabaseQuery |   | db_exec() delete from instance_properties where string_id = '' ; error: attempt to write a readonly database
174.2012-03-28 05:10:44.350553|ERROR   |ServerLibPriv |   | Server() error while starting servermanager, error: database error
175.2012-03-28 05:10:44.350887|ERROR   |DatabaseQuery |   | db_exec failed attempt to write a readonly database
176.2012-03-28 05:10:44.350993|ERROR   |DatabaseQuery |   | db_exec() delete from instance_properties where string_id = '' ; error: attempt to write a readonly database

You try to start the server as teamspeak. But the owner of this sqlitedb file is lorenz so the server has to use the "guest" permission. And the guest permission is just read (rw-r-- r--)