Bug 753401

Summary: Digikam is not able to create MySQL databases
Product: [Fedora] Fedora Reporter: Alberto Ferrante <alberto_ferrante>
Component: digikamAssignee: Steven M. Parrish <smparrish>
Status: CLOSED WONTFIX QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 16CC: alekcejk, ltinkl, rdieter, smparrish
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-02-13 22:25:04 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Alberto Ferrante 2011-11-12 09:25:03 UTC
Description of problem:
If MySQL is selected as a DB for Digikam, the software should create the tables in the two schemas (digikam, and thumbnails-digikam). It creates them in the first schema (digikam) and then gives the error message "failed to create tables in database".
If trying to import a SQLite DB into MySQL the program gives the "error
while creating the database schema" message instead.


Version-Release number of selected component (if applicable):
2.2 and 2.3 (from testing repo)

How reproducible:
Always

Steps to Reproduce:
0. Create two schemas in MySQL and give proper access rights
1. Go in preferences of Digikam, DB options
2. select MySQL and enter the credentials
3. Push "OK"
  
Actual results:
the program gives the error "failed to create tables in database"

Expected results:
the tables should be created and Digikam should start using MySQL as a database.

Additional info:

Comment 1 Alberto Ferrante 2011-11-12 09:34:27 UTC
The problem seems to be Fedora-related only; with other distributions people seem to be able to use MySQL DBs in Digikam just fine.

Comment 2 Rex Dieter 2011-11-28 15:56:51 UTC
Well, first off, if using mysql, is mysql-server installed and service running?

Comment 3 Alberto Ferrante 2011-11-28 16:09:06 UTC
Yes, sure.
I am now running Digikam with MySQL, but I had to create the DB under Ubuntu, export it and import it into my main DB. The problem is in the table creation phase and it is not a permission problem (I even tried using the MySQL admin account!).

Comment 4 Fedora End Of Life 2013-01-16 17:34:41 UTC
This message is a reminder that Fedora 16 is nearing its end of life.
Approximately 4 (four) weeks from now Fedora will stop maintaining
and issuing updates for Fedora 16. It is Fedora's policy to close all
bug reports from releases that are no longer maintained. At that time
this bug will be closed as WONTFIX if it remains open with a Fedora 
'version' of '16'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version' 
to a later Fedora version prior to Fedora 16's end of life.

Bug Reporter: Thank you for reporting this issue and we are sorry that 
we may not be able to fix it before Fedora 16 is end of life. If you 
would still like to see this bug fixed and are able to reproduce it 
against a later version of Fedora, you are encouraged to click on 
"Clone This Bug" and open it against that version of Fedora.

Although we aim to fix as many bugs as possible during every release's 
lifetime, sometimes those efforts are overtaken by events. Often a 
more recent Fedora release includes newer upstream software that fixes 
bugs or makes them obsolete.

The process we are following is described here: 
http://fedoraproject.org/wiki/BugZappers/HouseKeeping

Comment 5 Fedora End Of Life 2013-02-13 22:25:08 UTC
Fedora 16 changed to end-of-life (EOL) status on 2013-02-12. Fedora 16 is 
no longer maintained, which means that it will not receive any further 
security or bug fix updates. As a result we are closing this bug.

If you can reproduce this bug against a currently maintained version of 
Fedora please feel free to reopen this bug against that version.

Thank you for reporting this bug and we are sorry it could not be fixed.