Update myslq backend von 3.3.1 > 3.4
Verfasst: 15 Sep 2009, 17:19
Hallo zusammen,
nachdem ich das Script "/usr/share/opsi/init-opsi-mysql-db.py" ausführe, erhalte ich folgenden Fehler.
*******************************************************************************
* This tool will create an initial mysql database for use as opsi backend. *
* The config file /etc/opsi/backendManager.d/21_mysql.conf will be recreated. *
* =>>> Press <CTRL> + <C> to abort <<<= *
*******************************************************************************
Database host [localhost]:
Database admin user [root]:
Database admin password [password]:
Opsi database name [opsi]:
Opsi database user [opsi]:
Opsi database password [opsi]:
Connecting to host 'localhost' as user 'root'
Creating database 'opsi' and user 'opsi'
Testing connection
Connection / credentials ok!
Creating mysql backend config file /etc/opsi/backendManager.d/21_mysql.conf
Updating database from opsi 3.3 to 3.4
Traceback:
line 163 in '<module>' in file '/usr/share/opsi/init-opsi-mysql-db.py'
line 77 in 'db_query' in file '/var/lib/python-support/python2.5/OPSI/Backend/MySQL.py'
line 148 in 'db_execute' in file '/var/lib/python-support/python2.5/OPSI/Backend/MySQL.py'
line 166 in 'execute' in file '/var/lib/python-support/python2.5/MySQLdb/cursors.py'
line 35 in 'defaulterrorhandler' in file '/var/lib/python-support/python2.5/MySQLdb/connections.py'
==>>> (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''walk Manager 1.6' where `software_id`=659' at line 1")
ERROR: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''walk Manager 1.6' where `software_id`=659' at line 1")
Was habe ich beim Update übersehen?
Grüße aus Österrreich
Bernhard Gerg
nachdem ich das Script "/usr/share/opsi/init-opsi-mysql-db.py" ausführe, erhalte ich folgenden Fehler.
*******************************************************************************
* This tool will create an initial mysql database for use as opsi backend. *
* The config file /etc/opsi/backendManager.d/21_mysql.conf will be recreated. *
* =>>> Press <CTRL> + <C> to abort <<<= *
*******************************************************************************
Database host [localhost]:
Database admin user [root]:
Database admin password [password]:
Opsi database name [opsi]:
Opsi database user [opsi]:
Opsi database password [opsi]:
Connecting to host 'localhost' as user 'root'
Creating database 'opsi' and user 'opsi'
Testing connection
Connection / credentials ok!
Creating mysql backend config file /etc/opsi/backendManager.d/21_mysql.conf
Updating database from opsi 3.3 to 3.4
Traceback:
line 163 in '<module>' in file '/usr/share/opsi/init-opsi-mysql-db.py'
line 77 in 'db_query' in file '/var/lib/python-support/python2.5/OPSI/Backend/MySQL.py'
line 148 in 'db_execute' in file '/var/lib/python-support/python2.5/OPSI/Backend/MySQL.py'
line 166 in 'execute' in file '/var/lib/python-support/python2.5/MySQLdb/cursors.py'
line 35 in 'defaulterrorhandler' in file '/var/lib/python-support/python2.5/MySQLdb/connections.py'
==>>> (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''walk Manager 1.6' where `software_id`=659' at line 1")
ERROR: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''walk Manager 1.6' where `software_id`=659' at line 1")
Was habe ich beim Update übersehen?
Grüße aus Österrreich
Bernhard Gerg