Topic: Where do I find the MYSQL Configuration?
==== Required information ====
iRedMail 0.8.3
MySQL
OS = PCBSD 9.1
====
Hello, Dears,
where do I find the MySQL Server Configruation?
Or which Entries in "/etc/my.cnf" are mandatory if you're using the so called standard configuration without a "my.cnf"
I have to enable Network access for another database, though I need a different Configuration beside the standard Config.
Attached you'll find my testconfiguration
Starting MySQL with this cnf enables Network, but disables the Connection for iRedMail
and I'm not able to connect to the Databases (not even root)
excerpts from <HOSTNAME>.err
started without the customized my.cnf (it's not present in /etc/)
All iRedMail related Programs, Webinterfaces work Normal
130221 01:12:08 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
130221 1:12:08 InnoDB: The InnoDB memory heap is disabled
130221 1:12:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130221 1:12:08 InnoDB: Compressed tables use zlib 1.2.7
130221 1:12:08 InnoDB: Initializing buffer pool, size = 128.0M
130221 1:12:08 InnoDB: Completed initialization of buffer pool
130221 1:12:09 InnoDB: highest supported file format is Barracuda.
130221 1:12:09 InnoDB: Waiting for the background threads to start
130221 1:12:10 InnoDB: 1.1.8 started; log sequence number 1869265
130221 1:12:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130221 1:12:10 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130221 1:12:10 [Note] Server socket created on IP: '0.0.0.0'.
130221 1:12:10 [Note] Event Scheduler: Loaded 0 events
130221 1:12:10 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.28' socket: '/tmp/mysql.sock' port: 3306 Source distribution
130221 1:27:07 [Note] /usr/local/libexec/mysqld: Normal shutdown
130221 1:27:07 [Note] Event Scheduler: Purging the queue. 0 events
130221 1:27:09 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 2 user: 'vmail'
130221 1:27:09 InnoDB: Starting shutdown...
130221 1:27:10 InnoDB: Shutdown completed; log sequence number 1890986
130221 1:27:10 [Note] /usr/local/libexec/mysqld: Shutdown complete
130221 01:27:10 mysqld_safe mysqld from pid file /var/db/mysql/BSDTest.digi-lan.local.pid ended
started with the customized my.cnf (it's present in /etc/)
130221 01:49:52 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
130221 1:49:52 InnoDB: The InnoDB memory heap is disabled
130221 1:49:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130221 1:49:52 InnoDB: Compressed tables use zlib 1.2.7
130221 1:49:52 InnoDB: Initializing buffer pool, size = 256.0M
130221 1:49:52 InnoDB: Completed initialization of buffer pool
130221 1:49:52 InnoDB: highest supported file format is Barracuda.
130221 1:49:53 InnoDB: Waiting for the background threads to start
130221 1:49:54 InnoDB: 1.1.8 started; log sequence number 1893175
130221 1:49:54 [Note] Server hostname (bind-address): '192.168.1.202'; port: 3306
130221 1:49:54 [Note] - '192.168.1.202' resolves to '192.168.1.202';
130221 1:49:54 [Note] Server socket created on IP: '192.168.1.202'.
130221 1:49:54 [Note] Event Scheduler: Loaded 0 events
130221 1:49:54 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.28-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
130221 1:57:25 [Note] /usr/local/libexec/mysqld: Normal shutdown
130221 1:57:25 [Note] Event Scheduler: Purging the queue. 0 events
130221 1:57:25 InnoDB: Starting shutdown...
130221 1:57:26 InnoDB: Shutdown completed; log sequence number 1893175
130221 1:57:26 [Note] /usr/local/libexec/mysqld: Shutdown complete
130221 01:57:26 mysqld_safe mysqld from pid file /var/db/mysql/BSDTest.digi-lan.local.pid ended
According to the Errorlog all is same except the binding of an IP Adress
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.