Advertisement
Guest User

Untitled

a guest
May 21st, 2017
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.29 KB | None | 0 0
  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 '/home/jr/.config/akonadi/akonadiserverrc':
  11. [%General]
  12. Driver=QMYSQL
  13. SizeThreshold=4096
  14. ExternalPayload=false
  15.  
  16. [QMYSQL]
  17. Name=akonadi
  18. Host=
  19. User=
  20. Password=
  21. Options="UNIX_SOCKET=/home/jr/.local/share/akonadi/db_misc/mysql.socket"
  22. ServerPath=/usr/sbin/mysqld-akonadi
  23. StartServer=true
  24.  
  25. [Debug]
  26. Tracer=null
  27.  
  28.  
  29. Test 2: SUCCESS
  30. --------
  31.  
  32. MySQL server found.
  33. Details: You currently have configured Akonadi to use the MySQL server '/usr/sbin/mysqld-akonadi'.
  34. 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.
  35.  
  36. Test 3: SUCCESS
  37. --------
  38.  
  39. MySQL server is executable.
  40. Details: MySQL server found: /usr/sbin/mysqld-akonadi Ver 5.1.41-3ubuntu11 for debian-linux-gnu on x86_64 ((Ubuntu))
  41.  
  42.  
  43. Test 4: ERROR
  44. --------
  45.  
  46. MySQL server log contains errors.
  47. Details: The MySQL server error log file &apos;<a href='/home/jr/.local/share/akonadi/db_data/mysql.err'>/home/jr/.local/share/akonadi/db_data/mysql.err</a>&apos; contains errors.
  48.  
  49. File content of '/home/jr/.local/share/akonadi/db_data/mysql.err':
  50. 100426 16:33:40 [Note] Plugin 'FEDERATED' is disabled.
  51. InnoDB: Unable to lock ./ibdata1, error: 11
  52. InnoDB: Check that you do not already have another mysqld process
  53. InnoDB: using the same InnoDB data or log files.
  54. 100426 16:33:40 InnoDB: Retrying to lock the first data file
  55. InnoDB: Unable to lock ./ibdata1, error: 11
  56. InnoDB: Check that you do not already have another mysqld process
  57. InnoDB: using the same InnoDB data or log files.
  58. InnoDB: Unable to lock ./ibdata1, error: 11
  59. InnoDB: Check that you do not already have another mysqld process
  60. InnoDB: using the same InnoDB data or log files.
  61. InnoDB: Unable to lock ./ibdata1, error: 11
  62. InnoDB: Check that you do not already have another mysqld process
  63. InnoDB: using the same InnoDB data or log files.
  64. InnoDB: Unable to lock ./ibdata1, error: 11
  65. InnoDB: Check that you do not already have another mysqld process
  66. InnoDB: using the same InnoDB data or log files.
  67. InnoDB: Unable to lock ./ibdata1, error: 11
  68. InnoDB: Check that you do not already have another mysqld process
  69. InnoDB: using the same InnoDB data or log files.
  70. InnoDB: Unable to lock ./ibdata1, error: 11
  71. InnoDB: Check that you do not already have another mysqld process
  72. InnoDB: using the same InnoDB data or log files.
  73. InnoDB: Unable to lock ./ibdata1, error: 11
  74. InnoDB: Check that you do not already have another mysqld process
  75. InnoDB: using the same InnoDB data or log files.
  76. InnoDB: Unable to lock ./ibdata1, error: 11
  77. InnoDB: Check that you do not already have another mysqld process
  78. InnoDB: using the same InnoDB data or log files.
  79. InnoDB: Unable to lock ./ibdata1, error: 11
  80. InnoDB: Check that you do not already have another mysqld process
  81. InnoDB: using the same InnoDB data or log files.
  82. InnoDB: Unable to lock ./ibdata1, error: 11
  83. InnoDB: Check that you do not already have another mysqld process
  84. InnoDB: using the same InnoDB data or log files.
  85. InnoDB: Unable to lock ./ibdata1, error: 11
  86. InnoDB: Check that you do not already have another mysqld process
  87. InnoDB: using the same InnoDB data or log files.
  88. InnoDB: Unable to lock ./ibdata1, error: 11
  89. InnoDB: Check that you do not already have another mysqld process
  90. InnoDB: using the same InnoDB data or log files.
  91. InnoDB: Unable to lock ./ibdata1, error: 11
  92. InnoDB: Check that you do not already have another mysqld process
  93. InnoDB: using the same InnoDB data or log files.
  94. InnoDB: Unable to lock ./ibdata1, error: 11
  95. InnoDB: Check that you do not already have another mysqld process
  96. InnoDB: using the same InnoDB data or log files.
  97. InnoDB: Unable to lock ./ibdata1, error: 11
  98. InnoDB: Check that you do not already have another mysqld process
  99. InnoDB: using the same InnoDB data or log files.
  100. InnoDB: Unable to lock ./ibdata1, error: 11
  101. InnoDB: Check that you do not already have another mysqld process
  102. InnoDB: using the same InnoDB data or log files.
  103. InnoDB: Unable to lock ./ibdata1, error: 11
  104. InnoDB: Check that you do not already have another mysqld process
  105. InnoDB: using the same InnoDB data or log files.
  106. InnoDB: Unable to lock ./ibdata1, error: 11
  107. InnoDB: Check that you do not already have another mysqld process
  108. InnoDB: using the same InnoDB data or log files.
  109. InnoDB: Unable to lock ./ibdata1, error: 11
  110. InnoDB: Check that you do not already have another mysqld process
  111. InnoDB: using the same InnoDB data or log files.
  112. InnoDB: Unable to lock ./ibdata1, error: 11
  113. InnoDB: Check that you do not already have another mysqld process
  114. InnoDB: using the same InnoDB data or log files.
  115. InnoDB: Unable to lock ./ibdata1, error: 11
  116. InnoDB: Check that you do not already have another mysqld process
  117. InnoDB: using the same InnoDB data or log files.
  118. InnoDB: Unable to lock ./ibdata1, error: 11
  119. InnoDB: Check that you do not already have another mysqld process
  120. InnoDB: using the same InnoDB data or log files.
  121. InnoDB: Unable to lock ./ibdata1, error: 11
  122. InnoDB: Check that you do not already have another mysqld process
  123. InnoDB: using the same InnoDB data or log files.
  124. InnoDB: Unable to lock ./ibdata1, error: 11
  125. InnoDB: Check that you do not already have another mysqld process
  126. InnoDB: using the same InnoDB data or log files.
  127. InnoDB: Unable to lock ./ibdata1, error: 11
  128. InnoDB: Check that you do not already have another mysqld process
  129. InnoDB: using the same InnoDB data or log files.
  130. InnoDB: Unable to lock ./ibdata1, error: 11
  131. InnoDB: Check that you do not already have another mysqld process
  132. InnoDB: using the same InnoDB data or log files.
  133. InnoDB: Unable to lock ./ibdata1, error: 11
  134. InnoDB: Check that you do not already have another mysqld process
  135. InnoDB: using the same InnoDB data or log files.
  136. InnoDB: Unable to lock ./ibdata1, error: 11
  137. InnoDB: Check that you do not already have another mysqld process
  138. InnoDB: using the same InnoDB data or log files.
  139. InnoDB: Unable to lock ./ibdata1, error: 11
  140. InnoDB: Check that you do not already have another mysqld process
  141. InnoDB: using the same InnoDB data or log files.
  142. InnoDB: Unable to lock ./ibdata1, error: 11
  143. InnoDB: Check that you do not already have another mysqld process
  144. InnoDB: using the same InnoDB data or log files.
  145. InnoDB: Unable to lock ./ibdata1, error: 11
  146. InnoDB: Check that you do not already have another mysqld process
  147. InnoDB: using the same InnoDB data or log files.
  148. InnoDB: Unable to lock ./ibdata1, error: 11
  149. InnoDB: Check that you do not already have another mysqld process
  150. InnoDB: using the same InnoDB data or log files.
  151. InnoDB: Unable to lock ./ibdata1, error: 11
  152. InnoDB: Check that you do not already have another mysqld process
  153. InnoDB: using the same InnoDB data or log files.
  154. InnoDB: Unable to lock ./ibdata1, error: 11
  155. InnoDB: Check that you do not already have another mysqld process
  156. InnoDB: using the same InnoDB data or log files.
  157. InnoDB: Unable to lock ./ibdata1, error: 11
  158. InnoDB: Check that you do not already have another mysqld process
  159. InnoDB: using the same InnoDB data or log files.
  160. InnoDB: Unable to lock ./ibdata1, error: 11
  161. InnoDB: Check that you do not already have another mysqld process
  162. InnoDB: using the same InnoDB data or log files.
  163. InnoDB: Unable to lock ./ibdata1, error: 11
  164. InnoDB: Check that you do not already have another mysqld process
  165. InnoDB: using the same InnoDB data or log files.
  166. InnoDB: Unable to lock ./ibdata1, error: 11
  167. InnoDB: Check that you do not already have another mysqld process
  168. InnoDB: using the same InnoDB data or log files.
  169. InnoDB: Unable to lock ./ibdata1, error: 11
  170. InnoDB: Check that you do not already have another mysqld process
  171. InnoDB: using the same InnoDB data or log files.
  172. InnoDB: Unable to lock ./ibdata1, error: 11
  173. InnoDB: Check that you do not already have another mysqld process
  174. InnoDB: using the same InnoDB data or log files.
  175. InnoDB: Unable to lock ./ibdata1, error: 11
  176. InnoDB: Check that you do not already have another mysqld process
  177. InnoDB: using the same InnoDB data or log files.
  178. InnoDB: Unable to lock ./ibdata1, error: 11
  179. InnoDB: Check that you do not already have another mysqld process
  180. InnoDB: using the same InnoDB data or log files.
  181. InnoDB: Unable to lock ./ibdata1, error: 11
  182. InnoDB: Check that you do not already have another mysqld process
  183. InnoDB: using the same InnoDB data or log files.
  184. InnoDB: Unable to lock ./ibdata1, error: 11
  185. InnoDB: Check that you do not already have another mysqld process
  186. InnoDB: using the same InnoDB data or log files.
  187. InnoDB: Unable to lock ./ibdata1, error: 11
  188. InnoDB: Check that you do not already have another mysqld process
  189. InnoDB: using the same InnoDB data or log files.
  190. InnoDB: Unable to lock ./ibdata1, error: 11
  191. InnoDB: Check that you do not already have another mysqld process
  192. InnoDB: using the same InnoDB data or log files.
  193.  
  194.  
  195. Test 5: SUCCESS
  196. --------
  197.  
  198. MySQL server default configuration found.
  199. 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>.
  200.  
  201. File content of '/etc/akonadi/mysql-global.conf':
  202. #
  203. # Global Akonadi MySQL server settings,
  204. # These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
  205. #
  206. # Based on advice by Kris Köhntopp <kris@mysql.com>
  207. #
  208. [mysqld]
  209. skip_grant_tables
  210. skip_networking
  211.  
  212. # strict query parsing/interpretation
  213. # TODO: make Akonadi work with those settings enabled
  214. #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
  215. #sql_mode=strict_trans_tables
  216.  
  217. # use InnoDB for transactions and better crash recovery
  218. default_storage_engine=innodb
  219. # case-insensitive table names, avoids trouble on windows
  220. lower_case_table_names=1
  221. character_set_server=latin1
  222. collation_server=latin1_general_ci
  223. table_cache=200
  224. thread_cache_size=3
  225. log_bin=mysql-bin
  226. expire_logs_days=3
  227. #sync_bin_log=0
  228. # error log file name, relative to datadir
  229. log_error=mysql.err
  230. log_warnings=2
  231. # log all queries, useful for debugging but generates an enormous amount of data
  232. #log=mysql.full
  233. # log queries slower than n seconds, log file name relative to datadir (for debugging only)
  234. #log_slow_queries=mysql.slow
  235. #long_query_time=1
  236. # log queries not using indices, debug only, disable for production use
  237. #log_queries_not_using_indexes=1
  238. # maximum blob size
  239. max_allowed_packet=32M
  240. max_connections=256
  241. # makes sense when having the same query multiple times
  242. # makes no sense with prepared statements and/or transactions
  243. query_cache_type=0
  244. query_cache_size=0
  245.  
  246. innodb_file_per_table=1
  247. innodb_log_buffer_size=1M
  248. innodb_additional_mem_pool_size=1M
  249. # messure database size and adjust
  250. # SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
  251. innodb_buffer_pool_size=80M
  252. # 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)
  253. innodb_log_file_size=64M
  254. innodb_flush_log_at_trx_commit=2
  255.  
  256.  
  257.  
  258. Test 6: SKIP
  259. --------
  260.  
  261. MySQL server custom configuration not available.
  262. Details: The custom configuration for the MySQL server was not found but is optional.
  263.  
  264. Test 7: SUCCESS
  265. --------
  266.  
  267. MySQL server configuration is usable.
  268. Details: The MySQL server configuration was found at <a href='/home/jr/.local/share/akonadi/mysql.conf'>/home/jr/.local/share/akonadi/mysql.conf</a> and is readable.
  269.  
  270. File content of '/home/jr/.local/share/akonadi/mysql.conf':
  271. #
  272. # Global Akonadi MySQL server settings,
  273. # These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
  274. #
  275. # Based on advice by Kris Köhntopp <kris@mysql.com>
  276. #
  277. [mysqld]
  278. skip_grant_tables
  279. skip_networking
  280.  
  281. # strict query parsing/interpretation
  282. # TODO: make Akonadi work with those settings enabled
  283. #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
  284. #sql_mode=strict_trans_tables
  285.  
  286. # use InnoDB for transactions and better crash recovery
  287. default_storage_engine=innodb
  288. # case-insensitive table names, avoids trouble on windows
  289. lower_case_table_names=1
  290. character_set_server=latin1
  291. collation_server=latin1_general_ci
  292. table_cache=200
  293. thread_cache_size=3
  294. log_bin=mysql-bin
  295. expire_logs_days=3
  296. #sync_bin_log=0
  297. # error log file name, relative to datadir
  298. log_error=mysql.err
  299. log_warnings=2
  300. # log all queries, useful for debugging but generates an enormous amount of data
  301. #log=mysql.full
  302. # log queries slower than n seconds, log file name relative to datadir (for debugging only)
  303. #log_slow_queries=mysql.slow
  304. #long_query_time=1
  305. # log queries not using indices, debug only, disable for production use
  306. #log_queries_not_using_indexes=1
  307. # maximum blob size
  308. max_allowed_packet=32M
  309. max_connections=256
  310. # makes sense when having the same query multiple times
  311. # makes no sense with prepared statements and/or transactions
  312. query_cache_type=0
  313. query_cache_size=0
  314.  
  315. innodb_file_per_table=1
  316. innodb_log_buffer_size=1M
  317. innodb_additional_mem_pool_size=1M
  318. # messure database size and adjust
  319. # SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
  320. innodb_buffer_pool_size=80M
  321. # 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)
  322. innodb_log_file_size=64M
  323. innodb_flush_log_at_trx_commit=2
  324.  
  325.  
  326.  
  327. Test 8: SUCCESS
  328. --------
  329.  
  330. akonadictl found and usable
  331. Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
  332. Result:
  333. Akonadi 1.3.1
  334.  
  335.  
  336. Test 9: SUCCESS
  337. --------
  338.  
  339. Akonadi control process registered at D-Bus.
  340. Details: The Akonadi control process is registered at D-Bus which typically indicates it is operational.
  341.  
  342. Test 10: SUCCESS
  343. --------
  344.  
  345. Akonadi server process registered at D-Bus.
  346. Details: The Akonadi server process is registered at D-Bus which typically indicates it is operational.
  347.  
  348. Test 11: SUCCESS
  349. --------
  350.  
  351. Nepomuk search service registered at D-Bus.
  352. Details: The Nepomuk search service is registered at D-Bus which typically indicates it is operational.
  353.  
  354. Test 12: SUCCESS
  355. --------
  356.  
  357. Nepomuk search service uses an appropriate backend.
  358. Details: The Nepomuk search service uses one of the recommended backends.
  359.  
  360. Test 13: SUCCESS
  361. --------
  362.  
  363. Server protocol version is recent enough.
  364. Details: The server Protocol version is 23, which equal or newer than the required version 23.
  365.  
  366. Test 14: ERROR
  367. --------
  368.  
  369. No resource agents found.
  370. 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 /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/share:/usr/local/share', make sure this includes all paths where Akonadi agents are installed to.
  371.  
  372. Directory listing of '/usr/share/akonadi/agents':
  373. birthdaysresource.desktop
  374. contactsresource.desktop
  375. icalresource.desktop
  376. imapresource.desktop
  377. kabcresource.desktop
  378. kcalresource.desktop
  379. knutresource.desktop
  380. kolabproxyresource.desktop
  381. localbookmarksresource.desktop
  382. maildirresource.desktop
  383. maildispatcheragent.desktop
  384. mboxresource.desktop
  385. microblog.desktop
  386. mtdummyresource.desktop
  387. nepomukcalendarfeeder.desktop
  388. nepomukcontactfeeder.desktop
  389. nepomuktagresource.desktop
  390. nntpresource.desktop
  391. notesresource.desktop
  392. pop3resource.desktop
  393. vcarddirresource.desktop
  394. vcardresource.desktop
  395. Directory listing of '/usr/share/akonadi/agents':
  396. birthdaysresource.desktop
  397. contactsresource.desktop
  398. icalresource.desktop
  399. imapresource.desktop
  400. kabcresource.desktop
  401. kcalresource.desktop
  402. knutresource.desktop
  403. kolabproxyresource.desktop
  404. localbookmarksresource.desktop
  405. maildirresource.desktop
  406. maildispatcheragent.desktop
  407. mboxresource.desktop
  408. microblog.desktop
  409. mtdummyresource.desktop
  410. nepomukcalendarfeeder.desktop
  411. nepomukcontactfeeder.desktop
  412. nepomuktagresource.desktop
  413. nntpresource.desktop
  414. notesresource.desktop
  415. pop3resource.desktop
  416. vcarddirresource.desktop
  417. vcardresource.desktop
  418.  
  419. Environment variable XDG_DATA_DIRS is set to '/usr/share:/usr/share:/usr/local/share'
  420.  
  421. Test 15: SUCCESS
  422. --------
  423.  
  424. No current Akonadi server error log found.
  425. Details: The Akonadi server did not report any errors during its current startup.
  426.  
  427. Test 16: SUCCESS
  428. --------
  429.  
  430. No previous Akonadi server error log found.
  431. Details: The Akonadi server did not report any errors during its previous startup.
  432.  
  433. Test 17: SUCCESS
  434. --------
  435.  
  436. No current Akonadi control error log found.
  437. Details: The Akonadi control process did not report any errors during its current startup.
  438.  
  439. Test 18: SUCCESS
  440. --------
  441.  
  442. No previous Akonadi control error log found.
  443. Details: The Akonadi control process did not report any errors during its previous startup.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement