Setting up MySQL Digikam database

[upscope]

Been trying to setup Digikam (Version 2.3.0
Using KDE Development Platform 4.7.4 (4.7.4) "release 11") for a week
now.  I want to use the MySQl server I have on local host. Everthing
appears to be setup correctly.

Database type is MySQL
from digikamrc:
Code
--------------
[Database Settings]
Database Connectoptions=digikambdb
Database Hostname=localhost
Database Name=/home/finemanruss/Documents/Pictures/digikam4.db
Database
NameThumbnails=/home/finemanruss/Documents/Pictures/thumbnails-
digikam.db
Database Password=xxxxxxxxxxxxx(actual password here)
Database Port=3306
Database Type=QMYSQL
Database Username=digikamuser (my user ID is member of digikamuser
group)
Internal Database Server=false
/Code
-------------
Check dbconnection : Database connection test successful. (as
digikamuser)

On mysql server I created two databases: digikamdb and digikamthumbdb.
Also created a digikamuser group which my user name is in.

I can log into the databasefrom a command line as digikamuser, my Id and
root with no problem.

Think my problem is the Database name and NameThumbnails lines above.
Also what permissions does digikamuser need on the database and does it
setup the tables?

Can not find a section in manual on setting up the database. I do have a
Kmymoney and 2 Lions Clubs databases on local host and they work fine.

Any help would be greatly appreciated. Link to a how to document would
help.

Thanks in advance

--
Russ
openSUSE 12.1(Linux 3.1.0-1.2-desktop x86_64)|KDE Platform
Version 4.7.4 (4.7.4) Release "11"|Intel core2duo 2.5 MHZ, |8GB DDR3|
GeForce 8400GS (NVIDIA-Linux-x86_64-285.05.09)  

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

[brunoleon]

If you speak french, I kept a procedure for this as I also had a hard
time making this work.

http://blog.pompomgali.com/?p=141

--
Bruno

On 11-12-17 02:07 PM, upscope wrote:

> Been trying to setup Digikam (Version 2.3.0
> Using KDE Development Platform 4.7.4 (4.7.4) "release 11") for a week
> now.  I want to use the MySQl server I have on local host. Everthing
> appears to be setup correctly.
>
> Database type is MySQL
> from digikamrc:
> Code
> --------------
> [Database Settings]
> Database Connectoptions=digikambdb
> Database Hostname=localhost
> Database Name=/home/finemanruss/Documents/Pictures/digikam4.db
> Database
> NameThumbnails=/home/finemanruss/Documents/Pictures/thumbnails-
> digikam.db
> Database Password=xxxxxxxxxxxxx(actual password here)
> Database Port=3306
> Database Type=QMYSQL
> Database Username=digikamuser (my user ID is member of digikamuser
> group)
> Internal Database Server=false
> /Code
> -------------
> Check dbconnection : Database connection test successful. (as
> digikamuser)
>
> On mysql server I created two databases: digikamdb and digikamthumbdb.
> Also created a digikamuser group which my user name is in.
>
> I can log into the databasefrom a command line as digikamuser, my Id and
> root with no problem.
>
> Think my problem is the Database name and NameThumbnails lines above.
> Also what permissions does digikamuser need on the database and does it
> setup the tables?
>
> Can not find a section in manual on setting up the database. I do have a
> Kmymoney and 2 Lions Clubs databases on local host and they work fine.
>
> Any help would be greatly appreciated. Link to a how to document would
> help.
>
> Thanks in advance
>

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

[upscope]

Thanks. Looks fairly straight forward. Will try in morning. Did not need
english version even though i do noy read French. I did run it thru the
Konqueror translatoe and it can out in English, so now I can read it
all.

will post my results.

On Sunday, December 18, 2011 03:26:37 PM [hidden email] wrote:
> http://blog.pompomgali.com/?p=141
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[upscope]

On Sunday, December 18, 2011 03:26:37 PM [hidden email] wrote:

