1

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

2

Re: Where do I find the MYSQL Configuration?

Seems that I don't need this,
Adding a User with Permission from Any Host cann Access the MySQL Server without binding it to an IP Adress....
scary :-)

3

Re: Where do I find the MYSQL Configuration?

Digi-Quick wrote:

where do I find the MySQL Server Configruation?

It's /var/db/mysql/my.cnf on FreeBSD, it should be the same on PC-BSD.