[Digikam-users] Setting up MySQL Digikam database

[bruno.leon at nividic.org]

On 11-12-20 10:11 PM, upscope wrote:
> On Sunday, December 18, 2011 03:26:37 PM bruno.leon at nividic.org 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
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users