server exe starts fine but the windows service doesnt.

[Mograph]

I have set up TS with mysql5 database and its been running great when you start it from the server_windows.exe

but I install the service and when I try to start the service it errors out with

the service startted and stopped straight away message.

I've been looking round the forums and cant find a topic that covers the issue I'm having. below is the extract of my server log with successful startup uwing the normal exe and then the failed startup from the service.

(note i've hashed out details that i dont want public, I know they are correct)
my server.ini

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL
[Main Config]
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
AllowedClientNameChars=
DisAllowedClientNameChars=()[]{}
BoundToIp1=
[WebPost]
AdminEmail=andrew@andrew-wade.co.uk
ISPLinkURL=http://www.ownedalliance.com
ISPName=Private
ISPCountryNumber=4259
Enabled=0
PostURL=
ListPublic=1
UserAgent=teamspeak
[log]
access_r=0
access_u=0
channel_registerred=0
channel_unregisterred=0
sa=0
chat=0
kick_server=0
kick_channel=0
[Spam]
max_commands=10
in_seconds=2

[DBEXPRESS]
sqldir=mysql_sql\
DriverName=openodbc
Database=DSN=########;DB=#########
User_name=######
Password=######
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=ODBC32.DLL
Active=1

[ISP]
GFX URL=http://www.ownedalliance.com/image.jpg

My server log from successful start

---------------------------------------------------------------
-------------- log started at 16-04-09 23:28 -------------
---------------------------------------------------------------
16-04-09 23:28:23,ALL,Info,server,	Server init initialized
16-04-09 23:28:23,ALL,Info,server,	Server version: 2.0.24.1 Win32
16-04-09 23:28:23,WARNING,Info,SQL,	created table ts2_servers
16-04-09 23:28:23,WARNING,Info,SQL,	created table ts2_server_privileges
16-04-09 23:28:23,WARNING,Info,SQL,	created table ts2_channels
16-04-09 23:28:23,WARNING,Info,SQL,	created table ts2_channel_privileges
16-04-09 23:28:23,WARNING,Info,SQL,	created table ts2_clients
16-04-09 23:28:24,WARNING,Info,SQL,	created table ts2_bans
16-04-09 23:28:24,ALL,Info,server,	Starting VirtualServer id:1 with port:8767
16-04-09 23:28:24,ALL,Info,server,	Started VirtualServer id:1 with port:8767
16-04-09 23:28:24,WARNING,Info,SERVER,	Default VirtualServer created
16-04-09 23:28:24,WARNING,Info,SERVER,	admin account info: username: admin password: #####
16-04-09 23:28:24,WARNING,Info,SERVER,	superadmin account info: username: superadmin password: #####
16-04-09 23:28:24,ALL,Info,server,	Server init finished
16-04-09 23:28:29,ERROR,All,frmMain,	unable to detect external ip

My Unsuccessful Log from the service starting up

---------------------------------------------------------------
-------------- log started at 16-04-09 23:28 -------------
---------------------------------------------------------------
16-04-09 23:28:09,ALL,Info,server,	Server init initialized
16-04-09 23:28:09,ALL,Info,server,	Server version: 2.0.24.1 Win32
16-04-09 23:28:09,ERROR,All,SQL,	SQL file not found mysql_sql\create_servers.sql
16-04-09 23:28:09,ERROR,All,SQL,	unable to create table
16-04-09 23:28:09,ERROR,All,SERVER,	Start_Server: unable to create tables
16-04-09 23:28:09,ERROR,All,GENERAL,	critical error, shutdown initiated

Anyone have ideas on why the service wont start but the normal server exe will?

[BHKai]

Where is the normal server exe?

Where is the service server exe?

[Mograph]

both are located in c:\program files\teamspeak2_rc2\

[Mograph]

SOLVED

you need to use the fll path to the mysql_sql folder when using a mysql database by the looks of things.

[DBEXPRESS]
sqldir=c:\program files\teamspeak2_rc2\mysql_sql\
DriverName=openodbc

That solved my issue

change the path to the right one and it works

[ANR Daemon]

Right. That was one of the issues mentioned in MySQL thread, if you care to read it.

[Mograph]

Right. That was one of the issues mentioned in MySQL thread, if you care to read it.

Onece again your useful ness exceeds expectations, you have been promoted from Chocolate teapot to, chocolate fireguard.

Dunno why its in that thread as it isnt a MySQL issue - like I said the normal server_windows.exe runs fine so there is nothing wrong with any of the settings to mak it work with MySQL Its to do with the service executable needing to have a full path to the mysql_sql foler.

I've been looking round the forums and cant find a topic that covers the issue I'm having

I did about 15 seraches with "service doesnt start" etc etc and my particular issue didnt appear to be resolved in any of the threads I read.