<div dir="ltr">I see you post on ML about your MySQL patches, but, your patches are not visible as attachements.<div><br></div><div>I recommend to open a new file in bugzilla into digiKam/database-schema section for each patches instead to use ML. Never use ML for patches, it's not safe.</div><div><br></div><div>Thanks in advance for your work.</div><div><br></div><div>Gilles Caulier</div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-11-24 10:24 GMT+01:00 Richard Mortimer <span dir="ltr"><<a href="mailto:richm+digikam@oldelvet.org.uk" target="_blank">richm+digikam@oldelvet.org.uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Thanks for the tips. I haven't tried any of your solutions yet (have<br>
just been removing the plugin .so file when testing a new build). I'll<br>
probably just use your first solution later today.<br>
<br>
I made some good progress on MySQL last night. I have a schema that does<br>
not require "SUPER" privilege. Basically I removed the triggers and<br>
replaced them with foreign key references configured to have the same<br>
semantics as the triggers.<br>
<br>
Proof of concept patch series to follow.<br>
<br>
Regards<br>
<br>
Richard<br>
<span class=""><br>
On 23/11/2015 14:39, Gilles Caulier wrote:<br>
> The imgur problem have been already reported to digiKam users ML.<br>
><br>
> In fact the imgur tool can use a shared lib to extend capability. Look<br>
> DEPENDENCIES file :<br>
><br>
> libqtkoauth opt >= 0.97 ImgUr tool. This lib must be<br>
> compiled with Qt5.<br>
><br>
> if this lib is Qt4 based the mix Qt4/Qt5 is not compatible and crash. So<br>
> 2 solutions :<br>
><br>
> /1 remove libqtkoauth as well and recompile kipi-plugins.<br>
> /2 remove libqtkoauth and recompile it against Qt5, and recompile<br>
> kipi-plugins.<br>
><br>
> Gilles Caulier<br>
><br>
><br>
><br>
><br>
> 2015-11-23 15:29 GMT+01:00 Richard Mortimer<br>
</span>> <<a href="mailto:richm%2Bdigikam@oldelvet.org.uk">richm+digikam@oldelvet.org.uk</a> <mailto:<a href="mailto:richm%2Bdigikam@oldelvet.org.uk">richm+digikam@oldelvet.org.uk</a>>>:<br>
<span class="">><br>
><br>
><br>
> On 23/11/2015 10:48, Gilles Caulier wrote:<br>
> ><br>
> ><br>
> > 2015-11-23 11:42 GMT+01:00 Richard Mortimer<br>
> > <<a href="mailto:richm%2Bdigikam@oldelvet.org.uk">richm+digikam@oldelvet.org.uk</a><br>
</span>> <mailto:<a href="mailto:richm%252Bdigikam@oldelvet.org.uk">richm%2Bdigikam@oldelvet.org.uk</a>><br>
> <mailto:<a href="mailto:richm%2Bdigikam@oldelvet.org.uk">richm+digikam@oldelvet.org.uk</a><br>
> <mailto:<a href="mailto:richm%252Bdigikam@oldelvet.org.uk">richm%2Bdigikam@oldelvet.org.uk</a>>>>:<br>
<div><div class="h5">> ><br>
> > ok. And don't forget to update local source code with "git up". You can<br>
> > use root script "gits" located to top level directory of source code.<br>
> > This one will update all git components comming with digiKam Software<br>
> > compilation. the update will be recursive.<br>
> Thanks. Did that.<br>
><br>
> ><br>
> > PS : i currently working to be able to setup a specific place to host<br>
> > database with internal server (as with Sqlite). Currently it still<br>
> > located in ~/.local/share/digikam<br>
> Will bear that in mind.<br>
><br>
> I now have it running. Yah!<br>
><br>
> I had a problem with kipiplugin_imgur.so that seems to be linked against<br>
> some QT4 libraries and was causing a segmentation violation on startup.<br>
> For now I have just removed the .so file from<br>
> /usr/lib/x86_64-linux-gnu/qt5/plugins/kipiplugin_imgur.so<br>
> and digikam now starts up fully.<br>
><br>
> I've included the ldd output for the imgur plugin below and can clearly<br>
> see that it is using some qt4 libraries in a couple of places. I'm not<br>
> sure if that is a build issue or whether another dependency is not<br>
> installed in my build environment.<br>
><br>
> I have ran out of time for testing now but will try again tonight and<br>
> hopefully will be able to get some MySQL testing done.<br>
><br>
> Regards<br>
><br>
> Richard<br>
><br>
><br>
> ldd<br>
> digikam-software-compilation/build/extra/kipi-plugins/imgur/kipiplugin_imgur.so<br>
> linux-vdso.so.1 => (0x00007ffe0ad2d000)<br>
> libKF5KIOCore.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5KIOCore.so.5<br>
> (0x00007fd5a875f000)<br>
> libKF5kipiplugins.so.5.0.0 =><br>
> /home/laptop/Git/digikam/digikam-software-compilation/build/extra/kipi-plugins/common/libkipiplugins/libKF5kipiplugins.so.5.0.0<br>
> (0x00007fd5a84cf000)<br>
> libkqoauth.so.0 => /usr/lib/x86_64-linux-gnu/libkqoauth.so.0<br>
> (0x00007fd5a82ab000)<br>
> libKF5Kipi.so.30.0.0 =><br>
> /home/laptop/Git/digikam/digikam-software-compilation/build/extra/libkipi/src/libKF5Kipi.so.30.0.0<br>
> (0x00007fd5a807b000)<br>
> libKF5XmlGui.so.5 => /usr/lib/x86_64-linux-gnu/libKF5XmlGui.so.5<br>
> (0x00007fd5a7d8d000)<br>
> libKF5WindowSystem.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5WindowSystem.so.5 (0x00007fd5a7b46000)<br>
> libKF5ConfigGui.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5ConfigGui.so.5<br>
> (0x00007fd5a7927000)<br>
> libQt5Widgets.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5<br>
> (0x00007fd5a72a6000)<br>
> libKF5CoreAddons.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5CoreAddons.so.5 (0x00007fd5a7021000)<br>
> libKF5I18n.so.5 => /usr/lib/x86_64-linux-gnu/libKF5I18n.so.5<br>
> (0x00007fd5a6def000)<br>
> libQt5Gui.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5<br>
> (0x00007fd5a68b5000)<br>
> libKF5ConfigCore.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5ConfigCore.so.5 (0x00007fd5a665a000)<br>
> libQt5Core.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Core.so.5<br>
> (0x00007fd5a619e000)<br>
> libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6<br>
> (0x00007fd5a5e1c000)<br>
> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6<br>
> (0x00007fd5a5a52000)<br>
> libKF5Service.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5Service.so.5<br>
> (0x00007fd5a57be000)<br>
> libQt5Network.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libQt5Network.so.5<br>
> (0x00007fd5a8d8f000)<br>
> libQt5Xml.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Xml.so.5<br>
> (0x00007fd5a8d53000)<br>
> libKF5DBusAddons.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5DBusAddons.so.5 (0x00007fd5a55ae000)<br>
> libacl.so.1 => /lib/x86_64-linux-gnu/libacl.so.1<br>
> (0x00007fd5a53a5000)<br>
> libQt5DBus.so.5 => /usr/lib/x86_64-linux-gnu/libQt5DBus.so.5<br>
> (0x00007fd5a5324000)<br>
> libKF5ConfigWidgets.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5ConfigWidgets.so.5 (0x00007fd5a50d9000)<br>
> libQtGui.so.4 => /usr/lib/x86_64-linux-gnu/libQtGui.so.4<br>
> (0x00007fd5a43e8000)<br>
> libQtNetwork.so.4 => /usr/lib/x86_64-linux-gnu/libQtNetwork.so.4<br>
> (0x00007fd5a4094000)<br>
> libQtCore.so.4 => /usr/lib/x86_64-linux-gnu/libQtCore.so.4<br>
> (0x00007fd5a3ba2000)<br>
> libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1<br>
> (0x00007fd5a398b000)<br>
> libQt5PrintSupport.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libQt5PrintSupport.so.5 (0x00007fd5a3918000)<br>
> libKF5TextWidgets.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5TextWidgets.so.5 (0x00007fd5a36db000)<br>
> libKF5GlobalAccel.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5GlobalAccel.so.5 (0x00007fd5a34ba000)<br>
> libKF5Attica.so.5 => /usr/lib/x86_64-linux-gnu/libKF5Attica.so.5<br>
> (0x00007fd5a3222000)<br>
> libKF5IconThemes.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5IconThemes.so.5 (0x00007fd5a2fe8000)<br>
> libKF5WidgetsAddons.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5WidgetsAddons.so.5 (0x00007fd5a2cb4000)<br>
> libKF5ItemViews.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5ItemViews.so.5<br>
> (0x00007fd5a2a7c000)<br>
> libQt5X11Extras.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libQt5X11Extras.so.5<br>
> (0x00007fd5a8d48000)<br>
> libX11.so.6 => /usr/lib/x86_64-linux-gnu/libX11.so.6<br>
> (0x00007fd5a2742000)<br>
> libxcb.so.1 => /usr/lib/x86_64-linux-gnu/libxcb.so.1<br>
> (0x00007fd5a2521000)<br>
> libxcb-keysyms.so.1 =><br>
> /usr/lib/x86_64-linux-gnu/libxcb-keysyms.so.1<br>
> (0x00007fd5a231e000)<br>
> libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0<br>
> (0x00007fd5a2100000)<br>
> libgobject-2.0.so.0 =><br>
> /usr/lib/x86_64-linux-gnu/libgobject-2.0.so.0<br>
> (0x00007fd5a1ead000)<br>
> libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0<br>
> (0x00007fd5a1b9e000)<br>
> libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6<br>
> (0x00007fd5a1896000)<br>
> libfam.so.0 => /usr/lib/libfam.so.0 (0x00007fd5a168d000)<br>
> libpng12.so.0 => /lib/x86_64-linux-gnu/libpng12.so.0<br>
> (0x00007fd5a1467000)<br>
> libharfbuzz.so.0 => /usr/lib/x86_64-linux-gnu/libharfbuzz.so.0<br>
> (0x00007fd5a1209000)<br>
> libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1<br>
> (0x00007fd5a0fef000)<br>
> libGL.so.1 => /usr/lib/x86_64-linux-gnu/mesa/libGL.so.1<br>
> (0x00007fd5a0d57000)<br>
> libicui18n.so.55 => /usr/lib/x86_64-linux-gnu/libicui18n.so.55<br>
> (0x00007fd5a08f4000)<br>
> libicuuc.so.55 => /usr/lib/x86_64-linux-gnu/libicuuc.so.55<br>
> (0x00007fd5a0560000)<br>
> libpcre16.so.3 => /usr/lib/x86_64-linux-gnu/libpcre16.so.3<br>
> (0x00007fd5a02fd000)<br>
> libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2<br>
> (0x00007fd5a00f9000)<br>
> librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1<br>
> (0x00007fd59fef1000)<br>
> /lib64/ld-linux-x86-64.so.2 (0x00007fd5a8ce5000)<br>
> libattr.so.1 => /lib/x86_64-linux-gnu/libattr.so.1<br>
> (0x00007fd59fcec000)<br>
> libdbus-1.so.3 => /lib/x86_64-linux-gnu/libdbus-1.so.3<br>
> (0x00007fd59faa0000)<br>
> libKF5Codecs.so.5 => /usr/lib/x86_64-linux-gnu/libKF5Codecs.so.5<br>
> (0x00007fd59f867000)<br>
> libKF5Auth.so.5 => /usr/lib/x86_64-linux-gnu/libKF5Auth.so.5<br>
> (0x00007fd59f654000)<br>
> libKF5GuiAddons.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5GuiAddons.so.5<br>
> (0x00007fd59f43b000)<br>
> libfontconfig.so.1 =><br>
> /usr/lib/x86_64-linux-gnu/libfontconfig.so.1<br>
> (0x00007fd59f1fd000)<br>
> libaudio.so.2 => /usr/lib/x86_64-linux-gnu/libaudio.so.2<br>
> (0x00007fd59efe4000)<br>
> libfreetype.so.6 => /usr/lib/x86_64-linux-gnu/libfreetype.so.6<br>
> (0x00007fd59ed3e000)<br>
> libSM.so.6 => /usr/lib/x86_64-linux-gnu/libSM.so.6<br>
> (0x00007fd59eb36000)<br>
> libICE.so.6 => /usr/lib/x86_64-linux-gnu/libICE.so.6<br>
> (0x00007fd59e91c000)<br>
> libXi.so.6 => /usr/lib/x86_64-linux-gnu/libXi.so.6<br>
> (0x00007fd59e70c000)<br>
> libXrender.so.1 => /usr/lib/x86_64-linux-gnu/libXrender.so.1<br>
> (0x00007fd59e502000)<br>
> libXext.so.6 => /usr/lib/x86_64-linux-gnu/libXext.so.6<br>
> (0x00007fd59e2f0000)<br>
> libKF5SonnetUi.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5SonnetUi.so.5<br>
> (0x00007fd59e0ce000)<br>
> libKF5SonnetCore.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5SonnetCore.so.5 (0x00007fd59dead000)<br>
> libKF5Completion.so.5 =><br>
> /usr/lib/x86_64-linux-gnu/libKF5Completion.so.5 (0x00007fd59dc78000)<br>
> libQt5Svg.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Svg.so.5<br>
> (0x00007fd59dc21000)<br>
> libXau.so.6 => /usr/lib/x86_64-linux-gnu/libXau.so.6<br>
> (0x00007fd59da1d000)<br>
> libXdmcp.so.6 => /usr/lib/x86_64-linux-gnu/libXdmcp.so.6<br>
> (0x00007fd59d817000)<br>
> libffi.so.6 => /usr/lib/x86_64-linux-gnu/libffi.so.6<br>
> (0x00007fd59d60f000)<br>
> libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3<br>
> (0x00007fd59d3a2000)<br>
> libgraphite2.so.3 => /usr/lib/x86_64-linux-gnu/libgraphite2.so.3<br>
> (0x00007fd59d186000)<br>
> libexpat.so.1 => /lib/x86_64-linux-gnu/libexpat.so.1<br>
> (0x00007fd59cf5d000)<br>
> libglapi.so.0 => /usr/lib/x86_64-linux-gnu/libglapi.so.0<br>
> (0x00007fd59cd2f000)<br>
> libXdamage.so.1 => /usr/lib/x86_64-linux-gnu/libXdamage.so.1<br>
> (0x00007fd59cb2c000)<br>
> libXfixes.so.3 => /usr/lib/x86_64-linux-gnu/libXfixes.so.3<br>
> (0x00007fd59c926000)<br>
> libX11-xcb.so.1 => /usr/lib/x86_64-linux-gnu/libX11-xcb.so.1<br>
> (0x00007fd59c724000)<br>
> libxcb-glx.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-glx.so.0<br>
> (0x00007fd59c50b000)<br>
> libxcb-dri2.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-dri2.so.0<br>
> (0x00007fd59c306000)<br>
> libxcb-dri3.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-dri3.so.0<br>
> (0x00007fd59c103000)<br>
> libxcb-present.so.0 =><br>
> /usr/lib/x86_64-linux-gnu/libxcb-present.so.0<br>
> (0x00007fd59bf00000)<br>
> libxcb-sync.so.1 => /usr/lib/x86_64-linux-gnu/libxcb-sync.so.1<br>
> (0x00007fd59bcf9000)<br>
> libxshmfence.so.1 => /usr/lib/x86_64-linux-gnu/libxshmfence.so.1<br>
> (0x00007fd59baf6000)<br>
> libXxf86vm.so.1 => /usr/lib/x86_64-linux-gnu/libXxf86vm.so.1<br>
> (0x00007fd59b8f0000)<br>
> libdrm.so.2 => /usr/lib/x86_64-linux-gnu/libdrm.so.2<br>
> (0x00007fd59b6e2000)<br>
> libicudata.so.55 => /usr/lib/x86_64-linux-gnu/libicudata.so.55<br>
> (0x00007fd599c2b000)<br>
> libsystemd.so.0 => /lib/x86_64-linux-gnu/libsystemd.so.0<br>
> (0x00007fd599baa000)<br>
> libXt.so.6 => /usr/lib/x86_64-linux-gnu/libXt.so.6<br>
> (0x00007fd599941000)<br>
> libuuid.so.1 => /lib/x86_64-linux-gnu/libuuid.so.1<br>
> (0x00007fd59973c000)<br>
> liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5<br>
> (0x00007fd59951a000)<br>
> libgcrypt.so.20 => /lib/x86_64-linux-gnu/libgcrypt.so.20<br>
> (0x00007fd599238000)<br>
> libgpg-error.so.0 => /lib/x86_64-linux-gnu/libgpg-error.so.0<br>
> (0x00007fd599025000)<br>
><br>
><br>
><br>
> ><br>
> > Gilles Caulier<br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Digikam-devel mailing list<br>
</div></div>> > <a href="mailto:Digikam-devel@kde.org">Digikam-devel@kde.org</a> <mailto:<a href="mailto:Digikam-devel@kde.org">Digikam-devel@kde.org</a>><br>
<span class="">> > <a href="https://mail.kde.org/mailman/listinfo/digikam-devel" rel="noreferrer" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-devel</a><br>
> ><br>
> _______________________________________________<br>
> Digikam-devel mailing list<br>
</span>> <a href="mailto:Digikam-devel@kde.org">Digikam-devel@kde.org</a> <mailto:<a href="mailto:Digikam-devel@kde.org">Digikam-devel@kde.org</a>><br>
<div class="HOEnZb"><div class="h5">> <a href="https://mail.kde.org/mailman/listinfo/digikam-devel" rel="noreferrer" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-devel</a><br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Digikam-devel mailing list<br>
> <a href="mailto:Digikam-devel@kde.org">Digikam-devel@kde.org</a><br>
> <a href="https://mail.kde.org/mailman/listinfo/digikam-devel" rel="noreferrer" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-devel</a><br>
><br>
_______________________________________________<br>
Digikam-devel mailing list<br>
<a href="mailto:Digikam-devel@kde.org">Digikam-devel@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/digikam-devel" rel="noreferrer" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-devel</a><br>
</div></div></blockquote></div><br></div>