Pandora FMS Community

Upgrade from v 1.3.1

yduma · 30 oct 2008, 11:16 · 15 mensajes · 59 visitas

  1. Inicio del debate

    Hello. Second time I upgrade my pandora server's to v.2 in both cases I receive similar error's with database upgrading like - ERROR 1091 (42000) at line 8: Can't DROP 'agent_type'; check that column/key exists can you help me? thank's!

  2. Are you using the upgrade tool?

  3. yes. I put migrate sql script and upgrade.php. When I run http://..../upgrade.php I get error. After I try do next - mysql -u root -p pandora2 (I change name of pandora2 - copy of pandora db) < pandora_migrate_2.0.sql and get error - ERROR 1091 (42000) at line 8: Can't DROP 'agent_type'; check that column/key exists

  4. What version are you migrating from ?, the migration script is only for 1.3.1 version. How do you make a copy of pandora db ?, using a full mysqldump ? (this is a good idea). If you're unsure about version, please put here dump for these SQL commands: describe tagente; select * from tconfig;

  5. I run migrate sql script for 1.3 to 1.3.1 after run migrate script for 1.3.1 to 2.0 and get error at line 33.

  6. Ask nil's question. But it works for us, I have to say

  7. Very odd.... Open a window with pandora_migrate_2.0.sql. open another window with a mysql command line and enter line to line, the sql code from pandora_migrate_2.0.sql. Should work fine (i've tested in a lot of systems), if fail, say exactly what line and put it here.

  8. Running this script I receive ERROR 1072 (42000) at line 33: Key column 'disabled' doesn't exist in table Same error when I was doing that line by line.

  9. Do somebody will read this discussions from administrators?

  10. Yes, we are busy, but trying to identify the error

  11. Hi. I think it is big problem when pandora user's can't upgrade it?!!! I really need this. THANKS!!!!!

  12. It's just you who can't

  13. Please, put here the results of mysqldump --nodata -u root -p pandora And we try to solve the migration problem.

  14. In atachement.

  15. I move database manually and get next: 1) pandora don't see my modules. 2) If I create new module host alive - and after delete it, it start check my old module.

Entra en tu cuenta para publicar.