db upgrade 1.1.4

[victor]

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

Best regards,
Victor

---

mysql.ddr

[lindeamon]

thank you victor.

there is something not clear to me yet.how can i do a replace if the installation is a new one ?
do i have to do an installation without configuring the server,replace the driver and then do the server configuration part ?

10x,
lindeamon

[lindeamon]

sorry victor,

i have remmebered why we needed the patch.to replace the old one after the db upgrade.
just ignore my former post.

thank you,
lindeamon

[lindeamon]

hi victor,

i have installed version 1.1.3 and let it work for a day or two and it worked ok.i have uninstalled it and installed version 1.1.4.
i have gone through all the steps of the setup and when the server configuration wizard came up i have replaced the mysql.ddr file with the one you gave me in this post and finished the wizard and nothing works.
i have tried to upgrade the db through command line and it says the db version is the latest.
i invoked the netxmsd in command line with debug 9 and it said it had connected to the database but failed with this message "error initializing component locks table"

best regards,
lindeamon

[lindeamon]

i forgot to say that i did not initialized the databse.

[victor]

Could you please try this driver?

Best regards,
Victor

---

mysql.ddr

[lindeamon]

ok

i will give it a try and tell you if it worked.

[lindeamon]

hi victor,

to cut the story short i did everything as i mentioned in the last time and everything went fine but service did not came up.running the service from command line told that my db has a version of 232 and the server is compiled for version 240.
i did an upgrade and it failed and the error message said :" sql query failed (table 'business_services' already exists): " and then it writes the sql command: "create table business_services........" and all of it's data.

Best Regards,
Lindeamon

[lindeamon]

hi victor,

i have tried to delete the table mentioned in the former post and failed with other tables like node_links.
fyi

lindeamon

[victor]

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

[lindeamon]

ok victor,

it worked.
what version of the sql.ddr patches do i have to save for now ? the latest one ?

Best Regards,
Lindeamon

[lindeamon]

regarding the schema,is there any quick way to export it without any records ? if it is not possible then i will not be able to send it to you.
but there is something the makes me wonder,after each installation i tried with the different patches you gave me i have restored the databse to the one that worked with v1.1.3 so why would it give me errors ?
maybe i will try to make a clean install and check it.

10x,
lindeamon

[lindeamon]

hi victor,

i found a way to export with no data.here is the v1.1.4 schema

---

netxms_db_export_v1.1.4_no_data.sql

[victor]

@lindeamon said in db upgrade 1.1.4:

what version of the sql.ddr patches do i have to save for now ? the latest one ?

Yes.

Best regards,
Victor