LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-10-2012, 09:10 AM   #1
Nederjaard
LQ Newbie
 
Registered: Feb 2012
Location: Yerseke, The Netherlands
Distribution: Kubuntu 12.10
Posts: 17

Rep: Reputation: Disabled
Accidentally destroyed some MySQL files used by Akonadi (and thus by dependencies)


Hi all,

I hope I posted this correctly here...I'm quite new to Linux, using Kubuntu from the first day I started my new job. Couldn't be happier, although there are some bumps in the road.

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:

Code:
sudo akonadictl start
I get:

Code:
Starting Akonadi Server...
   done.
francescm@FMT-CEME-laptop:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,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 !
 
Old 02-10-2012, 09:24 AM   #2
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
Let's check what's installed first. Could you please post the results of:
Quote:
dpkg -l | egrep 'mysql|akonadi|kdepim'

Last edited by klearview; 02-10-2012 at 09:27 AM. Reason: sorry, expanded command tp do it in one go
 
Old 02-10-2012, 09:44 AM   #3
Nederjaard
LQ Newbie
 
Registered: Feb 2012
Location: Yerseke, The Netherlands
Distribution: Kubuntu 12.10
Posts: 17

Original Poster
Rep: Reputation: Disabled
Wow ! Thanks a bunch for replying so fast, klearview. As for your question, here goes:
Code:
rc  akonadi-backend-mysql                 1.6.2-0ubuntu1                             MySQL storage backend for Akonadi
ii  akonadi-backend-sqlite                1.6.2-0ubuntu1                             SQLite storage backend for Akonadi
ii  akonadi-server                        1.6.2-0ubuntu1                             Akonadi PIM storage service
ii  kdepim-dbg                            4:4.7.4+git111222-0ubuntu0.1               debugging symbols for kdepim
ii  kdepim-groupware                      4:4.7.4+git111222-0ubuntu0.1               KDE PIM Groupware plugins
ii  kdepim-kresources                     4:4.7.4+git111222-0ubuntu0.1               KDE PIM resource plugins
ii  kdepim-runtime                        4:4.7.4-0ubuntu0.1                         Runtime components for akonadi-kde
ii  kdepim-strigi-plugins                 4:4.7.4+git111222-0ubuntu0.1               PIM file format plugins for Strigi Desktop Search
ii  kdepim-wizards                        4:4.7.4+git111222-0ubuntu0.1               KDE server configuration wizards
ii  kdepimlibs-dbg                        4:4.7.4-0ubuntu0.1                         debugging symbols for the KDE Development Platform PIM libraries
ii  kdepimlibs-kio-plugins                4:4.7.4-0ubuntu0.1                         kio slaves used by KDE PIM applications
ii  libakonadi-calendar4                  4:4.7.4-0ubuntu0.1                         library providing calendar helpers for Akonadi items
ii  libakonadi-contact4                   4:4.7.4-0ubuntu0.1                         library for using the Akonadi PIM data server
ii  libakonadi-kabc4                      4:4.7.4-0ubuntu0.1                         library for using the Akonadi PIM data server
ii  libakonadi-kcal4                      4:4.7.4-0ubuntu0.1                         library for using the Akonadi PIM data server
ii  libakonadi-kde4                       4:4.7.4-0ubuntu0.1                         library for using the Akonadi PIM data server
ii  libakonadi-kmime4                     4:4.7.4-0ubuntu0.1                         library for using the Akonadi PIM data server
ii  libakonadiprotocolinternals1          1.6.2-0ubuntu1                             libraries for the Akonadi PIM storage service
ii  libdbd-mysql-perl                     4.019-1                                    Perl5 database interface to the MySQL database
ii  libkdepim4                            4:4.7.4+git111222-0ubuntu0.1               KDE PIM library
ii  libkdepimdbusinterfaces4              4:4.7.4+git111222-0ubuntu0.1               kde pim dbusinterface libary
ii  libmysqlclient16                      5.1.58-1ubuntu1                            MySQL database client library
ii  mysql-client-5.1                      5.1.58-1ubuntu1                            MySQL database client binaries
ii  mysql-client-core-5.1                 5.1.58-1ubuntu1                            MySQL database core client binaries
rc  mysql-cluster-client-5.1              7.1.9a-0ubuntu2                            MySQL database client binaries
rc  mysql-cluster-server-5.1              7.1.9a-0ubuntu2                            MySQL database server binaries
ii  mysql-common                          5.1.58-1ubuntu1                            MySQL database common files, e.g. /etc/mysql/my.cnf
ii  mysql-server                          5.1.58-1ubuntu1                            MySQL database server (metapackage depending on the latest version)
ii  mysql-server-5.1                      5.1.58-1ubuntu1                            MySQL database server binaries and system database setup
ii  mysql-server-core-5.1                 5.1.58-1ubuntu1                            MySQL database server binaries
Awaiting your advice...
 
