QSqlDatabasePrivate::database: unable to open database

[johnmerlino]

I'm getting the following error when trying to run a qt project:

QSqlDatabasePrivate::database: unable to open database: "could not connect to server: Permission denied
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

Now I was also getting this error when trying to log into postgresql but I resolved that issue using this post:

http://stackoverflow.com/questions/6770649/repairing-postgresql-after-upgrading-to-osx-10-7-lion

Once I added export PATH=/usr/local/bin:$PATH
to the end of my .bash_profile on my mac lion, then I was able to log into postgresql:

unknown045453009c92:.XKGateway johnmerlino$ psql -d db_development -U johnmerlino
psql (9.1.2)
Type "help" for help.

xkdb_development=#

However, even after that, still when I try to run the qt project, I get the error message and the database.json file it references contains the right database and username.

[mbnoimi]

I think you've to call "QSqlDatabase":https://qt-project.org/doc/qt-5.0/qtsql/qsqldatabase.html instead of QSqlDatabasePrivate

[raven-worx]

make sure you have execute permissions on the following folders:

• /var
• /var/pgsql_socket

A quick look up in the internet stated that you may also have to update your postgresql.conf and uncomment a line there to set the file permissions to 0777.