NetXMS Support Forum

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

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

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

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

I have a simillar problem. I am running Netxms on a Windows Server 2003 System with MSSQL-Server. After installation Netxms tells me that it cannot connect to the database.
I saw, that the Netxms Core-Service didn't start. If I try to start it manually, it is been started and immediatly stopped again. When I run "nxdbmgr check" I get:
"Configuration file OK
Unable to determine database syntax"
In the Windows eventlog there is an error saying: "Your database has format version 0, but server is compiled for version 54"
What can I do to make it work.
I just want SNMP-Traps to be written to a MSSQL-Database.

Please help me, because I don't know what to try anymore.

Thank You in advance

Jens