[Digikam-devel] [digikam] [Bug 327062] New: When a host is set for a user in mysql digikam fail to update

[e.longuemare at laposte.net]

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

            Bug ID: 327062
           Summary: When a host is set for a user in mysql digikam fail to
                    update
    Classification: Unclassified
           Product: digikam
           Version: 4.0.0-beta1
          Platform: Ubuntu Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
          Assignee: digikam-devel at kde.org
          Reporter: e.longuemare at laposte.net

digikam(8807)/digikam (core) Digikam::NewItemsFinder::slotTotalFilesToScan:
total scan value :  28165
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::Private::printExiv2MessageHandler:
Exiv2 ( 2 ) :  Directory Minolta, entry 0x0088: Data area exceeds data buffer,
ignoring it.
digikam(8807)/digikam (core) Digikam::DImg::load:
"/media/DiskphotosTests/archive materiel peche/aero
technium/eclaté_galet-shimano_aero_technium_et_ultegra_modifiee.jpg"  : JPEG
file identified
digikam(8807)/digikam (core) Digikam::ImageScanner::prepareAddImage: Adding new
item "/media/DiskphotosTests/archive materiel peche/aero
technium/eclaté_galet-shimano_aero_technium_et_ultegra_modifiee.jpg"
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::getImageDateTime: DateTime =>
Exif.Photo.DateTimeOriginal =>  QDateTime("jeu. juil. 16 13:25:39 2009")
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::getDigitizationDateTime: DateTime
(Exif digitalized):  jeu. juil. 16 13:25:39 2009
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::getImageOrientation: Orientation =>
Exif.Image.Orientation =>  1
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::Private::printExiv2ExceptionError:
Cannot find Xmp key 'Xmp.mwg-rs.Regions/mwg-rs:RegionList[1]/mwg-rs:Name' into
image using Exiv2   (Error # 35 :  No namespace info available for XMP prefix
`mwg-rs'
digikam(8807)/digikam (core) Digikam::ImageScanner::commit: Scanning took 213
ms
digikam(8807)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "REPLACE INTO Images  ( album, name, status, category, modificationDate,
fileSize, uniqueHash )  VALUES (?,?,?,?,?,?,?);" 
Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
definer ('sospcdk'@'%') does not exist" 1449 2 
Bound values:  (QVariant(int, 66) ,  QVariant(QString,
"eclaté_galet-shimano_aero_technium_et_ultegra_modifiee.jpg") ,  QVariant(int,
1) ,  QVariant(int, 1) ,  QVariant(QString, "2009-08-08T22:52:04") , 
QVariant(qlonglong, 1215494) ,  QVariant(QString,
"5a5d4cac3bc56330c42876f967ead5f5") )
digikam(8807)/digikam (core) Digikam::ImageScanner::~ImageScanner: Finishing
took 37 ms
[Thread 0x92efcb40 (LWP 8859) exited]
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::Private::printExiv2MessageHandler:
Exiv2 ( 2 ) :  Directory Minolta, entry 0x0088: Data area exceeds data buffer,
ignoring it.
digikam(8807)/digikam (core) Digikam::DImg::load:
"/media/DiskphotosTests/vendee 2010/bretignolle juin 2010
immersion/lune_bretignolles.jpg"  : JPEG file identified
digikam(8807)/digikam (core) Digikam::ImageScanner::prepareAddImage: Adding new
item "/media/DiskphotosTests/vendee 2010/bretignolle juin 2010
immersion/lune_bretignolles.jpg"
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::getImageDateTime: DateTime =>
Exif.Photo.DateTimeOriginal =>  QDateTime("lun. juin 21 23:55:11 2010")
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::getDigitizationDateTime: DateTime
(Exif digitalized):  lun. juin 21 23:55:11 2010
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::getImageOrientation: Orientation =>
Exif.Image.Orientation =>  1
digikam(8807)/digikam (core) Digikam::ImageScanner::scanTags: Pick Label found
:  0
digikam(8807)/digikam (core) Digikam::ImageScanner::scanTags: Assigned Pick
Label Tag  :  12
digikam(8807)/digikam (core) Digikam::ImageScanner::scanTags: Color Label found
:  0
digikam(8807)/digikam (core) Digikam::ImageScanner::scanTags: Assigned Color
Label Tag  :  2
digikam(8807)/KEXIV2 KExiv2Iface::KExiv2::Private::printExiv2ExceptionError:
Cannot find Xmp key 'Xmp.mwg-rs.Regions/mwg-rs:RegionList[1]/mwg-rs:Name' into
image using Exiv2   (Error # 35 :  No namespace info available for XMP prefix
`mwg-rs'
digikam(8807)/digikam (core) Digikam::DMetadata::getImageHistory: Loading image
history  "<?xml version="1.0"?>
<history version="1">
    <file
uuid="3b6a2a35ffeb7720318bf7910e7f2265da8767f8944cc68cde090b7fe3abddd3"
type="original">
        <fileParams fileName="lune_bretignolles.JPG"
filePath="/media/Diskphotos/vendee 2010/bretignolle juin 2010 immersion/"
fileHash="da8767f8944cc68cde090b7fe3abddd3" fileSize="2159724"
creationDate="2010-06-21T23:55:11"/>
    </file>
</history>
"
digikam(8807)/digikam (core) Digikam::ImageScanner::commit: Scanning took 77 ms
digikam(8807)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "REPLACE INTO Images  ( album, name, status, category, modificationDate,
fileSize, uniqueHash )  VALUES (?,?,?,?,?,?,?);" 
Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
definer ('sospcdk'@'%') does not exist" 1449 2 
Bound values:  (QVariant(int, 346) ,  QVariant(QString,
"lune_bretignolles.jpg") ,  QVariant(int, 1) ,  QVariant(int, 1) , 
QVariant(QString, "2013-08-28T14:37:45") ,  QVariant(qlonglong, 1235703) , 
QVariant(QString, "43ded3850723a4d62f52315057f927ac") )
digikam(8807)/digikam (core) Digikam::ImageScanner::~ImageScanner: Finishing
took 11 ms


Reproducible: Always

Steps to Reproduce:
1. Set a hosts for a user in mysql
2.start digikam
3.let collection  scan go ahead
Actual Results:  
See gdb trace : 
digikam(8807)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "REPLACE INTO Images  ( album, name, status, category, modificationDate,
fileSize, uniqueHash )  VALUES (?,?,?,?,?,?,?);" 
Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
definer ('username'@'%') does not exist" 1449 2 

Expected Results:  
Update is ok with a limited host IP for user in mysql (set to any is unsecure)

I use external mysql server

workaround : set digikam database use hosts authorization to any (unsecure)
reproducible : always

-- 
You are receiving this mail because:
You are the assignee for the bug.