[Bug 299232] New: Akonadi postgresql backends does not seem to use Host config option but tries to connect locally instead

Martin Steigerwald ms at teamix.de
Wed May 2 12:12:59 BST 2012 

https://bugs.kde.org/show_bug.cgi?id=299232

            Bug ID: 299232
          Severity: normal
           Version: unspecified
          Priority: NOR
          Assignee: kdepim-bugs at kde.org
           Summary: Akonadi postgresql backends does not seem to use Host
                    config option but tries to connect locally instead
    Classification: Unclassified
                OS: Linux
          Reporter: ms at teamix.de
          Hardware: Debian testing
            Status: UNCONFIRMED
         Component: general
           Product: Akonadi

When I configure Akonadi to use an external PostgreSQL server it tries to
connect to localhost and fails.

Reproducible: Always

Steps to Reproduce:
1. Configure externel PostgreSQL server with user and database.

postgres at somedbhost:~$ createuser --pwprompt akonadimartinsteigerwald
Enter password for new role: 
Enter it again: 
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
postgres at somedbhost:~$ createdb akonadimartinsteigerwald -O
akonadimartinsteigerwald


2. Configure Akonadi to use external database

ms at mango:~/.config/akonadi> cat akonadiserverrc
[%General]
Driver=QPSQL

[QPSQL]
Name=akonadimartinsteigerwald
Host=somedbhost.somedomain
User=akonadimartinsteigerwald
Password=[…]
StartServer=false
Options=

[Debug]
Tracer=null

3. akonadictl start
Actual Results:  
And I get - where 1.2.3.4 is the (changed) IP address of the localhost.

ms at mango:~/.config/akonadi#4> akonadictl start
Starting Akonadi Server...
   done.
ms at mango:~/.config/akonadi> Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Failed to use database "akonadimartinsteigerwald" 
Database error: "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
QPSQL: Unable to connect" 
Trying to create database now... 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in
use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QPSQL: Unable to connect"
Last database error: "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
"
Unable to open database "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x805ba75]
1: akonadiserver() [0x805be2f]
2: [0xb7732400]
3: [0xb7732424]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x51) [0xb6e68941]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x182) [0xb6e6bd72]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136)
[0xb74c9506]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
Failed to use database "akonadimartinsteigerwald" 
Database error: "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
QPSQL: Unable to connect" 
Trying to create database now... 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in
use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QPSQL: Unable to connect"
Last database error: "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
"
Unable to open database "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x805ba75]
1: akonadiserver() [0x805be2f]
2: [0xb76ec400]
3: [0xb76ec424]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x51) [0xb6e22941]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x182) [0xb6e25d72]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136)
[0xb7483506]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
Failed to use database "akonadimartinsteigerwald" 
Database error: "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
QPSQL: Unable to connect" 
Trying to create database now... 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in
use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QPSQL: Unable to connect"
Last database error: "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
"
Unable to open database "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x805ba75]
1: akonadiserver() [0x805be2f]
2: [0xb76ea400]
3: [0xb76ea424]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x51) [0xb6e20941]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x182) [0xb6e23d72]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136)
[0xb7481506]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
Failed to use database "akonadimartinsteigerwald" 
Database error: "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
QPSQL: Unable to connect" 
Trying to create database now... 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in
use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QPSQL: Unable to connect"
Last database error: "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
"
Unable to open database "FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL on
FATAL:  no pg_hba.conf entry for host "1.2.3.4", user
"akonadimartinsteigerwald", database "akonadimartinsteigerwald", SSL off
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x805ba75]
1: akonadiserver() [0x805be2f]
2: [0xb77ca400]
3: [0xb77ca424]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x51) [0xb6f00941]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x182) [0xb6f03d72]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136)
[0xb7561506]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
"akonadiserver" crashed too often and will not be restarted! 

Expected Results:  
Akonadi PostgreSQL backends tries to connect to our db host either successfully
or it fails and tells me why.

Akonadi on client - KDE is at KDE SC 4.7.4 except for KDEPIM which is still
4.4.5:

ms at mango:~> apt-show-versions | egrep "akonadi"             
akonadi-backend-mysql/wheezy uptodate 1.6.2-2
akonadi-backend-postgresql/wheezy uptodate 1.6.2-2
akonadi-backend-sqlite/wheezy uptodate 1.6.2-2+b1
akonadi-server/wheezy uptodate 1.6.2-2+b1
akonadiconsole/wheezy uptodate 4:4.4.11.1+l10n-1
[…]
libakonadiprotocolinternals1/wheezy uptodate 1.6.2-2+b1


On the server:

somedbserver:~# dpkg -l | grep postgresql | cut -c1-65
ii  postgresql-8.4                      8.4.10-0squeeze1         
ii  postgresql-client-8.4               8.4.10-0squeeze1         
ii  postgresql-client-common            113                      
ii  postgresql-common                   113

-- 
You are receiving this mail because:
You are the assignee for the bug.

More information about the Kdepim-bugs mailing list