| View previous topic :: View next topic |
| Author |
Message |
flammenflitzer
Advocate
Joined: 25 Nov 2003
Posts: 2951
Location: Berlin
|
 Posted: Sat Apr 27, 2013 7:21 am Post subject: media-gfx/digikam-3.1.0 immer noch Bug mit MySQL |
 |
|
Hallo,
ich habe derzeit | Code: | | media-gfx/digikam-3.1.0:4 USE="addressbook gphoto2 handbook mysql semantic-desktop thumbnails video (-aqua) -debug -doc -themedesigner" |
installiert.
Die DB ist mit mysql angelegt. Allerdings kann digikam nicht verbinden. | Code: | olaf@flammenflitzer ~ $ digikam
digikam(5100)/digikam (core): Error while opening the database. Error details [ QSqlError(1049, "QMYSQL: Verbindungsaufbau nicht möglich", "Unknown database 'digikam4.b'") ]
...
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in use, all queries will cease to work.
QSqlDatabase: driver not loaded
...
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-12662512' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-12662512', old connection removed.
QSqlQuery::prepare: database not open
QSqlDatabase: driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL
QSqlQuery::prepare: database not open
"/org/freedesktop/UDisks2/drives/SAMSUNG_HD401LJ_400511FP324666" : property "DeviceNumber" does not exist
"/org/freedesktop/UDisks2/drives/SAMSUNG_HD401LJ_400511FP324666" : property "Device" does not exist
...
QSqlDatabase: driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL
QSqlQuery::prepare: database not open
...
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-14850064' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-14850064', old connection removed.
QSqlQuery::prepare: database not open
QSqlDatabase: driver not loaded
...
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-14850064' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-14850064', old connection removed.
QSqlDatabase: driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-14850064' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-14850064', old connection removed.
QSqlQuery::prepare: database not open
QSqlDatabase: driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL
QSqlQuery::prepare: database not open
QSqlDatabase: driver not loaded
...
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-14850064' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-14850064', old connection removed.
QSqlQuery::prepare: database not open
QSqlDatabase: driver not loaded
...
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL
QSqlQuery::prepare: database not open
digikam(5100)/digikam (core): No DB action defined for "InsertTag" ! Implementation missing for this database type.
QSqlDatabase: driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3 QMYSQL |
| Code: | mysql --version
mysql Ver 14.14 Distrib 5.5.30, for Linux (x86_64) using readline 6.2 |
Hat jemand eine Lösung?
MfG |
|
| Back to top |
|
 |
