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 8 of 8
  1. #1
    Join Date
    April 2010
    Location
    The Netherland
    Posts
    24

    Update to RC1 problems

    I tried to updated the server to the RC1 version

    First i got an error but i solved that already.
    And now i get:

    Code:
    2011-05-28 19:36:38.248030|CRITICAL|SQL           |   | db_CreateTables() unable to load instance default values

  2. #2
    Join Date
    May 2010
    Posts
    6,310
    Hello

    Do you use SQLite or MySQL database version ?
    Are you sure that all files/folders has the same linux user ?
    What did you do exactly ?

    More informations : http://forum.teamspeak.com/showthrea...rting-problems

  3. #3
    Join Date
    April 2010
    Location
    The Netherland
    Posts
    24
    I renamed my old Teamspeak dir.
    Wget the teamspeak tar.gz
    unpacked

    Renamed the dir to the same dir as before
    copied all the file needed, licensekey.dat, inifiles, mysqllibs and so.

    Started the server

    Yes i use the mysql version

    My maplist:
    Code:
    [[email protected] teamspeak_new]$ ls
    CHANGELOG  libmysqlclient.so.15  logs                    serverquerydocs  ts3server.pid            ts3server_minimal_runscript.sh
    LICENSE    libts3db_mysql.so     query_ip_blacklist.txt  sql              ts3server.sqlitedb       ts3server_startscript.sh
    doc        libts3db_sqlite3.so   query_ip_whitelist.txt  ts3db_mysql.ini  ts3server_linux_x86      tsdns
    files      licensekey.dat        serverkey.dat           ts3server.ini    ts3server_linux_x86.pid
    My ts3server.ini
    Code:
    default_voice_port=9987
    dbplugin=ts3db_mysql
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    dblogkeepdays=90
    logpath=logs
    logquerycommands=0
    dbclientkeepdays=30
    ts3db_mysql.ini
    Code:
    [config]
    host='localhost'
    port='3306'
    username='ts3_01'
    password='******'
    database='ts3_01'
    socket=
    ts3 init.d script
    Code:
    #!/bin/sh
    #Teamspeak 3 NOHUP startup script v0.95
    #Written by mancert
    
    ###########################################################################################
    # Remember to start the teamspeak server manually the first time so you get the
    # server admin password and the server admin token.
    # If you want to use mysql database, remember to create a ts3db_mysql.ini file
    # in the folder ts3 in installed in. And make sure ts3server.ini is set right.
    # Changelog @ http://forum.teamspeak.com/showthread.php?t=46989
    #
    # The test start option will check if you are missing anything before you start the script
    #
    ###########################################################################################
    
    ############################ OPTIONS ######################################################
    TITLE='Teamspeak 3 server'                          # Name for the server
    DAEMON='ts3server_linux_x86'                        # Server binary, here the 32bit
    TS3='/home/ts3/teamspeak'      # Path to ts3 binary
    USER='ts3'                                            # User running server
    USERG='ts3'                                          # Usergroup of user
    OPT='inifile=ts3server.ini'                                      # inifile=server.inifile
    LOGFILE='/var/log/ts3.log'                              # Logfile location and file
    ############################ END OPTIONS ##################################################
    
    ########################### NO NEED TO EDIT UNDER HERE ####################################
    precheck () {
    # Checking for sudo
    if [ ! -x /usr/bin/sudo ]; then
      echo ""
      echo "You do not have Sudo installed. Please install it and try again."
      echo "$(date +"%b %a %d  %H:%M:%S"): You do not have Sudo installed." >> $LOGFILE
      echo ""
      exit 1
    fi
    
    # Checking for awk
    if [ ! -x /usr/bin/awk ]; then
      echo ""
      echo "You do not have Awk installed. Please install it and try again."
      echo "$(date +"%b %a %d  %H:%M:%S"): You do not have awk installed." >> $LOGFILE
      echo ""
      exit 1
    fi
    
    # Checking for ts3 binary
    if [ ! -x $TS3/$DAEMON ]; then
      echo "Can't find /"
      echo "Is the configs done right? Is  installed?"
      echo "$(date +"%b %a %d  %H:%M:%S"): Can't find /" >> $LOGFILE
      exit 1
    fi
    echo
    echo "All seems fine, try /etc/init.d/ts3 start"
    echo
    }
    
    service_start() {
    TEST=$(ps ax | grep $DAEMON | grep -v export | grep -v grep | wc -l)
    
    # Server not running and no pid-file found
    if [ "$TEST" = "0" ] && [ ! -f $TS3/ts3server.pid ]; then
      echo
      echo "Starting $TITLE"
      echo "$(date +"%b %a %d  %H:%M:%S"): Starting $TITLE" >> $LOGFILE
      cd $TS3
      LIBPATH=$(pwd)
      su $USER -c "export LD_LIBRARY_PATH=$LIBPATH:$LD_LIBRARY_PATH ; $TS3/$DAEMON $OPT" >> $LOGFILE 2>&1 &
      sleep 1
      sudo -u $USER ps ax | grep -v grep | grep $DAEMON | grep -v export | awk '{print $1}' > $TS3/ts3server.pid
      chown $USER:$USERG $TS3/ts3server.pid
      echo "$TITLE screen process ID written to $TS3/ts3server.pid"
      echo "$TITLE started."
      echo "$(date +"%b %a %d  %H:%M:%S"): $TITLE started" >> $LOGFILE
      echo
      exit 1
    fi
    
    # Server not running and a pid-file is found
    if [ "$TEST" = "0" ] && [ -f $TS3/ts3server.pid ]; then
      echo
      echo "Server not running but pid-file present"
      echo "Removing pid-file"
      echo "$(date +"%b %a %d  %H:%M:%S"): Server not running but pid-file present" >> $LOGFILE
      echo "$(date +"%b %a %d  %H:%M:%S"): Removing pid-file" >> $LOGFILE
      rm $TS3/ts3server.pid
      echo "Old pid file removed"
      echo "$(date +"%b %a %d  %H:%M:%S"): Old pid file removed" >> $LOGFILE
      echo
      echo "Starting $TITLE"
      echo "$(date +"%b %a %d  %H:%M:%S"): Starting $TITLE" >> $LOGFILE
      cd $TS3
      LIBPATH=$(pwd)
      su $USER -c "export LD_LIBRARY_PATH=$LIBPATH:$LD_LIBRARY_PATH ; $TS3/$DAEMON $OPT" >> $LOGFILE 2>&1 &
      sleep 1
      sudo -u $USER ps ax | grep -v grep | grep $DAEMON | grep -v export | grep -v export | awk '{print $1}' > $TS3/ts3server.pid
      chown $USER:$USERG $TS3/ts3server.pid
      echo "$TITLE screen process ID written to $TS3/ts3server.pid"
      echo "$TITLE started."
      echo "$(date +"%b %a %d  %H:%M:%S"): $TITLE started" >> $LOGFILE
      echo
    fi
    
    # Server running and no pid file-found, creates a new one!
    if [ "$TEST" = "1" ] && [ ! -f $TS3/ts3server.pid ]; then
      echo
      echo "Server is running but no pid file. Creating a new pid file!!"
      echo "$(date +"%b %a %d  %H:%M:%S"): Server is running but no pid file. Creating a new pid file!!" >> $LOGFILE
      sudo -u $USER ps ax | grep -v grep | grep $DAEMON | grep -v export | awk '{print $1'} > $TS3/ts3server.pid
      chown $USER:$USERG $TS3/ts3server.pid
      echo
      echo "$TITLE is running and new pid-file created"
      echo "$(date +"%b %a %d  %H:%M:%S"): $TITLE is running and new pid-file created" >> $LOGFILE
      echo
    fi
    
    # Server running and pid-file found
    if [ "$TEST" = "1" ] && [ -f $TS3/ts3server.pid ]; then
      echo
      echo "$TITLE is running!!"
      echo "$(date +"%b %a %d  %H:%M:%S"): $TITLE is running!!" >> $LOGFILE
      echo
    fi
    }
    
    service_stop() {
    TEST1=$(ps ax | grep -v grep | grep $DAEMON | grep -v export | wc -l)
    
    # Server is not running and no pid-file found
    if [ "$TEST1" = "0" ] && [ ! -f $TS3/ts3server.pid ]; then
      echo
      echo "$TITLE is not running!!"
      echo "$(date +"%b %a %d  %H:%M:%S"): $TITLE is not running!!" >> $LOGFILE
      echo
    fi
    
    # Server is not running and pid-file found
    if [ "$TEST1" = "0" ] && [ -f $TS3/ts3server.pid ]; then
      echo
      echo "Server is not running but pid-file is present"
      echo "Removing pid-file"
      echo "$(date +"%b %a %d  %H:%M:%S"): Server is not running but pid-file is present" >> $LOGFILE
      echo "$(date +"%b %a %d  %H:%M:%S"): Removing pid-file" >> $LOGFILE
      rm $TS3/ts3server.pid
      echo
      echo "Pid file removed"
      echo "$(date +"%b %a %d  %H:%M:%S"): Pid file removed" >> $LOGFILE
      echo
    fi
    
    # Server is running but no pid-file found
    if [ "$TEST1" = "1" ] && [ ! -f $TS3/ts3server.pid ]; then
      echo
      echo "$TITLE is running but no pid file found."
      echo "Stopping $TITLE"
      echo "$(date +"%b %a %d  %H:%M:%S"): $TITLE is running but no pid file found." >> $LOGFILE
      echo "$(date +"%b %a %d  %H:%M:%S"): Stopping $TITLE" >> $LOGFILE
      sudo -u $USER ps ax | grep -v grep | grep $DAEMON | grep -v export | awk '{print $1'} > $TS3/$DAEMON.pid
      chown $USER:$USERG $TS3/ts3server.pid
      for id in $(cat $TS3/ts3server.pid)
      do kill -TERM $id
      echo "Killing process ID $id"
      echo "Removing $TITLE pid file"
      rm -rf $TS3/ts3server.pid
      break
      done
      echo "$TITLE stopped"
      echo "$(date +"%b %a %d  %H:%M:%S"): $TITLE stopped" >> $LOGFILE
      echo
    fi
    
    # Server running and pid-file found
    if [ "$TEST1" = "1" ] && [ -f $TS3/ts3server.pid ]; then
      echo
      echo "Stopping $TITLE"
      echo "$(date +"%b %a %d  %H:%M:%S"): Stopping $TITLE" >> $LOGFILE
      for id in $(cat $TS3/ts3server.pid)
      do kill -TERM $id
      echo "Killing process ID $id"
      echo "Removing $TITLE pid file"
      rm -rf $TS3/ts3server.pid
      break
      done
      echo "$TITLE stopped"
      echo "$(date +"%b %a %d  %H:%M:%S"): $TITLE stopped" >> $LOGFILE
      echo
    fi
    }
    case "$1" in
            'start')
            service_start
            ;;
            'stop')
            service_stop
            ;;
            'restart')
            service_stop
            sleep 1
            service_start
            ;;
            'test')
            precheck
            ;;
            *)
            echo "Usage ./ts3conf start|stop|restart|precheck"
    esac
    Command i run to start
    Code:
    sudo /etc/init.d/ts3 start
    Last edited by burnacid; May 29th, 2011 at 06:21 PM.

  4. #4
    Join Date
    April 2010
    Location
    The Netherland
    Posts
    24
    So i just deleted everything and redone it.

    Now it works, why idk.

  5. #5
    Join Date
    May 2010
    Posts
    6,310
    Quote Originally Posted by burnacid View Post
    So i just deleted everything and redone it.
    Now it works, why idk.
    Delete what ? The server files and folder (or the database datas) ?

  6. #6
    Join Date
    April 2010
    Location
    The Netherland
    Posts
    24
    Everything exept the ini files and the database ofc

  7. #7
    Join Date
    May 2010
    Posts
    6,310
    hm ok like a new (fresh) update.
    The main info, is that works for you

  8. #8
    Join Date
    April 2010
    Location
    The Netherland
    Posts
    24
    I did the same as the first time in my knowlage.
    But what ever, topic may be closed!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Resolved] Problems with IDNs after update to rc1
    By Baraan in forum Bug Reports [EN/DE]
    Replies: 6
    Last Post: May 20th, 2011, 10:51 AM
  2. MIc problems Since new update
    By Alrakis in forum Bug Reports [EN/DE]
    Replies: 0
    Last Post: May 13th, 2011, 06:04 AM
  3. Problems with IDNs after update to rc1
    By Baraan in forum Client Support
    Replies: 0
    Last Post: May 11th, 2011, 09:04 AM
  4. Problems with new update
    By ricoboy23 in forum Bug Reports [EN/DE]
    Replies: 6
    Last Post: June 7th, 2010, 01:31 PM
  5. After Update from 22 to 23 Some little Problems
    By TSlein in forum Linux / FreeBSD
    Replies: 1
    Last Post: June 3rd, 2010, 09:53 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
  •