Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[gelöst] digikam extern mysql
View unanswered posts
View posts from last 24 hours
View posts from last 7 days

 
Reply to topic    Gentoo Forums Forum Index Deutsches Forum (German)
View previous topic :: View next topic  
Author Message
flammenflitzer
Advocate
Advocate


Joined: 25 Nov 2003
Posts: 3116
Location: Berlin

PostPosted: Thu May 12, 2011 4:00 pm    Post subject: [gelöst] digikam extern mysql Reply with quote

Hallo,
ich habe
Code:
media-gfx/digikam-1.9.0-r1  USE="addressbook (-aqua) -debug -doc geolocation gphoto2 handbook (-kdeenablefinal) mysql semantic-desktop -themedesigner thumbnails video"

installiert. Jetzt wollte ich mysql extern nutzen.
Code:

flammenflitzer olaf # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.1.56 Gentoo Linux mysql-5.1.56

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE digikam;
Query OK, 1 row affected (0.06 sec)

mysql> USE digikam;
Database changed
mysql> GRANT ALL ON digikam .* TO digikam_user@loclahost IDENTIFIED BY 'meinPasswort';
Query OK, 0 rows affected (0.09 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.08 sec)

mysql> quit;
Bye
flammenflitzer olaf #
digikam Einstellungen
Code:

Hostname: localhost
 Schema Name: digikam
 Thumbnails Schema Name: digikam
 Port: 3306
 Username: digikam_user
 Password: meinPasswort
Fehlermeldung
Code:

Der Datenbankverbindungstest ist nicht erfolgreich gewesen.
Der Fehler lautet: Access denied for user 'digikam_user'@'localhost' (using password: YES) QMYSQL: Verbindungsaufbau nicht möglich


Last edited by flammenflitzer on Sat May 14, 2011 5:57 am; edited 1 time in total
Back to top
View user's profile Send private message
Finswimmer
Moderator
Moderator


Joined: 02 Sep 2004
Posts: 5467
Location: Langen (Hessen), Germany

PostPosted: Thu May 12, 2011 5:16 pm    Post subject: Reply with quote

Aber über mysql -u -p -D digikam geht es?
_________________
Bitte auf Rechtschreibung, korrekte Formatierung und Höflichkeit achten!
Danke
Back to top
View user's profile Send private message
flammenflitzer
Advocate
Advocate


Joined: 25 Nov 2003
Posts: 3116
Location: Berlin

PostPosted: Thu May 12, 2011 5:56 pm    Post subject: Reply with quote

Code:
olaf@flammenflitzer ~ $ mysql -u -p -D digikam
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'digikam'
olaf@flammenflitzer ~ $

Ich habe amarok und akonadi mit extern mysql. Funktioniert beides.
Back to top
View user's profile Send private message
Finswimmer
Moderator
Moderator


Joined: 02 Sep 2004
Posts: 5467
Location: Langen (Hessen), Germany

PostPosted: Thu May 12, 2011 7:52 pm    Post subject: Reply with quote

flammenflitzer wrote:
Code:
olaf@flammenflitzer ~ $ mysql -u -p -D digikam
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'digikam'
olaf@flammenflitzer ~ $

Ich habe amarok und akonadi mit extern mysql. Funktioniert beides.


Ups.
Ich war zu faul.
-u erwartet den User und -p das Passwort:

mysql -uuser1 -ppasswort -Ddatenbank
_________________
Bitte auf Rechtschreibung, korrekte Formatierung und Höflichkeit achten!
Danke
Back to top
View user's profile Send private message
flammenflitzer
Advocate
Advocate


Joined: 25 Nov 2003
Posts: 3116
Location: Berlin

PostPosted: Fri May 13, 2011 5:02 pm    Post subject: Reply with quote

mysql -u digikam_user -p meinPasswort -D digikam
Enter password: meinPasswort
ERROR 1045 (28000): Access denied for user 'digikam_user'@'localhost' (using password: YES)
Back to top
View user's profile Send private message
flammenflitzer
Advocate
Advocate


Joined: 25 Nov 2003
Posts: 3116
Location: Berlin

PostPosted: Sat May 14, 2011 5:59 am    Post subject: Reply with quote

Code:
mysql> DROP DATABASE digikam;
Query OK, 0 rows affected (0.11 sec)

mysql> CREATE DATABASE digikam;
Query OK, 1 row affected (0.01 sec)

mysql> USE digikam;
Database changed
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (1.17 sec)

mysql> GRANT ALL ON digikam .* TO digikam@localhost IDENTIFIED BY 'meinPasswort';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> quit;
Bye

digikam Einstellungen
Code:
Hostname: localhost
 Schema Name: digikam
 Thumbnails Schema Name: digikam
 Port: 3306
 Username: digikam
 Password: meinPasswort
funktioniert. Danke
Back to top
View user's profile Send private message
flammenflitzer
Advocate
Advocate


Joined: 25 Nov 2003
Posts: 3116
Location: Berlin

PostPosted: Sun Aug 07, 2011 7:37 pm    Post subject: Reply with quote

Nach Update auf digikam2 funktioniert das nicht mehr. Die Migration ist auch fehlgeschlagen.
Back to top
View user's profile Send private message
boospy
Apprentice
Apprentice


Joined: 07 Feb 2010
Posts: 299
Location: Austria

PostPosted: Mon Aug 08, 2011 8:18 pm    Post subject: Reply with quote

Digikam2 hab ich maskiert, das Teil kannste da komplett vergessen. Aber BTW, MYSQL ladet die Bilder langsamer als ohne, was kann da sein das dies so ist. Wenn ich scrolle muss man einige Sekunden warten bis es weiter geht, hat man denn Ordner dann einmal komplett angezeigt kann man auch scrollen. Eigentlich sollte es ja wesentlich schneller sein, mit MYSQL.

lg
boospy
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Deutsches Forum (German) All times are GMT
Page 1 of 1

 
Jump to:  
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