[已解决]升级到KDE 4.4 Beta2，有个Akonadi总是报错…

十六薙夜血

已经解决：

As fduraibi mentioned, it is just because mysqld can't start as root. I add "user=root" in the Akonadi local mysql configuration file (on my computer, it is /root/.local/share/akonadi//mysql.conf), and Akonadi server can be started successfully.


----------------------------------------------------------------------------------------------------------------------

opensuse11.2
4.3.85 (KDE 4.3.85 (KDE 4.4 Beta2)) "release 203"

启动koncact收信，系统先启动了Akonadi，结果这家伙还没一次能成功启动的。报错图片如下图所示。

同时还报出了一对错误日志，哪位大大知道怎么解决这个问题？

那个qtsql需要的driver  “qmysql”  我在源里没搜索到阿？

错误日志：

1. Akonadi Server Self-Test Report
   
2. ===============================
   
3. 
   
4. Test 1:  SUCCESS
   
5. --------
   
6. 
   
7. Database driver found.
   
8. Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration and was found on your system.
   
9. 
   
10. File content of '/root/.config/akonadi/akonadiserverrc':
    
11. [%General]
    
12. Driver=QMYSQL
    
13. SizeThreshold=4096
    
14. ExternalPayload=false
    
15. 
    
16. [QMYSQL]
    
17. Name=akonadi
    
18. User=
    
19. Password=
    
20. Options="UNIX_SOCKET=/root/.local/share/akonadi/db_misc/mysql.socket"
    
21. ServerPath=/usr/sbin/mysqld
    
22. StartServer=true
    
23. 
    
24. 
    
25. Test 2:  SUCCESS
    
26. --------
    
27. 
    
28. MySQL server found.
    
29. Details: You currently have configured Akonadi to use the MySQL server '/usr/sbin/mysqld'.
    
30. Make sure you have the MySQL server installed, set the correct path and ensure you have the necessary read and execution rights on the server executable. The server executable is typically called 'mysqld', its locations varies depending on the distribution.
    
31. 
    
32. Test 3:  SUCCESS
    
33. --------
    
34. 
    
35. MySQL server is executable.
    
36. Details: MySQL server found: /usr/sbin/mysqld  Ver 5.1.36-log for suse-linux-gnu on x86_64 (SUSE MySQL RPM)
    
37. 
    
38. 
    
39. Test 4:  SUCCESS
    
40. --------
    
41. 
    
42. No current MySQL error log found.
    
43. Details: The MySQL server did not report any errors during this startup into '/root/.local/share/akonadi/db_data/mysql.err'.
    
44. 
    
45. Test 5:  SUCCESS
    
46. --------
    
47. 
    
48. MySQL server default configuration found.
    
49. Details: The default configuration for the MySQL server was found and is readable at <a href='/etc/akonadi/mysql-global.conf'>/etc/akonadi/mysql-global.conf</a>.
    
50. 
    
51. File content of '/etc/akonadi/mysql-global.conf':
    
52. #
    
53. # Global Akonadi MySQL server settings,
    
54. # These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
    
55. #
    
56. # Based on advice by Kris Köhntopp <kris@mysql.com>
    
57. #
    
58. [mysqld]
    
59. skip_grant_tables
    
60. skip_networking
    
61. 
    
62. # strict query parsing/interpretation
    
63. # TODO: make Akonadi work with those settings enabled
    
64. #sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
    
65. #sql_mode=strict_trans_tables
    
66. 
    
67. # use InnoDB for transactions and better crash recovery
    
68. default_storage_engine=innodb
    
69. # case-insensitive table names, avoids trouble on windows
    
70. lower_case_table_names=1
    
71. character_set_server=latin1
    
72. collation_server=latin1_general_ci
    
73. table_cache=200
    
74. thread_cache_size=3
    
75. log_bin=mysql-bin
    
76. expire_logs_days=3
    
77. #sync_bin_log=0
    
78. # error log file name, relative to datadir
    
79. log_error=mysql.err
    
80. log_warnings=2
    
81. # log all queries, useful for debugging but generates an enormous amount of data
    
82. #log=mysql.full
    
83. # log queries slower than n seconds, log file name relative to datadir
    
84. log_slow_queries=mysql.slow
    
85. long_query_time=1
    
86. # log queries not using indices, debug only, disable for production use
    
87. log_queries_not_using_indexes=1
    
88. # maximum blob size
    
89. max_allowed_packet=32M
    
90. max_connections=256
    
91. # makes sense when having the same query multiple times
    
92. # makes no sense with prepared statements and/or transactions
    
93. query_cache_type=0
    
94. query_cache_size=0
    
95. 
    
96. innodb_file_per_table=1
    
97. innodb_log_buffer_size=1M
    
98. innodb_additional_mem_pool_size=1M
    
99. # messure database size and adjust
    
100. # SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
     
101. innodb_buffer_pool_size=80M
     
102. # size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
     
103. innodb_log_file_size=64M
     
104. innodb_flush_log_at_trx_commit=2
     
