forum.opsi.org

Code: Alles auswählen

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 158 in '<module>' in file '/usr/share/opsi/init-opsi-mysql-db.py'
     line 77 in 'db_query' in file '/usr/lib/pymodules/python2.5/OPSI/Backend/MySQL.py'
     line 146 in 'db_execute' in file '/usr/lib/pymodules/python2.5/OPSI/Backend/MySQL.py'
     line 166 in 'execute' in file '/usr/lib/pymodules/python2.5/MySQLdb/cursors.py'
     line 35 in 'defaulterrorhandler' in file '/usr/lib/pymodules/python2.5/MySQLdb/connections.py'
     ==>>> (1060, "Duplicate column name 'hostId'")
ERROR: (1060, "Duplicate column name 'hostId'")

opsi:/#

Code: Alles auswählen

mysqladmin --user=root --password=<altes_pw> password <neues_pw>

Code: Alles auswählen

UPDATE user SET Password=PASSWORD('neues Passwort') WHERE user='root';
flush privileges;