This forum has been archived. All content is frozen. Please use KDE Discuss instead.

postgresql driver has gone awol

Tags: None
(comma "," separated)
User avatar
inksi
Registered Member
Posts
77
Karma
0
OS

postgresql driver has gone awol

Tue Aug 19, 2014 8:59 am
Hi. Jaroslaw.

I did a new build last night late after a 'git pull' and all seemed ok. Kexi started up.

BUT 1. All projects have disappeared from the Welcome screen. They are still in
~/inksi/.kde/share/apps/kexi/recent_projects/ but do not show on the screen for click selection.

BUT 2. If I click on Open/Projects Stored On Database Server - then a warning notice arrives telling me "No Database Server Drivers Found".
well, i did have them, particularly the postgresql driver. If i download that via my package manager I will get the old kexi installed as well. I could be cleverer, but then it might not be installed in the correct place and is likely to be an older version (with the double quotes ' -> "" bug as well).

BUT 3. Even the .kexi sqlite database under Projects Stored In File is not recognised as a database.

Before I break this further, please advise.

Ian
User avatar
inksi
Registered Member
Posts
77
Karma
0
OS

Re: postgresql driver has gone awol

Tue Aug 19, 2014 9:02 am
Addendum.

As regards BUT 1, they are not all in the recent_projects directory, some have definitely disappeared from there. Only 2 remain of maybe half a dozen.

Ian
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: postgresql driver has gone awol

Wed Aug 20, 2014 11:23 am
When compiling your own version of Kexi, it is possible necessary dependencies are missing from your system.
Could you please post the output CMake generates when configuring Kexi to be built?


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
inksi
Registered Member
Posts
77
Karma
0
OS

Re: postgresql driver has gone awol

Wed Aug 20, 2014 1:46 pm
Hello, bcooksley

here is the output as requested. hope use of code tag is appropriate.

Code: Select all
inksi@pandora ~/kde4/build/calligra $  cmake -DCMAKE_INSTALL_PREFIX=$HOME/kde4/inst $HOME/kde4/src/calligra -DPRODUCTSET=KEXI+SHEETS -DCMAKE_BUILD_TYPE=DebugFull -DIHAVEPATCHEDQT=true
-- Release build: FALSE
-- --------------------------------------------------------------------------
-- Configured with product set "KEXI+SHEETS"
-- --------------------------------------------------------------------------
-- Found Qt-Version 4.8.1 (using /usr/bin/qmake)
-- Found X11: /usr/lib/i386-linux-gnu/libX11.so
-- Adding /home/inksi/kde4/inst/share/apps/cmake/modules to CMAKE_MODULE_PATH
-- Found KDE 4.8 include dir: /usr/include
-- Found KDE 4.8 library dir: /usr/lib
-- Found the KDE4 kconfig_compiler preprocessor: /usr/bin/kconfig_compiler
-- Found automoc4: /usr/bin/automoc4
-- Found Qt-Version 4.8.1 (using /usr/bin/qmake)
-- Found X11: /usr/lib/i386-linux-gnu/libX11.so
CMake Error at /usr/share/kde4/apps/cmake/modules/MacroEnsureOutOfSourceBuild.cmake:17 (MESSAGE):
  Compiling Calligra inside the source directory is not possible.  Please
  refer to the build instruction
  http://community.kde.org/Calligra/Building/Building_Calligra
Call Stack (most recent call first):
  CMakeLists.txt:311 (macro_ensure_out_of_source_build)


-- Configuring incomplete, errors occurred!
inksi@pandora ~/kde4/build/calligra $


I am not in the source directory as stated and as you can see. But I cannot rule out the fact that this may have occured earlier in error.

regards
Ian
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS

Re: postgresql driver has gone awol

Wed Aug 20, 2014 10:35 pm
@Ian in the top source code directory please type:
Code: Select all
git clean -df
(Removes any files that do not belong to the repository, https://www.kernel.org/pub/software/scm ... clean.html)


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: postgresql driver has gone awol

Thu Aug 21, 2014 7:46 am
The use of the code tags was perfect. Please clean your checkout and then perform an out-of-source configuration as recommended, then post the output again.


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
inksi
Registered Member
Posts
77
Karma
0
OS

Re: postgresql driver has gone awol

Thu Aug 21, 2014 8:15 am
Hi there.

I did the following.

Code: Select all
inksi@pandora ~/kde4/src/calligra $ git clean -df

inksi@pandora ~/kde4/src/calligra $ git pull

inksi@pandora ~/kde4/build/calligra $  cmake -DCMAKE_INSTALL_PREFIX=$HOME/kde4/inst $HOME/kde4/src/calligra -DPRODUCTSET=KEXI+SHEETS -DCMAKE_BUILD_TYPE=DebugFull -DIHAVEPATCHEDQT=true

inksi@pandora ~/kde4/build/calligra $  make install


This runs with the final line (following many similar)

Code: Select all
-- Up-to-date: /home/inksi/kde4/inst/share/apps/calligra/palettes/web.gpl


But the situation is unchanged from earlier. Even the .kexi database file is unrecognised.

Maybe we are going to have to do a fresh install/build from scratch? :(

Ian
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: postgresql driver has gone awol

Thu Aug 21, 2014 8:58 am
It is the log output by CMake itself that is particularly interesting here - it is likely certain dependencies are not installed on your system which may be crucial to Postgres/SQLite support.


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
inksi
Registered Member
Posts
77
Karma
0
OS

Re: postgresql driver has gone awol

Thu Aug 21, 2014 3:14 pm
Hi,

I am checking through all kde dependencies as I write.

All seem good, but I note the following

kdelibs5 are there except -dbg which is suprising. Should I install that?

if I run 'apt-get build-dep kdelibs5' then it selects kdelibs4 with the message below, so I did not answer 'yes'

Code: Select all
Picking 'kde4libs' as source package instead of 'kdelibs5'
The following NEW packages will be installed:
  hspell libacl1-dev libattr1-dev libdbusmenu-qt-dev libdlrestrictions-dev
  libenchant-dev libgrantlee-core0 libgrantlee-dev libgrantlee-gui0
  libjasper-dev liblzma-dev libpolkit-qt-1-dev libstreamanalyzer-dev
  libstreams-dev libudev-dev libutempter-dev libxss-dev x11proto-scrnsaver-dev
The following packages will be upgraded:
  libudev0



sqlite has a large selection of packages installed but for postgresql, there is nothing installed on this machine from the package manager - and which will install the full package kexi if I try to install just the kexi-postgresql-driver.

Did not the postgresql driver not come with my original master installation? I find no files named 'postgres' in the ~/kde4 directory

Ian
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS

Re: postgresql driver has gone awol

Thu Aug 21, 2014 4:57 pm
inksi wrote:Did not the postgresql driver not come with my original master installation? I find no files named 'postgres' in the ~/kde4 directory

The name should rather contain pqxx.

Possible issue with non-clean rebuilds come from the fact that plugins/drivers in Kexi changed some underlying way of loading.
I recommend a clean rebuild, that is:
Code: Select all
rm -rf $HOME/kde4/build/calligra
mkdir -p $HOME/kde4/build/calligra

Then, proceed with the usual build instructions: https://community.kde.org/Calligra/Buil ... d_Calligra.
PS: You may need to recall all the options you picked for cmake.
PS2: Do not forget 'make instal'.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar
inksi
Registered Member
Posts
77
Karma
0
OS

Re: postgresql driver has gone awol

Thu Aug 21, 2014 8:50 pm
jstaniek, hi.

short story. still not running. long story follows:

I followed that carefully, removed and recreated appropriate directories
did cmake
did make install
followed the instructions in 'Running from the command line". ie
sourced my .profile beause all the export lines are still there :<
made the tmp directories
$ kbuildsycoca4

right, we are all done there.

Where we are at now is that kexi starts. The 'Welcome' shows no existing items to choose from.
If I go to the 'Open Projects' page it hangs with the 'egg timer' revolving non-stop.
Thus i am unable to look for file or server database, exit, or choose another menu item
If I leave that for another screen, then all is blank when I return and I have to force a close.

So I do a fresh git pull, and work through the process again. We are back where I was at the beginning of this thread. The .kexi file unrecognised, no postgresql driver, and on top of this the app proceeds at slower than snail speed. Many minutes for anything to happen.

Then I spot the 'Calligra 2,8' logo! This was from way back. Checking, the directory structure
kde4/build/calligra
kde4/build/calligra-2.8
- both exist.

So in effect the only the /calligra directory was deleted. But definitely a clean build (over 1 hour of it) and I have not been in the 2.8 branch. I don't know how it picks up 2.8, must be something somewhere. ???

Unless any advice to the contrary i wll delete both of these directories and make another build this weekend.
Looking at Calligra/Building#Working_with_multiple_versions and note that this needs updating. 2.9 is master, right?

Yo!! TGIF tomorrow

Ian
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS

Re: postgresql driver has gone awol

Fri Aug 22, 2014 1:03 pm
You can type "git branch" to see if you're on master branch. To change to master: "git checkout master".

To be sure, have you set environment variables before you run cmake and "make install"? Details:
https://community.kde.org/Calligra/Buil ... mmand_Line

PS: Recommended speedup: add -j5 option right after 'make' (for 4 CPU cores)


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar
inksi
Registered Member
Posts
77
Karma
0
OS

Re: postgresql driver has gone awol

Fri Aug 22, 2014 7:56 pm
Hi, Jaroslaw,

Right! There we go, the latest installed and up and running. Build time 1h 20m

All your git command line options saved for future reference.

How we got here I do not know, but I will be certain to run the cmake/make/install commands from the correct directory next time, that could have been the source of these errors?

I should have been smarter. Not upgraded is the shop m/c, and we had a hiccup with the kexi+sheets option there that did not occur on this laptop when upgrading. Should have been a pointer to an older install.

Ian
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: postgresql driver has gone awol

Sat Aug 23, 2014 12:15 am
In regards to diagnosing why the Postgres driver isn't being built, please post the output from CMake so we can examine it. As Jaroslaw mentioned, you are probably missing the appropriate libpq* development package. It is not necessary to install the build dependencies for kdelibs5 in order to build Calligra/Kexi.


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
inksi
Registered Member
Posts
77
Karma
0
OS

Re: postgresql driver has gone awol

Sat Aug 23, 2014 12:53 pm
Hello, bc.

Cannot post that now, too late. But, using Mint, I did now update prior to the new build according to the information in Calliga/Building#Debian using:

Code: Select all
$ sudo apt-get install libeigen3-dev libxi-dev phonon-backend-gstreamer kdelibs5-dev libboost-dev exiv2


and then many packages were updated.

In respect of that I note that then running cmake still generated an error for non-appearance of 'boost'. This on two distinct machines updated within a day of one another.
Installing libboost-system-dev cured this message and then the build went successfully ahead.

Next new builds will all be preceded by a full system update.

Build time 32min on older 2-core amd machine
The build on the Pentium M based laptop took an hour and a half.
maybe I should try gold linker, would this speed it up much?

Ian


Bookmarks



Who is online

Registered users: bancha, Bing [Bot], Evergrowing, Google [Bot], lockheed, mesutakcan, sandyvee, Sogou [Bot]