105. 
     
106. 
     
107. 
     
108. Test 6:  SKIP
     
109. --------
     
110. 
     
111. MySQL server custom configuration not available.
     
112. Details: The custom configuration for the MySQL server was not found but is optional.
     
113. 
     
114. Test 7:  SUCCESS
     
115. --------
     
116. 
     
117. MySQL server configuration is usable.
     
118. Details: The MySQL server configuration was found at <a href='/root/.local/share/akonadi/mysql.conf'>/root/.local/share/akonadi/mysql.conf</a> and is readable.
     
119. 
     
120. File content of '/root/.local/share/akonadi/mysql.conf':
     
121. #
     
122. # Global Akonadi MySQL server settings,
     
123. # These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
     
124. #
     
125. # Based on advice by Kris Köhntopp <kris@mysql.com>
     
126. #
     
127. [mysqld]
     
128. skip_grant_tables
     
129. skip_networking
     
130. 
     
131. # strict query parsing/interpretation
     
132. # TODO: make Akonadi work with those settings enabled
     
133. #sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
     
134. #sql_mode=strict_trans_tables
     
135. 
     
136. # use InnoDB for transactions and better crash recovery
     
137. default_storage_engine=innodb
     
138. # case-insensitive table names, avoids trouble on windows
     
139. lower_case_table_names=1
     
140. character_set_server=latin1
     
141. collation_server=latin1_general_ci
     
142. table_cache=200
     
143. thread_cache_size=3
     
144. log_bin=mysql-bin
     
145. expire_logs_days=3
     
146. #sync_bin_log=0
     
147. # error log file name, relative to datadir
     
148. log_error=mysql.err
     
149. log_warnings=2
     
150. # log all queries, useful for debugging but generates an enormous amount of data
     
151. #log=mysql.full
     
152. # log queries slower than n seconds, log file name relative to datadir
     
153. log_slow_queries=mysql.slow
     
154. long_query_time=1
     
155. # log queries not using indices, debug only, disable for production use
     
156. log_queries_not_using_indexes=1
     
157. # maximum blob size
     
158. max_allowed_packet=32M
     
159. max_connections=256
     
160. # makes sense when having the same query multiple times
     
161. # makes no sense with prepared statements and/or transactions
     
162. query_cache_type=0
     
163. query_cache_size=0
     
164. 
     
165. innodb_file_per_table=1
     
166. innodb_log_buffer_size=1M
     
167. innodb_additional_mem_pool_size=1M
     
168. # messure database size and adjust
     
169. # SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
     
170. innodb_buffer_pool_size=80M
     
171. # size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
     
172. innodb_log_file_size=64M
     
173. innodb_flush_log_at_trx_commit=2
     
174. 
     
175. 
     
176. 
     
177. Test 8:  SUCCESS
     
178. --------
     
179. 
     
180. akonadictl found and usable
     
181. Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
     
182. Result:
     
183. Akonadi 1.2.80
     
184. 
     
185. 
     
186. Test 9:  ERROR
     
187. --------
     
188. 
     
189. Akonadi control process not registered at D-Bus.
     
190. Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.
     
191. 
     
192. Test 10:  ERROR
     
193. --------
     
194. 
     
195. Akonadi server process not registered at D-Bus.
     
196. Details: The Akonadi server process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.
     
197. 
     
198. Test 11:  ERROR
     
199. --------
     
200. 
     
201. Nepomuk search service not registered at D-Bus.
     
202. Details: The Nepomuk search service is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.
     
203. 
     
204. Test 12:  SKIP
     
205. --------
     
206. 
     
207. Protocol version check not possible.
     
208. Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.
     
209. 
     
210. Test 13:  ERROR
     
211. --------
     
212. 
     
213. No resource agents found.
     
214. Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: '/usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/etc/opt/kde3/share:/opt/kde3/share', make sure this includes all paths where Akonadi agents are installed to.
     
215. 
     
216. Directory listing of '/usr/share/akonadi/agents':
     
217. birthdaysresource.desktop
     
218. contactsresource.desktop
     
219. icalresource.desktop
     
220. imapresource.desktop
     
221. kabcresource.desktop
     
222. kcalresource.desktop
     
223. kolabproxyresource.desktop
     
224. localbookmarksresource.desktop
     
225. maildirresource.desktop
     
226. maildispatcheragent.desktop
     
227. mboxresource.desktop
     
228. microblog.desktop
     
229. mtdummyresource.desktop
     
230. nepomukcalendarfeeder.desktop
     
231. nepomukcontactfeeder.desktop
     
232. nepomukemailfeeder.desktop
     
233. nepomuktagresource.desktop
     
234. nntpresource.desktop
     
235. notesresource.desktop
     
236. pop3resource.desktop
     
237. vcarddirresource.desktop
     
238. vcardresource.desktop
     
239. 
     
240. Environment variable XDG_DATA_DIRS is set to '/usr/share:/etc/opt/kde3/share:/opt/kde3/share'
     
241. 
     
