[Digikam-devel] Building on Ubuntu Wily (was Re: [Digikam-users] Mysql/MariaDb database expert needs...)

Gilles Caulier caulier.gilles at gmail.com
Tue Nov 24 10:02:50 GMT 2015


I see you post on ML about your MySQL patches, but, your patches are not
visible as attachements.

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.

Thanks in advance for your work.

Gilles Caulier

2015-11-24 10:24 GMT+01:00 Richard Mortimer <richm+digikam at oldelvet.org.uk>:

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


More information about the Digikam-devel mailing list