NetXMS Support Forum

MySQL driver patch for 1.1.4. Just replace existing mysql.ddr with attached one.

Best regards,
Victor

Yes, of course it will be corrected. Looks like 1.1.4 is one of the worst releases for the project history I'll do a 1.1.5 release this week with the fixes.
Btw, in 1.1.4 we have replaced old mssql.ddr with new one, which uses SQL Server Native Client, so it should work on modern Windows versions with SQL Server 2005 and up.

Best regards,
Victor

Hi!

Same problem as here: https://www.netxms.org/forum/installation/1-1-4-database-upgrade-error/. In short, try to run manually

ALTER TABLE business_services DROP CONSTRAINT DF__business___paren__09746778;

Best regards,
Victor

Try to login with same user as NetXMS server or use fully qualified name, most likely something like dbo.DF__business___paren__4B0D20AB or netxms.DF__business___paren__4B0D20AB. You should see fully qualified table names in management studio under <database>/tables.

Best regards,
Victor

Please execute manually the following query:

ALTER TABLE business_services DROP CONSTRAINT DF__business___paren__4B0D20AB;

and then run upgrade again.

Best regards,
Victor

It was marked as private by reporter. It was about comment area on object overview page in new console - for large comments, scroll bars does not appear.

Best regards,
Victor

Yes, unfortunately there is a bug in MySQL driver in 1.1.4. I'll try to made a patch tomorrow. Other DB engines should work fine. I do most of the development using Oracle and PostgreSQL, and at some point forgot to make necessary tests at MySQL.

Best regards,
Victor

I have replicated this issue on my system. Looks like a bug in MySQL driver. I'll post a patch when I fix it.

Best regards,
Victor

If you run netxmsd.exe from command line, you should omit -d switch, like this:

netxmsd.exe -D 9

Best regards,
Victor

You should not initialize database if it already contains data. Initialization is for fresh installation on empty database.

Generally I do not recommend to use SQLite in production. It has both performance and upgrade issues, although performance can be insufficient only for relatively large installations. Upgrade problems are related to the fact that SQLite does not support DROP COLUMN operation - so if database upgrade requires column removal from the table, it will fail. It is possible to do upgrade manually in these cases, but it is time consuming and requires digging into the source code of nxdbmgr to see what SQL queries should be executed.

Best regards,
Victor

So, you have MySQL database for 1.0.12 and want to upgrade it to 1.1.4? It should be possible to done it in place. Just install 1.1.4, point it to appropriate database, and run database upgrade. If it shows any error, please send me log/screenshot of nxdbmgr upgrade execution.

Best regards,
Victor

Is there anything in the logs? Also, try to start netxmsd.exe from command line in debug mode (netxmsd.exe -D 9) and look for debug messages.

Best regards,
Victor

What is your production DB engine?

Hi!

DB export uses built-in sqlite engine to create export file. It works with all supported DB engines. What exact file it cannot found?

Best regards,
Victor

Hi!

On Windows, it is Windows Server 2003 or Windows XP, no specific requirements for service packs.

Best regards,
Victor