242. Test 14:  ERROR
     
243. --------
     
244. 
     
245. Current Akonadi server error log found.
     
246. Details: The Akonadi server did report error during startup into <a href='/root/.local/share/akonadi/akonadiserver.error'>/root/.local/share/akonadi/akonadiserver.error</a>.
     
247. 
     
248. File content of '/root/.local/share/akonadi/akonadiserver.error':
     
249. "[
     
250. 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b869]
     
251. 1: akonadiserver [0x40bdb2]
     
252. 2: /lib64/libc.so.6 [0x7f42c0fcb560]
     
253. 3: /lib64/libc.so.6(gsignal+0x35) [0x7f42c0fcb4e5]
     
254. 4: /lib64/libc.so.6(abort+0x180) [0x7f42c0fcc9b0]
     
255. 5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f42c217c7e4]
     
256. 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40cda8]
     
257. 7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78) [0x7f42c220ae38]
     
258. 8: /usr/lib64/libQtCore.so.4 [0x7f42c221cee9]
     
259. 9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f42c221e03b]
     
260. 10: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x1780) [0x7f42c25e0760]
     
261. 11: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x76) [0x7f42c25e2d56]
     
262. 12: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f42c25e404a]
     
263. 13: akonadiserver(main+0x3a4) [0x406424]
     
264. 14: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f42c0fb7a7d]
     
265. 15: akonadiserver [0x405f89]
     
266. ]
     
267. "
     
268. 
     
269. 
     
270. Test 15:  ERROR
     
271. --------
     
272. 
     
273. Previous Akonadi server error log found.
     
274. Details: The Akonadi server did report error during its previous startup into <a href='/root/.local/share/akonadi/akonadiserver.error.old'>/root/.local/share/akonadi/akonadiserver.error.old</a>.
     
275. 
     
276. File content of '/root/.local/share/akonadi/akonadiserver.error.old':
     
277. "[
     
278. 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b869]
     
279. 1: akonadiserver [0x40bdb2]
     
280. 2: /lib64/libc.so.6 [0x7f80c2b59560]
     
281. 3: /lib64/libc.so.6(gsignal+0x35) [0x7f80c2b594e5]
     
282. 4: /lib64/libc.so.6(abort+0x180) [0x7f80c2b5a9b0]
     
283. 5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f80c3d0a7e4]
     
284. 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40cda8]
     
285. 7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78) [0x7f80c3d98e38]
     
286. 8: /usr/lib64/libQtCore.so.4 [0x7f80c3daaee9]
     
287. 9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f80c3dac03b]
     
288. 10: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x1780) [0x7f80c416e760]
     
289. 11: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x76) [0x7f80c4170d56]
     
290. 12: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f80c417204a]
     
291. 13: akonadiserver(main+0x3a4) [0x406424]
     
292. 14: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f80c2b45a7d]
     
293. 15: akonadiserver [0x405f89]
     
294. ]
     
295. "
     
296. 
     
297. 
     
298. Test 16:  SUCCESS
     
299. --------
     
300. 
     
301. No current Akonadi control error log found.
     
302. Details: The Akonadi control process did not report any errors during its current startup.
     
303. 
     
304. Test 17:  SUCCESS
     
305. --------
     
306. 
     
307. No previous Akonadi control error log found.
     
308. Details: The Akonadi control process did not report any errors during its previous startup.
     
309. 
     

复制代码

loverf

4.3.85没见过这情况。

gthm

Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/root/.local/share/akonadi//mysql.conf", "--datadir=/root/.local/share/akonadi/db_data/", "--socket=/root/.local/share/akonadi/db_misc/mysql.socket")
stdout: ""
stderr: "100117  8:29:31 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
100117  8:29:31 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

100117  8:29:31 [ERROR] Aborting

100117  8:29:31 [Note] /usr/sbin/mysqld: Shutdown complete

"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8052185]
1: akonadiserver() [0x805271c]
2: [0xffffe400]
3: [0xffffe424]
4: /lib/i686/libc.so.6(gsignal+0x51) [0xb71f8a71]
5: /lib/i686/libc.so.6(abort+0x182) [0xb71fa3c2]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x94) [0xb7551a44]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8053258]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8c) [0xb75e668c]
9: /usr/lib/libQtCore.so.4(+0xe5a9d) [0xb75f5a9d]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0xb75f6f68]
11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804d223]
12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x1a66) [0xb77a18d6]
13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x76) [0xb77a3d36]
14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb77a50b8]
15: akonadiserver(main+0x2db) [0x804c89b]
16: /lib/i686/libc.so.6(__libc_start_main+0xe6) [0xb71e5b96]
17: akonadiserver() [0x804c4f1]
]
"

gthm

Post by 十六薙夜血;2058868
已经解决：

As fduraibi mentioned, it is just because mysqld can't start as root. I add "user=root" in the Akonadi local mysql configuration file (on my computer, it is /root/.local/share/akonadi//mysql.conf), and Akonadi server can be started successfully.

问题解决了，thx :-)