Old 02-10-2012, 09:57 AM   #4
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
Run:
Quote:
mysql -u root -p
Enter your mysql root password and you'll get taken to mysql shell; then enter:
Quote:
create database akonadi;
grant SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES on akonadi.* to 'akonadi'@'localhost' identified by 'akonadi';
flush privileges;
quit;
Now run:
Quote:
kcmshell4 kcm_akonadi
Akonadi Configuration window will open. Go to 'Akonadi Server Configuration' tab;
there untick 'Use internal MySQL server' and in 'External MySQL server' section enter the details of your database: db name - akonadi, host - localhost, user - akonadi, pass - akonadi;
make sure that 'Database driver' dropdown at the top is set to 'MySQL';
press 'Apply' at the bottom;
press 'Start' (or 'Restart').
Should be OK now.

Post the result.

Last edited by klearview; 02-10-2012 at 09:58 AM.
 
Old 02-10-2012, 10:01 AM   #5
Nederjaard
LQ Newbie
 
Registered: Feb 2012
Location: Yerseke, The Netherlands
Distribution: Kubuntu 12.10
Posts: 17

Original Poster
Rep: Reputation: Disabled
Hi klearview,
Seems that the password I wrote down when first installing MySQL is not accepted...
Amny ideas ? (and thanks for your time...)

Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Last edited by Nederjaard; 02-10-2012 at 10:02 AM. Reason: sorry, forgot to end message...
 
Old 02-10-2012, 10:14 AM   #6
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
To reset MySQL root password do this:

Quote:
sudo service mysql stop
sudo mysqld_safe --skip-grant-tables &
mysql --user=root mysql
update user set Password=PASSWORD('some_password') where user='root';
flush privileges;
quit;
Now kill mysqld:
Find its process ID:
Quote:
ps ax | grep mysql
Look up Process ID for 'sudo mysqld_safe --skip-grant-tables' and do:
Quote:
sudo kill -9 <process id here>
(will be something like 'kill -9 19678')

Start MySQL:
Quote:
sudo service mysql start
and go back to the previous post.

Last edited by klearview; 02-10-2012 at 10:15 AM. Reason: forgot sudo
 
Old 02-10-2012, 10:32 AM   #7
Nederjaard
LQ Newbie
 
Registered: Feb 2012
Location: Yerseke, The Netherlands
Distribution: Kubuntu 12.10
Posts: 17

Original Poster
Rep: Reputation: Disabled
OK, mysql password changed successfully (check!), then Akonadi configuration and server start:

Code:
kcmshell(7548)/libakonadi Akonadi::AgentManagerPrivate::createDBusInterface: AgentManager failed to get a valid AgentManager DBus interface. Error is: 1 "org.freedesktop.DBus.Error.NameHasNoOwner" "Could not get owner of name 'org.freedesktop.Akonadi.Control': no such name" 
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/home/francescm/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/opt/HomeBank", "/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) [0xb6f14d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb77e40c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6f14c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6f182b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xb758d4a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb758d8db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb758d9f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb758da85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x805c75a]
12: akonadiserver() [0x805ea65]
13: akonadiserver() [0x805f516]
14: akonadiserver() [0x8055900]
15: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6f00113]
16: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/home/francescm/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/opt/HomeBank", "/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) [0xb6e68d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb77380c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e68c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6e6c2b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xb74e14a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb74e18db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb74e19f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb74e1a85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x805c75a]
12: akonadiserver() [0x805ea65]
13: akonadiserver() [0x805f516]
14: akonadiserver() [0x8055900]
15: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6e54113]
16: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/home/francescm/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/opt/HomeBank", "/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) [0xb6ed1d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb77a10c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6ed1c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6ed52b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xb754a4a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb754a8db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb754a9f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb754aa85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x805c75a]
12: akonadiserver() [0x805ea65]
13: akonadiserver() [0x805f516]
14: akonadiserver() [0x8055900]
15: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6ebd113]
16: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/home/francescm/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/opt/HomeBank", "/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) [0xb6ff5d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb78c50c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6ff5c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6ff92b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xb766e4a6]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x618db) [0xb766e8db]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb766e9f8]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb766ea85]
10: akonadiserver() [0x80e0484]
11: akonadiserver() [0x805c75a]
12: akonadiserver() [0x805ea65]
13: akonadiserver() [0x805f516]
14: akonadiserver() [0x8055900]
15: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6fe1113]
16: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
After one more click on "start", I get:
Code:
kcmshell(7548)/libakonadi Akonadi::Control::Private::exec: Could not start/stop Akonadi!
Furthermore, Akonadi Self Server Test window gives the same errors as posted originally at the beginning of this thread.

Last edited by Nederjaard; 02-10-2012 at 10:34 AM.
 
Old 02-10-2012, 10:49 AM   #8
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
Could you post the result of this:
Quote:
dpkg -l | grep 'libqt4-sql'
 
Old 02-10-2012, 10:53 AM   #9
Nederjaard
LQ Newbie
 
Registered: Feb 2012
Location: Yerseke, The Netherlands
Distribution: Kubuntu 12.10
Posts: 17

Original Poster
Rep: Reputation: Disabled
result:
Code:
ii  libqt4-sql                            4:4.7.4-0ubuntu8.1                         Qt 4 SQL module
ii  libqt4-sql-sqlite                     4:4.7.4-0ubuntu8.1                         Qt 4 SQLite 3 database driver
 
Old 02-10-2012, 10:57 AM   #10
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
Run:

Quote:
sudo apt-get install libqt4-sql-mysql
That should be all. You can reboot after this to be on the safe side - it's not really necessary but it will ensure everything is started.

After that try running 'kcmshell4 kcm_akonadi' again and see what it says.
 
Old 02-10-2012, 11:08 AM   #11
Nederjaard
LQ Newbie
 
Registered: Feb 2012
Location: Yerseke, The Netherlands
Distribution: Kubuntu 12.10
Posts: 17

Original Poster
Rep: Reputation: Disabled
Installing library for qt4 worked, no problems there...
However, after a reboot the Akonadi Configuration gives me the same