Finswimmer
Moderator
Joined: 02 Sep 2004
Posts: 5291
Location: Langen (Hessen), Germany
|
| Posted: Sat Apr 27, 2013 8:43 am Post subject: |
|
|
| Code: | | "Unknown database 'digikam4.b'" |
Zeig doch mal, wie die Einstellungen für den DB-Verbindungaufbau sind.
Und gib an, wie die Datenbank über mysql (commandline) erreicht werden kann.
_________________
Bitte auf Rechtschreibung, korrekte Formatierung und Höflichkeit achten!
Danke |
|
| Back to top |
|
|
flammenflitzer
Advocate
Joined: 25 Nov 2003
Posts: 2951
Location: Berlin
|
| Posted: Sun Apr 28, 2013 2:44 pm Post subject: |
|
|
| Code: | mysql> DROP DATABASE digikam;
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE DATABASE digikam;
Query OK, 1 row affected (0.00 sec)
mysql> USE digikam;
Database changed
mysql> GRANT ALL ON digikam .* TO digikam@flammenflitzer IDENTIFIED BY '12345678';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Bye |
| Code: | digikam Einstellungen
Hostname: flammenflitzer
Schema Name: /home/olaf/Bilder/digikam4.db
Thumbnails Schema Name: /home/olaf/Bilder/thumbnails-digikam.db
Port: 3306
Username: digikam
Password: 12345678
"Datenbankverbindung erfolgreich geprüft" |
| Code: | /home/olaf/Bilder/digikam4.db
/home/olaf/Bilder/thumbnails-digikam.db |
existieren nicht, das sie ja erst nach dem Einlesen des Bildverzeichnis angelegt werden. |
|
| Back to top |
|
|
firefly
Advocate
Joined: 31 Oct 2002
Posts: 3999
|
| Posted: Sun Apr 28, 2013 5:58 pm Post subject: |
|
|
| flammenflitzer wrote: | | Code: | /home/olaf/Bilder/digikam4.db
/home/olaf/Bilder/thumbnails-digikam.db |
existieren nicht, das sie ja erst nach dem Einlesen des Bildverzeichnis angelegt werden. |
Da hast du anscheinend die Dokumentation missverstanden. Die Datenbanken an sich müssen vorhanden sein und werden nicht von digikam angelegt.
| Quote: | | Obviously, to use digiKam with MySQL, you need a MySQL server. You also have to create two MySQL databases: one for storing photo metadata (e.g., digikam) and the other for storing thumbnails (e.g., thumbnails-digikam). And before you proceed, note the database connection information such as MySQL server address, user name, and password — you’ll need it when configuring MySQL settings in digiKam. |
Quelle:
http://scribblesandsnaps.com/2010/10/15/using-digikam-with-mysql/
oder http://userbase.kde.org/Digikam/Using_digiKam_with_MySQL
_________________
Ein Ring, sie zu knechten, sie alle zu finden,
Ins Dunkel zu treiben und ewig zu binden
Im Lande Mordor, wo die Schatten drohn. |
|
| Back to top |
|
|
flammenflitzer
Advocate
Joined: 25 Nov 2003
Posts: 2951
Location: Berlin
|
| Posted: Sun Apr 28, 2013 6:40 pm Post subject: |
|
|
| Code: | mysql> DROP DATABASE digikam;
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE DATABASE digikam;
Query OK, 1 row affected (0.00 sec)
mysql> USE digikam;
Database changed
mysql> GRANT ALL ON digikam .* TO digikam@flammenflitzer IDENTIFIED BY '12345678';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE DATABASE digithumb;
Query OK, 1 row affected (0.00 sec)
mysql> USE digithumb;
Database changed
mysql> GRANT ALL ON digithumb .* TO digikam@flammenflitzer IDENTIFIED BY '12345678';
Query OK, 0 rows affected (0.04 sec)
??? Oder sollte da stehen: GRANT ALL ON digikam .* TO digithumb@flammenflitzer IDENTIFIED BY '12345678';
??? Ist da ein Eingabefehler dabei: statt -> GRANT ALL ON digikam .* TO -> GRANT ALL ON digikam.* TO (Ich glaube, da war ein Leerzeichen zuviel drin.)
GRANT ALL ON digikam .* TO -> GRANT ALL ON digikam.* TO (Ich glaube, da war ein Leerzeichen zuviel drin.)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)
|
Also 2 DB angelegt.
| Code: | mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| akonadi |
| amarok |
| digikam |
| digithumb |
| mysql |
| test |
| thumbnails |
| Code: | digikam Einstellungen
Hostname: flammenflitzer oder 127.0.0.1
Schema Name: digikam.db
Thumbnails Schema Name: digithumb.db
Port: 3306
Username: digikam
Password: 12345678
"Datenbankverbindung erfolgreich geprüft" |
Oder bin ich total auf dem falschen Dampfer.
| Code: | GRANT ALL ON digikam .* TO >muss hier vielleicht mein Username rein ?<@flammenflitzer IDENTIFIED BY 'Muss hier mein Passwort rein?';
GRANT ALL ON digikam .* TO olaf@flammenflitzer IDENTIFIED BY 'mein Olaf Passwort; |
In der Vergangeheit habe ich immer nur eine DB anlegen müssen. |
|
| Back to top |
|
|
flammenflitzer
Advocate
Joined: 25 Nov 2003
Posts: 2951
Location: Berlin
|
| Posted: Sun Apr 28, 2013 7:05 pm Post subject: |
|
|
| Code: | mysql> DROP DATABASE digikam;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> DROP DATABASE digithumb;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> CREATE DATABASE digikam;
Query OK, 1 row affected (0.00 sec)
mysql> USE digikam;
Database changed
mysql> GRANT ALL ON digikam.* TO digikam_user@localhost IDENTIFIED BY 'okmm4538';
Query OK, 0 rows affected (0.01 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec) |
| Code: |
digikam Einstellungen
Hostname: localhost
Schema Name: digikam
Thumbnails Schema Name: digikam
Port: 3306
Username: digikam_user
Password: okmm4538
"Datenbankverbindung erfolgreich geprüft" |
Die hatte ich auch schon in der Vergangenheit
| Code: | Sie besitzen nicht die nötigen Rechte für die Datenbank.
Sie besitzen fplgende Rechte nicht:
CREATE TRIGGER
Überprüfen Sie die Rechte Ihrer Datenbank und starten Sie digiKam neu. |
In der Vergangenheit half | Code: |
mysql> GRANT ALL ON *.* TO digikam_user@localhost IDENTIFIED BY 'okmm4538'; |
| Code: |
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) |
Das funktioniert jetzt nicht mehr |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Deutsches Forum (German)
