[Digikam-devel] Building on Ubuntu Wily (was Re: [Digikam-users] Mysql/MariaDb database expert needs...)
Richard Mortimer
richm+digikam at oldelvet.org.uk
Tue Nov 24 11:23:54 GMT 2015
On 24/11/2015 10:02, Gilles Caulier wrote:
> 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.
>
https://bugs.kde.org/show_bug.cgi?id=355831
> Thanks in advance for your work.
More importantly thanks for all your work on Digikam!
Regards
Richard
>
> Gilles Caulier
>
> 2015-11-24 10:24 GMT+01:00 Richard Mortimer
> <richm+digikam at oldelvet.org.uk <mailto: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%2Bdigikam at oldelvet.org.uk>
> <mailto:richm+digikam at oldelvet.org.uk
> <mailto:richm%2Bdigikam 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%2Bdigikam at oldelvet.org.uk
> <mailto:richm%252Bdigikam at oldelvet.org.uk>>
> > <mailto:richm+digikam at oldelvet.org.uk
> <mailto:richm%2Bdigikam at oldelvet.org.uk>
> > <mailto:richm%2Bdigikam at oldelvet.org.uk
> <mailto:richm%252Bdigikam 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>
> <mailto: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>
> <mailto: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 <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
>
More information about the Digikam-devel
mailing list