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--)

[McGriffin]

Ah ok - thank you !
now I've done the chown -R teamspeak /opt/ts3 again
it's possible to log into the server

tried both serveradmin passwods - from server a & server b
but after this, I don't have the permission to log in as SA anymore

I'm on guest status

how do I fix this ?

[florian_fr40]

I seen in your pastbin that the server has create a new database.

So according your first post, stop this server, overwrite the database file with your old one and start your server.
Y'll got your old virtual servers and permissions.

[McGriffin]

äääähhhhm....
WHAT! ?
lol

where can I find the relevant files to replace...'
you're talkin about "the old one" - do you mean the files directly from server a...
(new install on server b)
if you mean those files - where can find 'em
is it the ts3server.sqlitede you're talkin' about? I replaced that already
ore do you mean the libts3db's in ts3 folder ?
I cant find any other - even not under /etc/init.d/teamspeak

like some people sometimes like to say... in directly translation...
I don't see the wood because of all the trees

[florian_fr40]

Ok make a point

it seems that i don't have a possibility to copy all my work from one server to another

Basicaly, you just have to copy/paste the sqlitedb file (and files "folder").
(Copy - stop old server - paste in the new - start the new)

Don't forget you can start 2 differents Teamspeak server with the same database at the same time.

Also, check the server log from the new Teamspeak server.

[McGriffin]

ok
I traveled whith the data physicly to another machine

here is alway running just one server at the time
if I'm talking about different ts3 folders - I just mean the folders
anyway...

I have to begin from installing the server new
no problem
but what I don't understand is
I'm on the "new" server as "SA"
I copy - the ts3server.sqlitedb & the files folder to the new ts3 directory

I log into the "new" server as "Guest"... "SA" isn't possible... until here everything is just fine
... this is where I got my old channels & user settings back
at this point
if I get you right...
I have to copy the ts3server.sqlitedb directly from the running server(-folder)
to get the SA permission ?
I cut some words in this case to make it more clearly for me... (on one machine)
(Copy - stop server - paste in - start )
is this the way?... this doesn't make any sense...

log file says...
2012-03-28 09:09:22.460442|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.2 (2012-02-29 05:39:32)
2012-03-28 09:09:22.462303|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2012-03-28 09:09:22.462428|INFO |DatabaseQuery | | dbPlugin version: 3.7.3
2012-03-28 09:09:22.463065|INFO |DatabaseQuery | | checking database integrity (may take a while)
2012-03-28 09:09:22.543083|WARNING |Accounting | | Unable to find valid license key, falling back to limited functionality
2012-03-28 09:09:22.583128|INFO |FileManager | | listening on 0.0.0.0:30033
2012-03-28 09:09:22.817533|INFO |CIDRManager | | updated query_ip_whitelist ips: 127.0.0.1,
2012-03-28 09:09:22.818398|INFO |Query | | listening on 0.0.0.0:10011

seems after copy & paste there is a kind of an entry about the first used token ore something like this
anyway it isn't possible by entering old ore new password to get SA rights

--- Merged ---

thanks again
thread can be closed
nobody told me you have to create a new token before traveling
this brought the result
greetings

[florian_fr40]

Strange, normally you haven't to create a new privilege key for the same database file (same after a "transfer")

[McGriffin]

remember
after trasfer - your datas are on another machine
& on a different ts3 server (software)
because of
a different start-token
& a different password for serveradmin

it doesn't work for me without the "new" token
because it doesn't work with old ore new password after transfering the data
& anyway - with this "have to" - the (transferred) datas are much more save
for me - this make sense