SHARE
TWEET

Untitled

a guest May 22nd, 2017 559 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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 '/localhome/mada/.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=/localhome/mada/.local/share/akonadi/db_misc/mysql.socket"
  21. ServerPath=/usr/sbin/mysqld
  22. StartServer=true
  23. Host=
  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'.
  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  Ver 5.1.42 for mandriva-linux-gnu on i586 (Mandriva Linux - MySQL Standard Edition (GPL))
  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='/localhome/mada/.local/share/akonadi/db_data/mysql.err'>/localhome/mada/.local/share/akonadi/db_data/mysql.err</a>&apos; contains errors.
  48.  
  49. File content of '/localhome/mada/.local/share/akonadi/db_data/mysql.err':
  50. 100502 18:07:22  InnoDB: Started; log sequence number 0 3439659
  51. 100502 18:07:24 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
  52. 100502 18:07:24 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
  53. 100502 18:07:24 [Note] /usr/sbin/mysqld: ready for connections.
  54. Version: '5.1.42-log'  socket: '/localhome/mada/.local/share/akonadi/db_misc/mysql.socket'  port: 0  Mandriva Linux - MySQL Standard Edition (GPL)
  55.  
  56.  
  57. Test 5:  SUCCESS
  58. --------
  59.  
  60. MySQL server default configuration found.
  61. 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>.
  62.  
  63. File content of '/etc/akonadi/mysql-global.conf':
  64. #
  65. # Global Akonadi MySQL server settings,
  66. # These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
  67. #
  68. # Based on advice by Kris Köhntopp <kris@mysql.com>
  69. #
  70. [mysqld]
  71. skip_grant_tables
  72. skip_networking
  73.  
  74. # strict query parsing/interpretation
  75. # TODO: make Akonadi work with those settings enabled
  76. #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
  77. #sql_mode=strict_trans_tables
  78.  
  79. # use InnoDB for transactions and better crash recovery
  80. default_storage_engine=innodb
  81. # case-insensitive table names, avoids trouble on windows
  82. lower_case_table_names=1
  83. character_set_server=latin1
  84. collation_server=latin1_general_ci
  85. table_cache=200
  86. thread_cache_size=3
  87. log_bin=mysql-bin
  88. expire_logs_days=3
  89. #sync_bin_log=0
  90. # error log file name, relative to datadir
  91. log_error=mysql.err
  92. log_warnings=2
  93. # log all queries, useful for debugging but generates an enormous amount of data
  94. #log=mysql.full
  95. # log queries slower than n seconds, log file name relative to datadir (for debugging only)
  96. #log_slow_queries=mysql.slow
  97. #long_query_time=1
  98. # log queries not using indices, debug only, disable for production use
  99. #log_queries_not_using_indexes=1
  100. # maximum blob size
  101. max_allowed_packet=32M
  102. max_connections=256
  103. # makes sense when having the same query multiple times
  104. # makes no sense with prepared statements and/or transactions
  105. query_cache_type=0
  106. query_cache_size=0
  107.  
  108. innodb_file_per_table=1
  109. innodb_log_buffer_size=1M
  110. innodb_additional_mem_pool_size=1M
  111. # messure database size and adjust
  112. # SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
  113. innodb_buffer_pool_size=80M
  114. # 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)
  115. innodb_log_file_size=64M
  116. innodb_flush_log_at_trx_commit=2
  117.  
  118.  
  119.  
  120. Test 6:  SKIP
  121. --------
  122.  
  123. MySQL server custom configuration not available.
  124. Details: The custom configuration for the MySQL server was not found but is optional.
  125.  
  126. Test 7:  SUCCESS
  127. --------
  128.  
  129. MySQL server configuration is usable.
  130. Details: The MySQL server configuration was found at <a href='/localhome/mada/.local/share/akonadi/mysql.conf'>/localhome/mada/.local/share/akonadi/mysql.conf</a> and is readable.
  131.  
  132. File content of '/localhome/mada/.local/share/akonadi/mysql.conf':
  133. #
  134. # Global Akonadi MySQL server settings,
  135. # These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
  136. #
  137. # Based on advice by Kris Köhntopp <kris@mysql.com>
  138. #
  139. [mysqld]
  140. skip_grant_tables
  141. skip_networking
  142.  
  143. # strict query parsing/interpretation
  144. # TODO: make Akonadi work with those settings enabled
  145. #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
  146. #sql_mode=strict_trans_tables
  147.  
  148. # use InnoDB for transactions and better crash recovery
  149. default_storage_engine=innodb
  150. # case-insensitive table names, avoids trouble on windows
  151. lower_case_table_names=1
  152. character_set_server=latin1
  153. collation_server=latin1_general_ci
  154. table_cache=200
  155. thread_cache_size=3
  156. log_bin=mysql-bin
  157. expire_logs_days=3
  158. #sync_bin_log=0
  159. # error log file name, relative to datadir
  160. log_error=mysql.err
  161. log_warnings=2
  162. # log all queries, useful for debugging but generates an enormous amount of data
  163. #log=mysql.full
  164. # log queries slower than n seconds, log file name relative to datadir (for debugging only)
  165. #log_slow_queries=mysql.slow
  166. #long_query_time=1
  167. # log queries not using indices, debug only, disable for production use
  168. #log_queries_not_using_indexes=1
  169. # maximum blob size
  170. max_allowed_packet=32M
  171. max_connections=256
  172. # makes sense when having the same query multiple times
  173. # makes no sense with prepared statements and/or transactions
  174. query_cache_type=0
  175. query_cache_size=0
  176.  
  177. innodb_file_per_table=1
  178. innodb_log_buffer_size=1M
  179. innodb_additional_mem_pool_size=1M
  180. # messure database size and adjust
  181. # SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
  182. innodb_buffer_pool_size=80M
  183. # 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)
  184. innodb_log_file_size=64M
  185. innodb_flush_log_at_trx_commit=2
  186.  
  187.  
  188.  
  189. Test 8:  SUCCESS
  190. --------
  191.  
  192. akonadictl found and usable
  193. Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
  194. Result:
  195. Akonadi 1.3.1
  196.  
  197.  
  198. Test 9:  SUCCESS
  199. --------
  200.  
  201. Akonadi control process registered at D-Bus.
  202. Details: The Akonadi control process is registered at D-Bus which typically indicates it is operational.
  203.  
  204. Test 10:  SUCCESS
  205. --------
  206.  
  207. Akonadi server process registered at D-Bus.
  208. Details: The Akonadi server process is registered at D-Bus which typically indicates it is operational.
  209.  
  210. Test 11:  ERROR
  211. --------
  212.  
  213. Nepomuk search service not registered at D-Bus.
  214. 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.
  215.  
  216. Test 12:  SKIP
  217. --------
  218.  
  219. Protocol version check not possible.
  220. Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.
  221.  
  222. Test 13:  SUCCESS
  223. --------
  224.  
  225. Resource agents found.
  226. Details: At least one resource agent has been found.
  227.  
  228. Directory listing of '/usr/share/akonadi/agents':
  229. birthdaysresource.desktop
  230. contactsresource.desktop
  231. gcalresource.desktop
  232. googledataresource.desktop
  233. icalresource.desktop
  234. imapresource.desktop
  235. kabcresource.desktop
  236. kcalresource.desktop
  237. knutresource.desktop
  238. kolabproxyresource.desktop
  239. localbookmarksresource.desktop
  240. maildirresource.desktop
  241. maildispatcheragent.desktop
  242. mboxresource.desktop
  243. microblog.desktop
  244. mtdummyresource.desktop
  245. nepomuktagresource.desktop
  246. nntpresource.desktop
  247. notesresource.desktop
  248. pop3resource.desktop
  249. vcarddirresource.desktop
  250. vcardresource.desktop
  251. Directory listing of '/usr/share/akonadi/agents':
  252. birthdaysresource.desktop
  253. contactsresource.desktop
  254. gcalresource.desktop
  255. googledataresource.desktop
  256. icalresource.desktop
  257. imapresource.desktop
  258. kabcresource.desktop
  259. kcalresource.desktop
  260. knutresource.desktop
  261. kolabproxyresource.desktop
  262. localbookmarksresource.desktop
  263. maildirresource.desktop
  264. maildispatcheragent.desktop
  265. mboxresource.desktop
  266. microblog.desktop
  267. mtdummyresource.desktop
  268. nepomuktagresource.desktop
  269. nntpresource.desktop
  270. notesresource.desktop
  271. pop3resource.desktop
  272. vcarddirresource.desktop
  273. vcardresource.desktop
  274.  
  275. Environment variable XDG_DATA_DIRS is set to '/usr/share:/usr/share:/usr/local/share'
  276.  
  277. Test 14:  SUCCESS
  278. --------
  279.  
  280. No current Akonadi server error log found.
  281. Details: The Akonadi server did not report any errors during its current startup.
  282.  
  283. Test 15:  ERROR
  284. --------
  285.  
  286. Previous Akonadi server error log found.
  287. Details: The Akonadi server did report error during its previous startup into <a href='/localhome/mada/.local/share/akonadi/akonadiserver.error.old'>/localhome/mada/.local/share/akonadi/akonadiserver.error.old</a>.
  288.  
  289. File content of '/localhome/mada/.local/share/akonadi/akonadiserver.error.old':
  290. Control process died, committing suicide!
  291. D-Bus session bus went down - quitting
  292.  
  293.  
  294. Test 16:  SUCCESS
  295. --------
  296.  
  297. No current Akonadi control error log found.
  298. Details: The Akonadi control process did not report any errors during its current startup.
  299.  
  300. Test 17:  ERROR
  301. --------
  302.  
  303. Previous Akonadi control error log found.
  304. Details: The Akonadi control process did report error during its previous startup into <a href='/localhome/mada/.local/share/akonadi/akonadi_control.error.old'>/localhome/mada/.local/share/akonadi/akonadi_control.error.old</a>.
  305.  
  306. File content of '/localhome/mada/.local/share/akonadi/akonadi_control.error.old':
  307. D-Bus session bus went down - quitting
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top