#REDIRECT [[Remove MySQL errors from "mysql error.log"]]
56 bytes (8 words) - 10:13, 21 August 2017
=== <h1>Remove MySQL errors from "mysql_error.log"</h1> ===
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2 KB (270 words) - 10:13, 21 August 2017
=MySQL password reset manually=
When MySQL database corrupted or password modification fails, then database connection
2 KB (351 words) - 06:02, 20 April 2024
-
0 bytes (0 words) - 09:07, 29 March 2023
=Setting up CBPolicyd with Zimbra MySQL=
Execute the following steps on MTA Node to setup CBPolicyd with Zimbra MySQL.
4 KB (472 words) - 20:59, 11 June 2021
=MySQL error 1040: Too many connections=
Error while running 'mysql --user=zimbra --password=******** --database=zimbra --batch --skip-column-n
1 KB (175 words) - 22:54, 26 September 2019
=Create users using MySQL details where accounts accidently removed from the LDAP=
...:''' Somehow users removed from LDAP and we still have account entries in MySQL DB.
3 KB (392 words) - 23:53, 17 September 2020
=How to recreate corrupted index (mysql)=
The next step was to login to mysql and check the mail_item table:
3 KB (402 words) - 22:36, 21 June 2017
=How to recreate corrupted index (mysql)=
The next step was to login to mysql and check the mail_item table:
3 KB (401 words) - 14:52, 21 June 2017
=MySql: Communication link failure=
Caused by: com.mysql.jdbc.exceptions.jdbc4.'''MySQLNonTransientConnectionException: Communicatio
2 KB (270 words) - 11:07, 9 June 2016
Both the Admin Console and zmcontrol status report that the mysql service is down. However the service is actually running.
mysql.server is not running.
2 KB (325 words) - 11:28, 30 March 2015
antispam-mysql zimbra_antispam
The pid and socket files are in /opt/zimbra/data/amavisd/mysql
906 bytes (119 words) - 17:28, 25 March 2015
Alternatively, SpamAssassin can be configured to use a dedicated MySQL back-end
database on an MTA node to store its Bayes filtering data. A MySQL database affords increased performance to SpamAssassin and message processi
3 KB (395 words) - 01:47, 11 July 2015
{{Archive}}=Mysql Crash Recovery (alternate method)=
Frequently, Mysql corruption issues are caused by a single bad line in a table within one of
9 KB (1,530 words) - 18:59, 25 March 2015
#REDIRECT [[Migrating from Postfix and MySQL with bash]]
56 bytes (8 words) - 02:23, 3 December 2009
{{Archive}}This script will help you to migrate your Postfix+MySQL (and optionally Postfixadmin) installation to Zimbra.
It reads the "mailbox" and "aliases" table used by Postfix with MySQL backend and generates a bash script that will re-create the same email acco
5 KB (579 words) - 15:46, 24 March 2015
=MySQL Backup and Restore=
...overed, you can use the [http://dev.mysql.com/doc/refman/5.0/en/mysql.html mysql] command-line tool to load the data from the dump file and binary logs.
7 KB (1,075 words) - 10:48, 12 July 2015
=Ajcody MySQL Topics= <!-- Normally will reflect page title. Is listed at ver
==Mysql==
63 KB (7,879 words) - 00:55, 21 June 2016
=Resetting LDAP and MySQL passwords=
...swords stored in [[Zmlocalconfig|localconfig]] when connecting to ldap and mysql. If these passwords are incorrect, or if you just want to change them, this
4 KB (579 words) - 18:33, 26 January 2023
#REDIRECT [[Issues with mysql and logmysql passwords]]
54 bytes (7 words) - 10:53, 13 February 2008
=Ajcody MySQL Topics= <!-- Normally will reflect page title. Is listed at ver
==Mysql==
63 KB (7,879 words) - 00:55, 21 June 2016
...command line (version mismatch for the authentication between mysql 5 and mysql 4 python libraries)
* start ldap & mysql services
8 KB (1,248 words) - 20:05, 12 July 2015
...rver, jetty in ZCS 5.0 onwards, tomcat in 4.5.x and earlier), (b) MariaDB (MySQL prior to ZCS 8.5) instances used for metadata, and (c) LDAP servers (master
* MariaDB/MySQL instance that runs on each message store server, and stores metadata (folde
61 KB (9,790 words) - 18:56, 9 December 2021
* Export ldap and mysql data from the production server
* Import ldap and mysql data into the new server
6 KB (939 words) - 19:44, 25 March 2015
=MySQL Backup and Restore=
...overed, you can use the [http://dev.mysql.com/doc/refman/5.0/en/mysql.html mysql] command-line tool to load the data from the dump file and binary logs.
7 KB (1,075 words) - 10:48, 12 July 2015
Due to wrong passwords in the database of
mysql/logmysql not able to connect to the database with the existing password. Ne
<pre>#
mysql ERROR 1044: Access denied for user 'zimbra'@'localhost' to database 'zi
4 KB (616 words) - 09:28, 13 November 2022
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
...esync with the live server over and over so I could revert it back to it's mysql hogging state and retry various procedures until I nailed one down that wor
7 KB (1,115 words) - 17:39, 25 March 2015
[] INFO: Setting mysql connector property: maxActive=100
[] INFO: Setting mysql connector property: maxActive=100
3 KB (527 words) - 22:31, 5 December 2018
=Mysql Crash Recovery=
...ery. In that example, a warning message like the following appeared in the mysql error log:
7 KB (1,206 words) - 20:38, 1 December 2021
...the tables shown in the output below, and B) generates the zimbra and root mysql user passwords, and stores them in '''[[CLI_zmlocalconfig_%28Local_Configur
==Accessing the logger MySQL database manually==
9 KB (1,242 words) - 10:17, 12 July 2015
{{Archive}}=Mysql Crash Recovery (alternate method)=
Frequently, Mysql corruption issues are caused by a single bad line in a table within one of
9 KB (1,530 words) - 18:59, 25 March 2015
=Resetting LDAP and MySQL passwords=
...swords stored in [[Zmlocalconfig|localconfig]] when connecting to ldap and mysql. If these passwords are incorrect, or if you just want to change them, this
4 KB (579 words) - 18:33, 26 January 2023
mysql
...to it. It's possible it was deleted and the deletion was never written to mysql for some reason.''
25 KB (3,687 words) - 01:12, 21 June 2016
==<font size="6">Scenario II - Mysql Server with corrupted mysql data that is beyond repair</font>==
...iscovered a lot of errors in the /opt/zimbra/mysql_error.log file, and the mysql service is not running<br>
8 KB (1,156 words) - 16:14, 5 September 2017
...removal all account blob and index data, including removal of account data mysql data
mysql mboxgroup17 -e "SET FOREIGN_KEY_CHECKS=0;delete from appointment where mail
3 KB (548 words) - 13:57, 10 January 2024
Use syslog-ng with mysql for the central log server. Add on php-syslog-ng for comfort.
** How-To Setup and Install Syslog-ng, mysql, and php-syslog-ng
47 KB (6,998 words) - 19:23, 20 June 2016
...conjunction with SNMP traps to monitor the ZCS server, disk space and the MySQL database. Email message and pager alarms should be triggered from this util
|MySQL table/index sizes
48 KB (7,341 words) - 13:38, 3 August 2015
====To Restore Just The Mysql DB====
Let's say your mysql data was 'lost/destoyed' but everything else was intact. This might be the
126 KB (19,115 words) - 13:49, 17 May 2017
For migrating LDAP,mysql and store data, go for the following!!!
mysql.server start
2 KB (337 words) - 22:50, 24 November 2009
Alternatively, SpamAssassin can be configured to use a dedicated MySQL back-end
database on an MTA node to store its Bayes filtering data. A MySQL database affords increased performance to SpamAssassin and message processi
3 KB (395 words) - 01:47, 11 July 2015
