QSqlDatabase:QPSQL Driver not loaded Driver not loaded

jsulm

@ram070787 My guess is that PostgreSQL client library is missing. ldd will not help here as Qt uses dlopen() to load it, it does not link against it.

ram070787

@jsulm Will "sudo apt-get install postgresql-client" install client libraries to my computer for Postgresql? If yes I have already installed these files in my computer.

jsulm

@ram070787 I don't know how Debian/Ubuntu packages this stuff. You can search for them on your system, not sure which one is used by Qt (the C or C++ one, see https://wiki.postgresql.org/wiki/Client_Libraries).

ram070787

@jsulm I checked with another computer for the installed libraries regarding Postgresql. We both have same libraries installed (libpq5.so and other Postgresql librraies. ) It works will with him but not with me. And i think libpqxx packages are used by C++, so it may be used by Qt also.

SGaist

Hi and welcome to devnet,

Did you install PostgreSQL development packages for your distribution ?

ram070787

@SGaist Yes I have installed "postgresql-dev" on my computer. Also this error below..
QSqlDatabase: unknown driver not loaded

QSqlDatabase: available drivers: QSQLITE QPSQL QPSQL7

"\uFFFF:Driver not loaded Driver not loaded"

I was able to recreate this error in another machine when I removed libqsqlpsql.so from the sqldriver folder in the Qt installtion and the error looked like

QSqlDatabase: QPSQL driver not loaded

QSqlDatabase: available drivers: QSQLITE QPSQL QPSQL7

"\uFFFF:Driver not loaded Driver not loaded"

I can understand this error. But mine shows "unknown".

ram070787

I am working on codes written by other persons and have no idea how they did this . It seems to me that QSqldatabase is looking for "unknown driver" and is not able to load it. Is there any reason that this can happen?

ram070787

@SGaist These are my postgres packages installed

postgresql/xenial-updates,xenial-updates,xenial-security,xenial- security,now 9.5+173ubuntu0.1 all [installed]
postgresql-9.5/xenial-updates,xenial-security,now 9.5.12-0ubuntu0.16.04 amd64 [installed,automatic]
postgresql-client-9.5/xenial-updates,xenial-security,now 9.5.12-0ubuntu0.16.04 amd64 [installed]
postgresql-client-common/xenial-updates,xenial-updates,xenial-security,xenial-security,now 173ubuntu0.1 all [installed]
postgresql-common/xenial-updates,xenial-updates,xenial-security,xenial-security,now 173ubuntu0.1 all [installed,automatic]
postgresql-contrib-9.5/xenial-updates,xenial-security,now 9.5.12-0ubuntu0.16.04 amd64 [installed,automatic]

I also have installed libpq5 and libpq-dev on my computer.

jsulm

@ram070787 What about libpqxx-dev ?

SGaist

There's something mighty fishy here.

Did you install of Qt's development packages from your distribution ?
What do you get if you run ldd on the PostgreSQL plugin ?

ram070787

@SGaist If I am right by Qt development package you mean the qtdeclarative5-dev packages. I had those installed.

I did not understand where this PostgreSQL plugin is? A "ldd psql" had all the dependencies.

ram070787

@jsulm Yeah those were installed.

ram070787

I already spent a week trying to find the error and unsuccessful. so I have reinstalled my complete system. I will try to install all essential libraries and softwares and will come back here again. Thanks everyone for your help.

ram070787

Hi guys. I have found the reason for this. But not sure what to do about this. Maybe you guys are experienced in this.

My application runs by reading an .ini file in the folder "etc/myfile.ini" and automatically generates the same myfile.ini in my home folder with some details about my login credentials to the application that is built by Qt. The first run in my Qt opens my application and an .ini file is generated in my home folder. When I stop my application and restart it is gives "unknown driver error". So this .ini file is not generated again afresh. I have to delete the old .ini file in my home folder before running my application again.

Also my application gets a connection with the Sql database and the details about the database are written in the .ini file generated in my home folder. These details are written in another computer and not in mine.

ram070787

Hi guys.. I found the reason for my failure in driver. It was a error within the project itself. The error seems a bit wierd initially but reinstalling showed me more about the error. The .ini file generation was having some problem and now I fixed it and it is all fine.. Thanks a lot for everyone..

SGaist

Glad you found out and thanks for sharing !

Would you mind sharing what is in this ini file that wreaks such havoc in your application ?

ram070787

@SGaist I am really sorry I cant share this .ini file with you.

But this .ini file has the database details (which driver should be used), server details that the application should connect to. I manually edited this file and made sure all the required paths are set and i was able to start my application in Qt and establish a connection to my database.

SGaist

Thanks for the information !

Since you have it working now, please mark the thread as solved using the "Topic Tools" button so that other forum users may know a solution has been found :)

monfortpie

Very curious the idea of a specific file ".ini" . I did'nt found a such file ".ini" in my project ....Bizarre....

SGaist

Hi and welcome to devnet,

@monfortpie said in QSqlDatabase:QPSQL Driver not loaded Driver not loaded:

Very curious the idea of a specific file ".ini" . I did'nt found a such file ".ini" in my project ....Bizarre....

Because it's specific to how @ram070787 implemented its application, not something that is general.