(2012-04-14, 15:05)mcfreiz Wrote: having problems finding/editing this file. anyone have detailed instructions on a synology dms 4
Hi mcfreiz -
It's no surprise that you cant find the file... Since it doesn't exist =)
Turns out that the my.cnf file is totally optional and you will need to create your own on the Synology. Fortunately, its super easy to do, here is how:
First, enable terminal in the Synology control panel 'Control Panel -> Terminal' by checking the 'Enable SSH Service' tick box.
Now, get an application like putty so that you can SSH to the Synology.
Start Putty and connect to the NAS. Login as root and use the same password that you set-up for your admin account (its actually the root account.)
Once in, type the following commands:
Code:
cp /usr/syno/mysql/share/mysql/my-small.cnf /etc/my.cnf
vi /etc/my.cnf
This will copy a sample cnf file to the proper location and then open it in the vi text editor.
Use the arrow keys to move down about a page and a half until you see the [mysqld] section. Get the cursor on the line that says "thread_stack = 128" and type the "i" key to enter the edit mode in VI.
Hit enter to make a new line and use an arrow key to get to that line. In the blank line add the text:
skip-name-resolve
Hit escape to exit edit mode, then type:
(that is colon, w, q, and then hit enter. The colon will start the command mode and wq will write and quit VI. Hitting enter will run the command and quit VI.
If you make a mistake and VI gets weird on you, hit escape, then :q! (colon, q, exclamation point, and Enter) This will exit VI without saving. VI can be quirky for the uninitiated...
Then you need to restart MySQL, type the following:
Code:
/usr/syno/etc/rc.d/S21mysql.sh restart
If you messed up, you will probably see an error while re-starting and MySQL will just ignore the cnf file =)