Upgrading database script

[rottweilertje]

My server doesn't start because of an upgrade of the databasescript, but why is he doing this?

==================

%cat server.log
---------------------------------------------------------------
-------------- log started at 06-03-04 14:34 -------------
---------------------------------------------------------------
06-03-04 14:34:36,ALL,Info,server, Server init initialized
06-03-04 14:34:36,ALL,Info,server, Server version: 2.0.19.51 Linux
06-03-04 14:34:36,WARNING,Info,SQL, created table ts2_servers
06-03-04 14:34:36,WARNING,Info,SQL, created table ts2_server_privileges
06-03-04 14:34:36,WARNING,Info,SQL, created table ts2_channels
06-03-04 14:34:36,WARNING,Info,SQL, created table ts2_channel_privileges
06-03-04 14:34:36,WARNING,Info,SQL, created table ts2_clients
06-03-04 14:34:36,WARNING,Info,SQL, created table ts2_bans
06-03-04 14:34:36,ALL,Info,db, Upgrading database script upgrade_3.sql
06-03-04 14:34:36,ERROR,All,SQL, SQL file not found /usr/games/teamspeak/tss2_rc2/sqlite_sql/upgrade_3.sql
06-03-04 14:34:36,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: select dt_client_lastonline from ts2_clients
06-03-04 14:34:36,ERROR,All,db, Upgrading failed!
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 06-03-04 14:34 --------------
---------------------------------------------------------------

==================

System:
FreeBSD 5.1-RELEASE
With all needed ports and packages
PII 366 overclocked to 450 MHz
No GUI

Can someone help me solving this problem?

[madcat]

download the package again and make sure the file sqlite_sql/upgrade_3.sql is located on the correct place
also make sure you have filled the server.ini correctly and have a database selected

[rottweilertje]

In the package is no "upgrade_3.sql" I don't know why not but there just ain't any.

And how does a normal usable server.ini looks like?

Mine is like this:

==================

# cat server.ini
[Main Config]
BoundToIp1=

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL

==================

I know that the BoundToIp1 should have some value (my external IP I gues), but that's not the problem now I think.

[madcat]

Originally posted by rottweilertje
In the package is no "upgrade_3.sql" I don't know why not but there just ain't any.

And how does a normal usable server.ini looks like?

Mine is like this:

==================

# cat server.ini
[Main Config]
BoundToIp1=

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL

==================

I know that the BoundToIp1 should have some value (my external IP I gues), but that's not the problem now I think.

i use mysql as database instead of sqlite, but even i have this file for sqlite, so i advice you to download all the files!
and then try again

and my server.ini is also a bit larger then yours, maybe it's because i use mysql, but take a look, maybe you forgot something

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL

[Main Config]
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=0
BoundToIp1=
AllowedClientNameChars=
DisAllowedClientNameChars=()[]{}

[WebPost]
AdminEmail=
ISPLinkURL=na
ISPName=Private
ISPCountryNumber=4445
Enabled=0
PostURL=
ListPublic=0
UserAgent=teamspeak

[log]
access=1
access_r=1
access_u=1
channel_registerred=1
channel_unregisterred=1
sa=1
chat=1
kick_server=1
kick_channel=1

[Spam]
max_commands=10
in_seconds=2

[DBEXPRESS]
sqldir=/usr/share/teamspeak/pre51/mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
Password= *for my eyes only*
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1