[Digikam-users] Digikam and mysql support

[Hans Kamann]

I'm trying to enable mysql in digikam. Mysql is up and running and
listening on 3306, a user "digikam" is available and the schema
"digikam" as well. But digikam is apparently neither able to connect nor
creating it's tables, see screenshot attached.

See mysql settings below:

hkamann at laptop-hans:~> mysqladmin -h `hostname` --port=3306 version
mysqladmin  Ver 8.42 Distrib 5.1.46, for suse-linux-gnu on i686
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.1.46-log
Protocol version        10
Connection              laptop-hans.kaman via TCP/IP
TCP port                3306
Uptime:                 2 hours 38 min 7 sec

Threads: 1  Questions: 27  Slow queries: 0  Opens: 15  Flush tables: 1
Open tables: 8  Queries per second avg: 0.2
hkamann at laptop-hans:~> mysql -udigikam -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 611
Server version: 5.1.46-log SUSE MySQL RPM

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> use digikam
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: digikam_snapshot.png
Type: image/png
Size: 173768 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20100812/345f4665/attachment.png>