Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 13 of 13
  1. #1
    Join Date
    March 2012
    Posts
    18

    ts3server.sqlitedb Channel Rebuild

    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

  2. #2
    Join Date
    May 2010
    Posts
    6,310
    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).
    Last edited by florian_fr40; March 26th, 2012 at 01:19 PM.

  3. #3
    Join Date
    March 2012
    Posts
    18
    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

  4. #4
    Join Date
    May 2010
    Posts
    6,310
    Please post the "ls -al" result (from the server folder)

  5. #5
    Join Date
    March 2012
    Posts
    18

    another try

    ... 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
    Last edited by McGriffin; March 27th, 2012 at 08:33 AM.

  6. #6
    Join Date
    May 2010
    Posts
    6,310
    Ok thank's for this good report

    But for me it's normal :
    Code:
    118.-rw-r--r-- 1 lorenz    lorenz     290816 2012-03-26 21:10 ts3server.sqlitedb
    ...
    ...
    [email protected]:/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--)

  7. #7
    Join Date
    March 2012
    Posts
    18
    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 ?

  8. #8
    Join Date
    May 2010
    Posts
    6,310
    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.

  9. #9
    Join Date
    March 2012
    Posts
    18
    ääää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

  10. #10
    Join Date
    May 2010
    Posts
    6,310
    Ok make a point

    Quote Originally Posted by McGriffin
    it seems that i don't have a possibility to copy all my work from one server to another
    Quote Originally Posted by Florian
    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.

  11. #11
    Join Date
    March 2012
    Posts
    18
    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
    Last edited by McGriffin; March 30th, 2012 at 06:29 AM.

  12. #12
    Join Date
    May 2010
    Posts
    6,310
    Strange, normally you haven't to create a new privilege key for the same database file (same after a "transfer")

  13. #13
    Join Date
    March 2012
    Posts
    18
    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
    Last edited by florian_fr40; April 2nd, 2012 at 12:55 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 12
    Last Post: August 12th, 2014, 11:03 AM
  2. ts3server.sqlitedb
    By lorheak in forum Server Support
    Replies: 2
    Last Post: September 7th, 2013, 08:08 PM
  3. ts3server.sqlitedb buggy
    By LincolnJunnior in forum Server Support
    Replies: 1
    Last Post: March 25th, 2013, 11:33 AM
  4. Editing ts3server.sqlitedb
    By ivich in forum General Questions
    Replies: 4
    Last Post: April 10th, 2010, 01:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •