NetXMS Support Forum

Hi!

Looks like database was messed up during all these upgrades. Can you please run

nxdbmgr upgrade -X

(it will ignore errors), and then try to run server. Also, if possible, export and send to me database schema - I'll check it for correctness.

Best regards,
Victor

That's very strange. I don't touch e-mail sending code for a very long time. Is it possible to log SMTP conversation on your mail server?

Best regards,
Victor

Could you please try this driver?

Best regards,
Victor

Hi!

It's not implemented yet. I'll do it in one of the updates.

Best regards,
Victor

It is in plans for a long time. I'll try to find some time to make it. What branch are more demanded - 1.0.x or 1.1.x?

Best regards,
Victor

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