Pandora FMS Community

4.0.x->5.0 DB Migration: Can't create table 'pandora.tplanned_downtime_modules'

knoxel · 13 ago 2014, 13:47 · 11 mensajes · 48 visitas

  1. Inicio del debate

    Hello, I tried to update a customer from 4.0.3 to 5.0 and wanted to go to 5.1. I made to update to 5.0SP3 from 4.0.3 and ran the mysql migration script. When running the script I get this error:

    ERROR 1005 (HY000) at line 122: Can't create table 'pandora.tplanned_downtime_modules' (errno: 150)
    

    Right now the 4.0.3 is running again with the DB backup created before the update. I have nothing found in the FAQs or the Forum. Thank you, Regards, Philipp

  2. Hello Try updating firstly to version 4.1 or 4.1.1 then run the migration script and then try again with the migration. Regards Ivo

  3. Hello Ivo, Thanky for your reply. I have installed 4.1.1 and ran the migration script from 4.0 to 4.1. This one ran fine and 4.1.1 is working. After this I have updated to 5.0SP3 and ran the migration script -> I get the same error. Regards, Philipp

  4. Hello Can you specify on the process followed for the upgrade? Where did you get the newer version of pandora? Regards Ivo

  5. Hello Ivo, we manage 3 Pandora FMS Server so I have downloaded the files some weeks or month ago. I have already updated one Pandora FMS Server with the files. I use this link: http://pandorafms.com/Community/download/en and select Debian. Here is the upgrade process. I have removed the "ls" commands, the SQL passwords and changed the servername for posting it here:

    root@pandoraserver:~# dpkg -i pandorafms.console_5.0SP3.deb pandorafms.server_5.0SP3.deb
    (Reading database ... 64219 files and directories currently installed.)
    Preparing to replace pandorafms-console 4.1.1-131217 (using pandorafms.console_5.0SP3.deb) ...
    Unpacking replacement pandorafms-console ...
    Preparing to replace pandorafms-server 4.1.1-131217 (using pandorafms.server_5.0SP3.deb) ...
     Removing any system startup links for /etc/init.d/pandora_server ...
       /etc/rc0.d/K20pandora_server
       /etc/rc1.d/K20pandora_server
       /etc/rc2.d/S20pandora_server
       /etc/rc3.d/S20pandora_server
       /etc/rc4.d/S20pandora_server
       /etc/rc5.d/S20pandora_server
       /etc/rc6.d/K20pandora_server
     Removing any system startup links for /etc/init.d/tentacle_serverd ...
       /etc/rc0.d/K20tentacle_serverd
       /etc/rc1.d/K20tentacle_serverd
       /etc/rc2.d/S20tentacle_serverd
       /etc/rc3.d/S20tentacle_serverd
       /etc/rc4.d/S20tentacle_serverd
       /etc/rc5.d/S20tentacle_serverd
       /etc/rc6.d/K20tentacle_serverd
    Unpacking replacement pandorafms-server ...
    Setting up pandorafms-console (5.0SP3) ...
    Change the user and group to /var/www/pandora_console.
    Restart the apache.
     * Restarting web server apache2                                                                                                                                                                                                             apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
     ... waiting apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
                                                                                                                                                                                                                                          [ OK ]
    Please, now, point your browser to http://your_IP_address/pandora_console/install.php and follow all the steps described on it.
    Setting up pandorafms-server (5.0SP3) ...
    Linking pandora_exec...
    Creating common Pandora FMS directories
    Giving proper permission to /var/spool/pandora
    Creating setup directory in /etc/pandora
    cp: not writing through dangling symlink `/etc/pandora/pandora_server.conf'
    chmod: cannot operate on dangling symlink `/etc/pandora/pandora_server.conf'
    Linking startup script to /etc/rc2.d
    update-rc.d: warning: pandora_server start runlevel arguments (2 3 4 5) do not match LSB Default-Start values (2 3 5)
     Adding system startup for /etc/init.d/pandora_server ...
       /etc/rc0.d/K20pandora_server -> ../init.d/pandora_server
       /etc/rc1.d/K20pandora_server -> ../init.d/pandora_server
       /etc/rc6.d/K20pandora_server -> ../init.d/pandora_server
       /etc/rc2.d/S20pandora_server -> ../init.d/pandora_server
       /etc/rc3.d/S20pandora_server -> ../init.d/pandora_server
       /etc/rc4.d/S20pandora_server -> ../init.d/pandora_server
       /etc/rc5.d/S20pandora_server -> ../init.d/pandora_server
    Installing tentacle server in /etc/rc2.d/S80tentacle_serverd
    update-rc.d: warning: tentacle_serverd start runlevel arguments (2 3 4 5) do not match LSB Default-Start values (2 3 5)
     Adding system startup for /etc/init.d/tentacle_serverd ...
       /etc/rc0.d/K20tentacle_serverd -> ../init.d/tentacle_serverd
       /etc/rc1.d/K20tentacle_serverd -> ../init.d/tentacle_serverd
       /etc/rc6.d/K20tentacle_serverd -> ../init.d/tentacle_serverd
       /etc/rc2.d/S20tentacle_serverd -> ../init.d/tentacle_serverd
       /etc/rc3.d/S20tentacle_serverd -> ../init.d/tentacle_serverd
       /etc/rc4.d/S20tentacle_serverd -> ../init.d/tentacle_serverd
       /etc/rc5.d/S20tentacle_serverd -> ../init.d/tentacle_serverd
    Create the Cron script to run hourly Pandora DB tool
    Please, now, edit the /etc/pandora/pandora_server.conf and launch the Pandora Server with /etc/init.d/Pandora .
    Processing triggers for man-db ...
    Processing triggers for ureadahead ...
    root@pandoraserver:~#
    root@pandoraserver:~#
    root@pandoraserver:~#
    root@pandoraserver:~# mysqldump --user=root --password=xxx --database pandora > /backup_pandora2.sql
    root@pandoraserver:~# cd /var/www/pandora_console/extras/
    root@pandoraserver:/var/www/pandora_console/extras# cat pandoradb_migrate_4.1_to_5.0.mysql.sql | mysql -u root -p -D pandora
    Enter password:
    ERROR 1005 (HY000) at line 122: Can't create table 'pandora.tplanned_downtime_modules' (errno: 150)
    
    
    root@pandoraserver:/var/www/pandora_console/extras# mysql -u root -p pandora < /backup_pandora2.sql
    Enter password:
    
  6. Hello I will send you over your email address a migration script. Can you check if there still is a problem? Regards Ivo

  7. Hello Ivo, the Problem is still there and it is the same one. The Migration script you sent me does look like the one which is included with the installation. Regards, Philipp

  8. Hello I will try and replicate the problem. Regards Ivo

  9. Hello Before you can update to version 5.0 SP3 firstly you'd need to update to version 5.0. From the following link you can download all the necesarry packages for version 5.0. http://sourceforge.net/projects/pandora/files/Pandora%20FMS%205.0/Final/ Once downloaded and installed you'd need to use the migration script. First of all stop apache and the pandora_server if you haven't stop them during the installation. Go to the extras directory (in the pandora_console directory) there you'd need to access the mysql shell: mysql -u root -p then type: use pandora; source pandoradb_migrate_4.1_to_5.0.mysql.sql; You'd need to start over all services and replace the config for the new server (don't forget to change the password in the new configuration file) Regards Ivo

  10. Hello Ivo, here the Output. There are some warnings and the same error again. If you like I can send you the database. Regards, Philipp

    mysql> source pandoradb_migrate_4.1_to_5.0.mysql.sql;
    Query OK, 0 rows affected, 1 warning (0.02 sec)
    
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    ERROR 1060 (42S21): Duplicate column name 'id_agent'
    ERROR 1060 (42S21): Duplicate column name 'url_address'
    ERROR 1060 (42S21): Duplicate column name 'quiet'
    ERROR 1060 (42S21): Duplicate column name 'normal_count'
    ERROR 1060 (42S21): Duplicate column name 'warning_count'
    ERROR 1060 (42S21): Duplicate column name 'critical_count'
    ERROR 1060 (42S21): Duplicate column name 'unknown_count'
    ERROR 1060 (42S21): Duplicate column name 'notinit_count'
    ERROR 1060 (42S21): Duplicate column name 'total_count'
    ERROR 1060 (42S21): Duplicate column name 'fired_count'
    ERROR 1060 (42S21): Duplicate column name 'update_module_count'
    ERROR 1060 (42S21): Duplicate column name 'update_alert_count'
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    ERROR 1060 (42S21): Duplicate column name 'special_day'
    ERROR 1060 (42S21): Duplicate column name 'wizard_level'
    ERROR 1060 (42S21): Duplicate column name 'monday'
    ERROR 1060 (42S21): Duplicate column name 'tuesday'
    ERROR 1060 (42S21): Duplicate column name 'wednesday'
    ERROR 1060 (42S21): Duplicate column name 'thursday'
    ERROR 1060 (42S21): Duplicate column name 'friday'
    ERROR 1060 (42S21): Duplicate column name 'saturday'
    ERROR 1060 (42S21): Duplicate column name 'sunday'
    ERROR 1060 (42S21): Duplicate column name 'periodically_time_from'
    ERROR 1060 (42S21): Duplicate column name 'periodically_time_to'
    ERROR 1060 (42S21): Duplicate column name 'periodically_day_from'
    ERROR 1060 (42S21): Duplicate column name 'periodically_day_to'
    ERROR 1060 (42S21): Duplicate column name 'type_downtime'
    ERROR 1060 (42S21): Duplicate column name 'type_execution'
    ERROR 1060 (42S21): Duplicate column name 'type_periodicity'
    ERROR 1060 (42S21): Duplicate column name 'id_user'
    Query OK, 0 rows affected (0.00 sec)
    
    Query OK, 0 rows affected (0.02 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 274 rows affected (0.01 sec)
    Records: 274  Duplicates: 0  Warnings: 0
    
    ERROR 1060 (42S21): Duplicate column name 'all_modules'
    ERROR 1005 (HY000): Can't create table 'pandora.tplanned_downtime_modules' (errno: 150)
    Query OK, 284 rows affected (0.03 sec)
    Records: 284  Duplicates: 0  Warnings: 0
    
    Query OK, 284 rows affected (0.01 sec)
    Records: 284  Duplicates: 0  Warnings: 0
    
    Query OK, 284 rows affected, 1 warning (0.00 sec)
    Records: 284  Duplicates: 0  Warnings: 1
    
    Query OK, 284 rows affected, 1 warning (0.01 sec)
    Records: 284  Duplicates: 0  Warnings: 1
    
    Query OK, 284 rows affected, 1 warning (0.01 sec)
    Records: 284  Duplicates: 0  Warnings: 1
    
    Query OK, 284 rows affected (0.01 sec)
    Records: 284  Duplicates: 0  Warnings: 0
    
    Query OK, 284 rows affected (0.01 sec)
    Records: 284  Duplicates: 0  Warnings: 0
    
    Query OK, 284 rows affected, 1 warning (0.00 sec)
    Records: 284  Duplicates: 0  Warnings: 1
    
    Query OK, 5 rows affected (0.00 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    [...]
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.01 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.03 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.01 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.02 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.03 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.02 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected, 1 warning (0.03 sec)
    Records: 479  Duplicates: 0  Warnings: 1
    
    Query OK, 479 rows affected, 1 warning (0.02 sec)
    Records: 479  Duplicates: 0  Warnings: 1
    
    Query OK, 479 rows affected, 1 warning (0.03 sec)
    Records: 479  Duplicates: 0  Warnings: 1
    
    Query OK, 479 rows affected (0.02 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.03 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.03 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.02 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.02 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected, 1 warning (0.02 sec)
    Records: 479  Duplicates: 0  Warnings: 1
    
    Query OK, 479 rows affected, 1 warning (0.02 sec)
    Records: 479  Duplicates: 0  Warnings: 1
    
    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 0  Changed: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 47 rows affected (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 0
    
    Query OK, 47 rows affected (0.01 sec)
    Records: 47  Duplicates: 0  Warnings: 0
    
    Query OK, 47 rows affected (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 0
    
    Query OK, 47 rows affected, 1 warning (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 1
    
    Query OK, 47 rows affected, 1 warning (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 1
    
    Query OK, 47 rows affected, 1 warning (0.01 sec)
    Records: 47  Duplicates: 0  Warnings: 1
    
    Query OK, 47 rows affected (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 0
    
    Query OK, 47 rows affected (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 0
    
    Query OK, 47 rows affected (0.01 sec)
    Records: 47  Duplicates: 0  Warnings: 0
    
    Query OK, 47 rows affected (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 0
    
    Query OK, 47 rows affected, 1 warning (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 1
    
    Query OK, 47 rows affected, 1 warning (0.00 sec)
    Records: 47  Duplicates: 0  Warnings: 1
    
    Query OK, 47 rows affected, 1 warning (0.01 sec)
    Records: 47  Duplicates: 0  Warnings: 1
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    
    Query OK, 138 rows affected (0.00 sec)
    Records: 138  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.01 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    
    Query OK, 1 row affected (0.00 sec)
    
    Query OK, 16 rows affected (0.00 sec)
    Records: 16  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    ERROR 1005 (HY000): Can't create table 'pandora.#sql-20f_11c' (errno: 150)
    Query OK, 0 rows affected (0.03 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.01 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.01 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.03 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.01 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.01 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    
    Query OK, 0 rows affected (0.00 sec)
    
    Query OK, 11 rows affected (0.00 sec)
    Records: 11  Duplicates: 0  Warnings: 0
    
    Query OK, 11 rows affected (0.00 sec)
    Records: 11  Duplicates: 0  Warnings: 0
    
    Query OK, 11 rows affected (0.00 sec)
    Records: 11  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.01 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 1
    
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 1
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.01 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 1
    
    Query OK, 1 row affected (0.00 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.01 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.02 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.01 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.01 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.01 sec)
    Records: 1  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.01 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.01 sec)
    
    Query OK, 4 rows affected (0.00 sec)
    Records: 4  Duplicates: 0  Warnings: 0
    
    Query OK, 4 rows affected (0.00 sec)
    Records: 4  Duplicates: 0  Warnings: 0
    
    Query OK, 4 rows affected (0.00 sec)
    Records: 4  Duplicates: 0  Warnings: 0
    
    Query OK, 4 rows affected (0.00 sec)
    Records: 4  Duplicates: 0  Warnings: 0
    
    Query OK, 4 rows affected (0.01 sec)
    Records: 4  Duplicates: 0  Warnings: 0
    
    Query OK, 4 rows affected (0.00 sec)
    Records: 4  Duplicates: 0  Warnings: 0
    
    Query OK, 4 rows affected (0.00 sec)
    Records: 4  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.01 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.01 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.01 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.01 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.00 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 6 rows affected (0.01 sec)
    Records: 6  Duplicates: 0  Warnings: 0
    
    Query OK, 12 rows affected (0.00 sec)
    Records: 12  Duplicates: 0  Warnings: 0
    
    Query OK, 12 rows affected (0.00 sec)
    Records: 12  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    
    Query OK, 5 rows affected (0.00 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 5 rows affected (0.01 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 5 rows affected (0.00 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 5 rows affected (0.00 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 5 rows affected (0.01 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 5 rows affected (0.00 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 5 rows affected (0.00 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 0  Changed: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 0  Changed: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 0  Changed: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 0  Changed: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 0  Changed: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 5 rows affected (0.01 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 5 rows affected (0.00 sec)
    Records: 5  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.01 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected, 1 warning (0.00 sec)
    
    Query OK, 1 row affected, 1 warning (0.00 sec)
    
    [...]
    
    Query OK, 0 rows affected (0.00 sec)
    
    Query OK, 479 rows affected (0.01 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.01 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 479 rows affected (0.01 sec)
    Records: 479  Duplicates: 0  Warnings: 0
    
    Query OK, 284 rows affected (0.01 sec)
    Records: 284  Duplicates: 0  Warnings: 0
    
    Query OK, 284 rows affected (0.01 sec)
    Records: 284  Duplicates: 0  Warnings: 0
    
    Query OK, 284 rows affected (0.00 sec)
    Records: 284  Duplicates: 0  Warnings: 0
    
    Query OK, 284 rows affected (0.01 sec)
    Records: 284  Duplicates: 0  Warnings: 0
    
    Query OK, 7 rows affected (0.00 sec)
    Records: 7  Duplicates: 0  Warnings: 0
    
    Query OK, 7 rows affected (0.00 sec)
    Records: 7  Duplicates: 0  Warnings: 0
    
    Query OK, 0 rows affected (0.01 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 20 rows affected (0.00 sec)
    Rows matched: 20  Changed: 20  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    Records: 0  Duplicates: 0  Warnings: 0
    
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    Query OK, 618 rows affected (0.01 sec)
    Records: 618  Duplicates: 0  Warnings: 0
    
    Query OK, 16 rows affected (0.00 sec)
    
    mysql>
    

    After this, the start of pandora shows the following log:

    2014-08-15 07:36:10 - pandoraserver Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Unknown column 'last_error' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.
    DBD::mysql::db do failed: Unknown column 'last_error' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.
    DBD::mysql::db do failed: Unknown column 'last_error' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.
    DBD::mysql::db do failed: Unknown column 'last_error' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.
    
  11. Hello That won't be necessary. You need to access the mysql shell by typing: mysql -u root -p Once you've logged in then you need to type: use pandora; ALTER TABLE `tagente_estado` ADD COLUMN `last_error` tinyint(4) NOT NULL DEFAULT 0; This should fix the problem. Regards Ivo

Entra en tu cuenta para publicar.