netxms core service on windows won't start

[victor]

Hello!

Looks like your database was not properly initialized. Try to run

nxdbmgr init ..\lib\sql\dbinit_mssql.sql

(assuming you are in NetXMS bin directory). Also, can you send your server's configuration file (netxmsd.conf)?

Best regards,
Victor

[ErichSpitzweg]

Hello Victor,
I tried nxdbmgr init. Console told me that the database was initialised properly, but it didn't work anyway.
Also we tried it on a different machine and on some virtual machines and we always got the same error. It seemed as if a connection to the database could not be established, but with Microsoft Enterprise Manager and other programms, we could connect to the database.
Sometimes it looked as if the connection was established, because I got an error message saying: Query failed: Create_Table ...

I also send you my server's configuration file netxmsd.conf.
Here is its content:

LogFile = {syslog}
DBDriver = mssql.ddr
DBServer = localhost
DBName = netxms_db
DBLogin = netxms
LogFailedSQLQueries = yes

Like I already said, we tried it on different computers and we always got the same errors. What are we doing wrong? Perhaps a configuration mistake. Maybe you have a step by step Manual to set up the connection to MSSQL-Server.

Best regards,
Jens

[victor]

Hello!

Some additional questions:

1. What version of MSSQL server you are using?
2. Cold you please connect to database with Enterprise Manager and send me list of tables presented in database netxms_db and content of "config" table?
3. Could you please change LogFile entry in netxmsd.conf to some file, run NetXMS server in debug mode:

netxmsd --debug-all --dump-sql standalone

and send me the log file?

Possible problems I can imagine now:

1. mssql.ddr expect that login given in DBLogin is an SQL "Standard" user with SQL authentication, not a Windows account. Maybe you create an account with Windows authentication?
2. mssql.ddr doesn't work correctly for some unknown reasons. I hope that debug log will give me more hints.
3. mssql.ddr can only work via TCP/IP. Ensure that TCP/IP is enabled in SQL server.

Best regards,
Victor

[ErichSpitzweg]

Hello,
thanks for your quick answer.
I am using MSSQL Version 8.00.760 (SP3). Unfortunately I cannot send the content of the config-table, because the attempt to generate a new database fails. (Error Message: Query Failed: CREATE_TABLE:...) As workaround, I mannually created a new database. Netxms told me that the database has been initialised, but it didn't create any tables.
I checked if SQL Server has TCP/IP enabled and I use an account with Windows authentication.

Here's the content of the log file:

[12-Jan-2007 15:23:17] Log file opened
[12-Jan-2007 15:23:17] Database driver "mssql.ddr" loaded and initialized successfully
[12-Jan-2007 15:23:17] DEBUG: Successfully connected to database netxms_1@VM-BIB-SQL
[12-Jan-2007 15:23:17] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name='DBFormatVersion'")
[12-Jan-2007 15:23:17] Your database has format version 0, but server is compiled for version 54

I hope that this will give some more hints.

Best regards
Jens

[victor]

Hello,

