[Digikam-devel] [Bug 279580] Unable to get MySQL to work after update to 2.0

[Francesco Riosa]

https://bugs.kde.org/show_bug.cgi?id=279580


Francesco Riosa <francesco+kde at pnpitalia.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |francesco+kde at pnpitalia.it




--- Comment #2 from Francesco Riosa <francesco+kde pnpitalia it>  2011-08-08 21:10:36 ---
Hi, I'm on a guest pc so cannot test before write but a know to work procedure
is:

1) create a sqlite database
2) create an empty mysql schema say "digikam"
3) give all privileges to a user, on the schema "digikam" and flush privileges
4) migrate from sqlite to mysql

It's not possible at the moment to use two separate databases for mysql, it's
an open bug which is actively worked on.

In any case it's important for me to know what don't go as expected,adding the
following to your my.cnf, in the section [mysqld] allow for logging mysql
queryes:
[mysqld]
general_log_file = /var/log/mysql/general_log.sql
/var/log/mysql/ must be existant and with owner mysql

and something like the following to $HOME/.kde4/share/config/kdebugrc, replace
the path with a suitable one, the real interesting one is 50003 

[50003]
InfoFilename=/home/vivo/digikam-devel/log/digikam-core-50003.log
InfoOutput=0

[50004]
InfoFilename=/home/vivo/digikam-devel/log/digikam-kio-50004.log
InfoOutput=0

[50005]
InfoFilename=/home/vivo/digikam-devel/log/digikam-showfoto-50005.log
InfoOutput=0

[50006]
InfoFilename=/home/vivo/digikam-devel/log/digikam-plugins-50006.log
InfoOutput=0

[50007]
InfoFilename=/home/vivo/digikam-devel/log/digikam-dbserver-50007.log
InfoOutput=0

please, if possible attach the logs for a failed attempt to this bug
I'll be slow to answer until after aug 15

regards, Francesco

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.