Code:
kcmshell(2318)/libakonadi Akonadi::AgentManagerPrivate::createDBusInterface: AgentManager failed to get a valid AgentManager DBus interface. Error is: 1 "org.freedesktop.DBus.Error.NameHasNoOwner" "Could not get owner of name 'org.freedesktop.Akonadi.Control': no such name" 
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/home/francescm/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/opt/HomeBank", "/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" 
Failed to use database "akonadi" 
Database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: 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: "QMYSQL: Unable to connect"
Last database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2)"
Unable to open database "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: Unable to connect"
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6f14d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb77e40c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6f14c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6f182b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xb758d4a6]
7: akonadiserver() [0x805c1d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xb7627119]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x104ec7) [0xb7630ec7]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb763a98e]
11: akonadiserver() [0x805e30c]
12: akonadiserver() [0x805f516]
13: akonadiserver() [0x8055900]
14: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6f00113]
15: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/home/francescm/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/opt/HomeBank", "/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" 
Failed to use database "akonadi" 
Database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: 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: "QMYSQL: Unable to connect"
Last database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2)"
Unable to open database "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: Unable to connect"
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6f98d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb78680c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6f98c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6f9c2b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xb76114a6]
7: akonadiserver() [0x805c1d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xb76ab119]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x104ec7) [0xb76b4ec7]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb76be98e]
11: akonadiserver() [0x805e30c]
12: akonadiserver() [0x805f516]
13: akonadiserver() [0x8055900]
14: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6f84113]
15: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/home/francescm/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/opt/HomeBank", "/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" 
Failed to use database "akonadi" 
Database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: 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: "QMYSQL: Unable to connect"
Last database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2)"
Unable to open database "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: Unable to connect"
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6efad38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb77ca0c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6efac8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6efe2b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xb75734a6]
7: akonadiserver() [0x805c1d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xb760d119]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x104ec7) [0xb7616ec7]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb762098e]
11: akonadiserver() [0x805e30c]
12: akonadiserver() [0x805f516]
13: akonadiserver() [0x8055900]
14: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6ee6113]
15: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/home/francescm/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/opt/HomeBank", "/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" 
Failed to use database "akonadi" 
Database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: 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: "QMYSQL: Unable to connect"
Last database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2)"
Unable to open database "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: Unable to connect"
"[
0: akonadiserver() [0x805a6d5]
1: akonadiserver() [0x805aaa1]
2: /lib/i386-linux-gnu/libc.so.6(+0x2dd38) [0xb6ff1d38]
3: /lib/ld-linux.so.2(+0x10c2) [0xb78c10c2]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6ff1c8f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xb6ff52b5]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xb766a4a6]
7: akonadiserver() [0x805c1d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xb7704119]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x104ec7) [0xb770dec7]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb771798e]
11: akonadiserver() [0x805e30c]
12: akonadiserver() [0x805f516]
13: akonadiserver() [0x8055900]
14: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6fdd113]
15: akonadiserver() [0x8056241]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
It seems, through my newbie eyes, that the MySQL server cannot connect from the given socket...(whatever that may be...)
 
Old 02-10-2012, 11:20 AM   #12
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
Quote:
Failed to use database "akonadi"
Database error: "Can't connect to local MySQL server through socket '/home/francescm/.local/share/akonadi/socket-FMT-CEME-laptop/mysql.socket' (2) QMYSQL: 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.
^^^
We may have some leftovers from your old Akonadi config. (WARNING - next part will remove all Akonadi resources if executed) To remove it run (as your own user):
Quote:
rm -rf ~/.local/share/akonadi/
rm -rf ~/.config/akonadi/
rm -rf ~/.kde/share/config/akonadi*
Then try starting Akonadi again.
 
Old 02-10-2012, 11:33 AM   #13
Nederjaard
LQ Newbie
 
Registered: Feb 2012
Location: Yerseke, The Netherlands
Distribution: Kubuntu 12.10
Posts: 17

Original Poster
Rep: Reputation: Disabled
Victory !!!
Although -as expected I reckon- my mail and calendar has disappeared, everything seems to work again ! I'll try and re-configure mail settings.
One more question: do you think/know whether installing MySQL server (so I can use MySQL Workbench) should work now, or is there something I should take into consideration ?
Thank you so much for all your help, klearview, and have a wonderful weekend !

Cheers,
Francesc
 
Old 02-10-2012, 11:37 AM   #14
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
Quote:
do you think/know whether installing MySQL server (so I can use MySQL Workbench) should work now, or is there something I should take into consideration ?
MySQL server is already installed and working on your system (Akonadi is using it right now). Any application that requires MySQL server can be now installed.
 
1 members found this post helpful.
Old 02-14-2012, 05:29 AM   #15
Nederjaard
LQ Newbie
 
Registered: Feb 2012
Location: Yerseke, The Netherlands
Distribution: Kubuntu 12.10
Posts: 17

Original Poster
Rep: Reputation: Disabled
Thanks again for your sage's advice, klearview. Consider this post [SOLVED]
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
I accidentally destroyed my Linux system... bashFUL Linux - General 7 10-20-2011 10:39 AM
Akonadi failure after MySQL upgrade to 5.1.42 fvilas Slackware 2 03-07-2010 01:40 PM
Is the akonadi-mysql-5.1.39 combination possible on Slackware 13.0 ? Fritsant Slackware 2 10-01-2009 01:36 PM
Akonadi not connecting to MySQL zuser Linux - Desktop 0 04-20-2009 05:05 PM
Locked myself out of mysql...root user db table destroyed organica Linux - Server 2 12-08-2006 10:35 AM


All times are GMT -5. The time now is 04:37 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration