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@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@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>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Vlado Plaga]

Am Thu, 12 Aug 2010 12:28:32 +0200
schrieb Hans Kamann <[hidden email]>:

> 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

Is a "schema" a different name for a database? I don't know much about
mysql, but I set it up successfully. See my e-mail digikam-users just
a few minutes ago.

In your screenshot the entries "schema name" and "thumbnails schema
name" look strange, more like directory paths...

Vlado
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[David Kerber]

On 10/1/2010 10:31 AM, Vlado Plaga wrote:

> Am Thu, 12 Aug 2010 12:28:32 +0200
> schrieb Hans Kamann<[hidden email]>:
>
>> 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
>
> Is a "schema" a different name for a database? I don't know much about
> mysql, but I set it up successfully. See my e-mail digikam-users just
> a few minutes ago.

"Schema" is the term for the database object descriptions:  tables,
fields, indexes, etc.

>
> In your screenshot the entries "schema name" and "thumbnails schema
> name" look strange, more like directory paths...
>
> Vlado

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Jonas Norlander]

2010/8/12 Hans Kamann <[hidden email]>:
> 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.
>

I can't help you, only confirm that you are not alone with this
problem. I created a database and a user with full rights to that
database so I don't think it has anything to do with access rights or
the connection as I can connets as that user from the CLI.

Kubuntu 10.04
KDE 4.5.1
Digikam 1.4.0

/ Jonas
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users