> If you speak french, I kept a procedure for this as I also had a hard
> time making this work.
>
> http://blog.pompomgali.com/?p=141
>
> > Been trying to setup Digikam (Version 2.3.0
> > Using KDE Development Platform 4.7.4 (4.7.4) "release 11") for a
> > week now.  I want to use the MySQl server I have on local host.
> > Everthing appears to be setup correctly.
> >
> > Database type is MySQL
> > from digikamrc:
> > Code
> > --------------
> > [Database Settings]
> > Database Connectoptions=digikambdb
> > Database Hostname=localhost
> > Database Name=/home/finemanruss/Documents/Pictures/digikam4.db
> > Database
> > NameThumbnails=/home/finemanruss/Documents/Pictures/thumbnails-
> > digikam.db
> > Database Password=xxxxxxxxxxxxx(actual password here)
> > Database Port=3306
> > Database Type=QMYSQL
> > Database Username=digikamuser (my user ID is member of digikamuser
> > group)
> > Internal Database Server=false
> > /Code
> > -------------
> > Check dbconnection : Database connection test successful. (as
> > digikamuser)
> >
> > On mysql server I created two databases: digikamdb and
> > digikamthumbdb. Also created a digikamuser group which my user
> > name is in.
> >
> > I can log into the databasefrom a command line as digikamuser, my
> > Id and root with no problem.
> >
> > Think my problem is the Database name and NameThumbnails lines
> > above. Also what permissions does digikamuser need on the
> > database and does it setup the tables?
> >
> > Can not find a section in manual on setting up the database. I do
> > have a Kmymoney and 2 Lions Clubs databases on local host and
> > they work fine.
> >
> > Any help would be greatly appreciated. Link to a how to document
> > would help.
> >
> > Thanks in advance

Bruno Thanks alot I fine got to it today and everything is working ao
far. Had one little issue with typing the password correctly into
digikamrc but the error message was very explicied on what to check.

Your write was great even before I translated it.

Thanks Again! Hope I can help someone in the future.

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

[brunoleon]

On 11-12-20 10:11 PM, upscope wrote:

> On Sunday, December 18, 2011 03:26:37 PM [hidden email] wrote:
>> If you speak french, I kept a procedure for this as I also had a hard
>> time making this work.
>>
>> http://blog.pompomgali.com/?p=141
>>
>>> Been trying to setup Digikam (Version 2.3.0
>>> Using KDE Development Platform 4.7.4 (4.7.4) "release 11") for a
>>> week now.  I want to use the MySQl server I have on local host.
>>> Everthing appears to be setup correctly.
>>>
>>> Database type is MySQL
>>> from digikamrc:
>>> Code
>>> --------------
>>> [Database Settings]
>>> Database Connectoptions=digikambdb
>>> Database Hostname=localhost
>>> Database Name=/home/finemanruss/Documents/Pictures/digikam4.db
>>> Database
>>> NameThumbnails=/home/finemanruss/Documents/Pictures/thumbnails-
>>> digikam.db
>>> Database Password=xxxxxxxxxxxxx(actual password here)
>>> Database Port=3306
>>> Database Type=QMYSQL
>>> Database Username=digikamuser (my user ID is member of digikamuser
>>> group)
>>> Internal Database Server=false
>>> /Code
>>> -------------
>>> Check dbconnection : Database connection test successful. (as
>>> digikamuser)
>>>
>>> On mysql server I created two databases: digikamdb and
>>> digikamthumbdb. Also created a digikamuser group which my user
>>> name is in.
>>>
>>> I can log into the databasefrom a command line as digikamuser, my
>>> Id and root with no problem.
>>>
>>> Think my problem is the Database name and NameThumbnails lines
>>> above. Also what permissions does digikamuser need on the
>>> database and does it setup the tables?
>>>
>>> Can not find a section in manual on setting up the database. I do
>>> have a Kmymoney and 2 Lions Clubs databases on local host and
>>> they work fine.
>>>
>>> Any help would be greatly appreciated. Link to a how to document
>>> would help.
>>>
>>> Thanks in advance
> Bruno Thanks alot I fine got to it today and everything is working ao
> far. Had one little issue with typing the password correctly into
> digikamrc but the error message was very explicied on what to check.
>
> Your write was great even before I translated it.
>
> Thanks Again! Hope I can help someone in the future.
>
> Russ

Great !
Enjoy Digikam now ;-)
>> _______________________________________________
>> Digikam-users mailing list
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users

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

[Petr V.]

Thank you very much for this howto. I had difficulties as well.

 <bruno.leon@...> writes:

>
> If you speak french, I kept a procedure for this as I also had a hard
> time making this work.
>
> http://blog.pompomgali.com/?p=141
>




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