Hi all,
Because I needed to build a working database for my work, with actual research data (water parameters such as pH and salinity and such...), I tried using LibreOffice Base for a while, because of previous experience with MS Access. This was a mistake and a waste of time: Base does not (repeat: not) live up to any simple database expectations. Short story: I switched to MySQL, that was yesterday. I still need to learn a lot, but here goes... In order to use the MySQL Workbench, I needed to install MySQL server. I did just that, including dependencies, using Apper. Most of the apps were installed successfully, except mysql server 5.1. After a search through some fora, it was considered wise to attempt installing in a terminal (sudo apt-get install -f)... Things were indeed a bit more powerful here. I actually succeeded in installing some of the other mysql packages here, victory ! However, some of the command lines I found were meant to clean up things in case of faulty installs. I am afraid that in cleaning up some half-installed packages, I also deleted some files that are needed by Akonadi. After a reboot, Kontact/Kmail could not start up anymore, because of a fail of Akonadi and Akonadi-related apps. In the meantime, I use Thunderbird to receive/sent mail. I made a capital mistake and feel quite stupid about it...can anyone help me to recover this ? I'm a bit at a loss about where to start...
Specifications: Kubuntu 11.10, KDE 4.7.4.
Akonadi Server Self Test gives the following errors:
- Database driver not found
- Akonadi control process not registered at D-bus
- Akonadi server process not registered at D-bus
- No resource agents found
- Current Akonadi server error log found
- Previous Akonadi server error log found
When in the terminal (Konsole), I type:
sudo akonadictl start
I get:
Starting Akonadi Server...
done.
francescm@FMT-CEME-laptop:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/X11R6/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 156
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6eaed38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb777e0c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6eaec8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6eb22b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x136) [0xb75274a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb75278db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb75279f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb7527a85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x80e414b]
12: akonadiserver() [0x805c66f]
13: akonadiserver() [0x805de02]
14: akonadiserver() [0x805f516]
15: akonadiserver() [0x8055900]
16: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6e9a113]
17: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/X11R6/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 156
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6fbcd38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb788c0c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6fbcc8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6fc02b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x136) [0xb76354a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb76358db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb76359f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb7635a85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x80e414b]
12: akonadiserver() [0x805c66f]
13: akonadiserver() [0x805de02]
14: akonadiserver() [0x805f516]
15: akonadiserver() [0x8055900]
16: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6fa8113]
17: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/X11R6/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 156
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6f24d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb77f40c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6f24c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6f282b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x136) [0xb759d4a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb759d8db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb759d9f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb759da85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x80e414b]
12: akonadiserver() [0x805c66f]
13: akonadiserver() [0x805de02]
14: akonadiserver() [0x805f516]
15: akonadiserver() [0x8055900]
16: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6f10113]
17: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/X11R6/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 156
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb700ad38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb78da0c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb700ac8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb700e2b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x136) [0xb76834a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb76838db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb76839f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb7683a85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x80e414b]
12: akonadiserver() [0x805c66f]
13: akonadiserver() [0x805de02]
14: akonadiserver() [0x805f516]
15: akonadiserver() [0x8055900]
16: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6ff6113]
17: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
Thanks in advance for your help !
Because I needed to build a working database for my work, with actual research data (water parameters such as pH and salinity and such...), I tried using LibreOffice Base for a while, because of previous experience with MS Access. This was a mistake and a waste of time: Base does not (repeat: not) live up to any simple database expectations. Short story: I switched to MySQL, that was yesterday. I still need to learn a lot, but here goes... In order to use the MySQL Workbench, I needed to install MySQL server. I did just that, including dependencies, using Apper. Most of the apps were installed successfully, except mysql server 5.1. After a search through some fora, it was considered wise to attempt installing in a terminal (sudo apt-get install -f)... Things were indeed a bit more powerful here. I actually succeeded in installing some of the other mysql packages here, victory ! However, some of the command lines I found were meant to clean up things in case of faulty installs. I am afraid that in cleaning up some half-installed packages, I also deleted some files that are needed by Akonadi. After a reboot, Kontact/Kmail could not start up anymore, because of a fail of Akonadi and Akonadi-related apps. In the meantime, I use Thunderbird to receive/sent mail. I made a capital mistake and feel quite stupid about it...can anyone help me to recover this ? I'm a bit at a loss about where to start...
Specifications: Kubuntu 11.10, KDE 4.7.4.
Akonadi Server Self Test gives the following errors:
- Database driver not found
- Akonadi control process not registered at D-bus
- Akonadi server process not registered at D-bus
- No resource agents found
- Current Akonadi server error log found
- Previous Akonadi server error log found
When in the terminal (Konsole), I type:
sudo akonadictl start
I get:
Starting Akonadi Server...
done.
francescm@FMT-CEME-laptop:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/X11R6/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 156
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6eaed38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb777e0c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6eaec8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6eb22b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x136) [0xb75274a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb75278db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb75279f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb7527a85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x80e414b]
12: akonadiserver() [0x805c66f]
13: akonadiserver() [0x805de02]
14: akonadiserver() [0x805f516]
15: akonadiserver() [0x8055900]
16: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6e9a113]
17: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/X11R6/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 156
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6fbcd38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb788c0c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6fbcc8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6fc02b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x136) [0xb76354a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb76358db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb76359f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb7635a85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x80e414b]
12: akonadiserver() [0x805c66f]
13: akonadiserver() [0x805de02]
14: akonadiserver() [0x805f516]
15: akonadiserver() [0x8055900]
16: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6fa8113]
17: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/X11R6/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 156
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6f24d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb77f40c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6f24c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6f282b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x136) [0xb759d4a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb759d8db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb759d9f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb759da85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x80e414b]
12: akonadiserver() [0x805c66f]
13: akonadiserver() [0x805de02]
14: akonadiserver() [0x805f516]
15: akonadiserver() [0x8055900]
16: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6f10113]
17: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/X11R6/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 156
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb700ad38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb78da0c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb700ac8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb700e2b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x136) [0xb76834a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb76838db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb76839f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb7683a85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x80e414b]
12: akonadiserver() [0x805c66f]
13: akonadiserver() [0x805de02]
14: akonadiserver() [0x805f516]
15: akonadiserver() [0x8055900]
16: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6ff6113]
17: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
Thanks in advance for your help !
Comment