NetXMS Support Forum

Dear users,
i have problem on debian installation.

i try to migrate from sqlite to mysql, i have mysql server ready db initialized and invoking migrate command with stoped netxmsd service.
i get following.

root@netxms:/tmp# nxdbmgr -I -t migrate /tmp/netxmsd.conf
WARNING: invalid transaction size, reset to defaultNetXMS Database Manager Version 2.0.3 Build 8066 (UNKNOWN) (UNICODE)

Database driver sqlite.ddr loaded
Connected to source database


WARNING!!!
This operation will clear all configuration and collected data from destination database before migration.
Are you sure? (Y/N) y
>>> SELECT id FROM nodes
>>> DELETE FROM config
>>> DELETE FROM config_clob
>>> DELETE FROM users
>>> DELETE FROM user_groups
>>> DELETE FROM user_group_members
>>> DELETE FROM user_profiles
>>> DELETE FROM userdb_custom_attributes
>>> DELETE FROM object_properties
>>> DELETE FROM object_custom_attributes
>>> DELETE FROM zones
>>> DELETE FROM mobile_devices
>>> DELETE FROM access_points
>>> DELETE FROM racks
>>> DELETE FROM nodes
>>> DELETE FROM clusters
>>> DELETE FROM cluster_members
>>> DELETE FROM cluster_sync_subnets
>>> DELETE FROM cluster_resources
>>> DELETE FROM subnets
>>> DELETE FROM interfaces
>>> DELETE FROM interface_address_list
>>> DELETE FROM network_services
>>> DELETE FROM vpn_connectors
>>> DELETE FROM vpn_connector_networks
>>> DELETE FROM object_containers
>>> DELETE FROM conditions
>>> DELETE FROM cond_dci_map
>>> DELETE FROM templates
>>> DELETE FROM dct_node_map
>>> DELETE FROM nsmap
>>> DELETE FROM container_members
>>> DELETE FROM acl
>>> DELETE FROM trusted_nodes
>>> DELETE FROM items
>>> DELETE FROM dc_tables
>>> DELETE FROM dc_table_columns
>>> DELETE FROM dct_column_names
>>> DELETE FROM dct_thresholds
>>> DELETE FROM dct_threshold_conditions
>>> DELETE FROM dci_schedules
>>> DELETE FROM raw_dci_values
>>> DELETE FROM event_cfg
>>> DELETE FROM event_log
>>> DELETE FROM actions
>>> DELETE FROM event_groups
>>> DELETE FROM event_group_members
>>> DELETE FROM event_policy
>>> DELETE FROM policy_source_list
>>> DELETE FROM policy_event_list
>>> DELETE FROM policy_action_list
>>> DELETE FROM policy_time_range_list
>>> DELETE FROM policy_situation_attr_list
>>> DELETE FROM time_ranges
>>> DELETE FROM thresholds
>>> DELETE FROM alarms
>>> DELETE FROM alarm_notes
>>> DELETE FROM alarm_events
>>> DELETE FROM snmp_trap_cfg
>>> DELETE FROM snmp_trap_pmap
>>> DELETE FROM agent_pkg
>>> DELETE FROM object_tools
>>> DELETE FROM object_tools_acl
>>> DELETE FROM object_tools_table_columns
>>> DELETE FROM object_tools_input_fields
>>> DELETE FROM syslog
>>> DELETE FROM script_library
>>> DELETE FROM snmp_trap_log
>>> DELETE FROM agent_configs
>>> DELETE FROM address_lists
>>> DELETE FROM graphs
>>> DELETE FROM graph_acl
>>> DELETE FROM certificates
>>> DELETE FROM audit_log
>>> DELETE FROM situations
>>> DELETE FROM snmp_communities
>>> DELETE FROM ap_common
>>> DELETE FROM ap_bindings
>>> DELETE FROM ap_config_files
>>> DELETE FROM usm_credentials
>>> DELETE FROM network_maps
>>> DELETE FROM network_map_elements
>>> DELETE FROM network_map_links
>>> DELETE FROM images
>>> DELETE FROM dashboards
>>> DELETE FROM dashboard_elements
>>> DELETE FROM dashboard_associations
>>> DELETE FROM business_services
>>> DELETE FROM slm_checks
>>> DELETE FROM node_links
>>> DELETE FROM slm_agreements
>>> DELETE FROM slm_tickets
>>> DELETE FROM slm_service_history
>>> DELETE FROM organizations
>>> DELETE FROM persons
>>> DELETE FROM job_history
>>> DELETE FROM licenses
>>> DELETE FROM mapping_tables
>>> DELETE FROM mapping_data
>>> DELETE FROM dci_summary_tables
>>> DELETE FROM scheduled_tasks
>>> DELETE FROM zmq_subscription
Database successfully cleared
Migrating table config
ERROR: cannot prepare INSERT statement (Column 'possible_values' specified twice)
Database migration failed.
root@netxms:/tmp# nxdbmgr -h
NetXMS Database Manager Version 2.0.3 Build 8066 (UNKNOWN) (UNICODE)


i try export db and i get this
root@netxms:/var/lib/netxms# nxdbmgr export /tmp/migrate.db
NetXMS Database Manager Version 2.0.3 Build 8066 (UNKNOWN) (UNICODE)

Exporting table config
Segmentation fault


Instalation is from debian repository not compiled version.
Im currently on sqlite and is working, db check is ok.

Any ideas how to fix it ?

Hi,

in fact export file is just SQLite database. Try to run nxdbmgr import giving your database file as input.

Best regards,
Victor

Thank you for tip,
works ok.
Have a nice day