I think that problem is that you use an account with Windows authentication. Now you have two ways - create an account with SQL authentication (it's an easier way), or configure NetXMS for Windows authentication.

If you decide way 1:

1. Create new standard SQL account, let's say netxms_user, set it's authentication mode to SQL authentication, and set it's password (for example, NetXMSPass).
2. Modify your netxmsd.conf accordingly:

DBLogin = netxms_user
DBPassword = NetXMSPass

3. Run nxdbmgr init again, and ensure that tables was created (you should have ~50 tables).

NetXMS server should start.

If you decide way 2:

1. Change netxmsd.conf:

DBLogin = *

2. Change settings for "NetXMS Core" service - by default, it is running as "Local System" account, you should change it to your domain account which have access to SQL database (in service properties on "Log On" tab).
3. Run nxdbmgr init again, and ensure that tables was created (you should have ~50 tables). Please note that because of Windows authentication, account you will be logged in at the time you will run nxdbmgr should also have access to SQL database.

Hope this helps!

Best regards,
Victor

[ErichSpitzweg]

Hello!
I'm sorry I have to inform you that it didn't work, too. I tried both ways. When I run nxdbmgr init the console tells me: Database initialized successfully. But there are no tables created.
I checked if the netxms core service was running and it wasn't. When I start it manually it starts and is terminated immediately.
I also tried to run the programm with a mysql database and it worked. Maybe that will help you.

Best regards,
Jens

[victor]

Very strange... Another option left - setup connetion to MS SQL via ODBC. To do this, follow these steps:

1. Create appropriate data source via Administartive Tools -> Data Sources (ODBC). You must create System DSN. Call this DSN NETXMS.
2. Change netxmsd.conf file:

DBDriver = odbc.ddr
DBServer = NETXMS

Note that DBServer now is the name of ODBC DSN.

After that, try to run nxdbmgr init again.

Also, what database rights assigned to the database user you are using?

Best regards,
Victor

[ErichSpitzweg]

Hello,
I was a couple of days off, but now I'm back and I tried a few other things.
I've created an empty database, which has been initialised by netxms, but it couldn't connect. Now that I had a config table I changed the entry DBFormatVersion from 0 to 54 (because of an entry in the eventlog, saying "Your database has format version 0, but server is compiled for version 54."). After that netxms could connect and worked pretty well, but everytime I tried to look into the database Enterprise Manager crashed.
Eventually I could not get a connection again.

I also installed a new instance of MS Desktop Engine 2000 and netxms on a different machine ad it worked without problems.

Now that I got it, here's the entry of the config table, maybe that will give you some further hints.

"ActiveDiscoveryInterval","7200",1,1
"ActiveNetworkDiscovery","0",1,1
"AgentUpgradeWaitTime","600",1,0
"AllowedCiphers","15",1,1
"CapabilityExpirationTime","604800",1,0
"ClientListenerPort","4701",1,1
"ConditionPollingInterval","60",1,1
"ConfigurationPollingInterval","3600",1,1
"DataDirectory","C:#5CNetXMS#5Cvar",1,1
"DBFormatVersion","54",0,1
"DBLockInfo","PG_SCHOLZST Windows 2000 Service Pack 4 Build 2195",0,0
"DBLockPID","1056",0,0
"DBLockStatus","192.168.216.1",0,1
"DBSyntax","MSSQL",0,1
"DefaultCommunityString","public",1,0
"DefaultEncryptionPolicy","1",1,1
"DeleteEmptySubnets","0",1,1
"DisableVacuum","0",1,0
"DiscoveryFilter","none",1,0
"DiscoveryFilterFlags","0",1,0
"DiscoveryPollingInterval","14400",1,1
"EnableAdminInterface","1",1,1
"EnableMultipleDBConnections","1",1,1
"EnableSNMPTraps","1",1,1
"EnableSyslogDaemon","0",1,1
"EnableZoning","0",1,1
"EventLogRetentionTime","5184000",1,0
"FixedStatusValue","0",1,1
"HouseKeepingInterval","3600",1,1
"IcmpPingSize","46",1,1
"IDataIndexCreationCommand_0","CREATE INDEX idx_idata_%d_item_id ON idata_%d(item_id)",0,1
"IDataIndexCreationCommand_1","CREATE CLUSTERED INDEX idx_idata_%d_id_timestamp ON idata_%d(item_id,idata_timestamp)",0,1
"IDataTableCreationCommand","CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null)",0,1
"KeepAliveInterval","60",1,1
"LockTimeout","60000",1,1
"LogAllSNMPTraps","1",1,1
"MailEncoding","iso-8859-1",1,0
"NumberOfConditionPollers","10",1,1
"NumberOfConfigurationPollers","4",1,1
"NumberOfDatabaseWriters","1",1,1
"NumberOfDataCollectors","25",1,1
"NumberOfDiscoveryPollers","1",1,1
"NumberOfEventProcessors","1",1,1
"NumberOfRoutingTablePollers","5",1,1
"NumberOfStatusPollers","10",1,1
"NumberOfUpgradeThreads","10",1,0
"RADIUSNumRetries","5",1,0
"RADIUSPort","1645",1,0
"RADIUSSecret","netxms",1,0
"RADIUSServer","localhost",1,0
"RADIUSTimeout","3",1,0
"ResolveNodeNames","1",1,0
"RoutingTableUpdateInterval","300",1,1
"RunNetworkDiscovery","0",1,1
"ServerID","EA13000043CFB045",0,1
"SMSDriver","generic.sms",1,1
"SMSDrvConfig","COM1:",1,1
"SMTPFromAddr","#00",1,0
"SMTPServer","#00",1,0
"StatusCalculationAlgorithm","1",1,1
"StatusPollingInterval","60",1,1
"StatusPropagationAlgorithm","1",1,1
"StatusShift","0",1,1
"StatusSingleThreshold","75",1,1
"StatusThresholds","503C2814",1,1
"StatusTranslation","01020304",1,1
"SyncInterval","60",1,1
"SyslogListenPort","514",1,1
"SyslogRetentionTime","5184000",1,0

Thank you advance.

Best regards
Jens

[peter_qin]

hi,
  my netxms core server also can't start. system event log " your database server has format version 104,but the server is comiled for version 105".I'm use sql2000.

[victor]

Hi!

Run command

nxdbmgr.exe upgrade

It will upgrade your database schema.

Best regards,
Victor