Database Server Setup to allow connection from the instruments » History » Revision 2
Revision 1 (Anchi Cheng, 01/06/2014 11:28 AM) → Revision 2/16 (Anchi Cheng, 01/06/2014 01:28 PM)
h1. Database Server Setup to allow connection from the instruments You need to do is even if If you have used autoinstaller so that computers controlling the instruments (microscope/camera) can connect to the set up database h2. Bind mysqld to its IP address to allow tcp connection to it. h3. Edit /etc/my.cnf search for *skip-networking* and make sure it is commented out like this: <pre> #skip-networking </pre> Add the address the database is bound to after that line <pre> #skip-networking bind-address=your.ip.address.number </pre> h3. Restart mysqld For CentOS, Fedora <pre> sudo /etc/init.d/mysqld restart </pre> or <pre> sudo /sbin/service mysqld restart </pre> h3. 10 Create remote user Create and grant privileges to the usr_object for the databases on the hosts involved. server manually, you should have done these steps. See MySQL Reference Manual for details. You can set hosts on a particular subnet by only specify the network number portion such as '192.168' and use wild card for the host number portion to give '192.168.%.%' as the global host allowing connection. If appropriate, you can also use domaian name with wild care i.e., '%.mydomain.edu' At the mysql prompt execute the following commands: <pre> CREATE USER usr_object@'192.168.%.%' IDENTIFIED BY 'YOUR PASSWORD'; GRANT ALTER, CREATE, INSERT, SELECT, UPDATE ON leginondb.* TO usr_object@'192.168.%.%'; GRANT ALTER, CREATE, INSERT, SELECT, UPDATE ON projectdb.* TO usr_object@'192.168.%.%'; </pre> h3. Change localhost database user to usr_object if autoinstaller was used. Autoinstaller does not create usr_object user on the localhost but use root user include setting up for database connection. You may want global access. Therefore, you have to make change at this time. do it now. At the mysql prompt execute the following commands: <pre> CREATE USER usr_object@'localhost' IDENTIFIED BY 'YOUR PASSWORD'; GRANT ALTER, CREATE, INSERT, SELECT, UPDATE ON leginondb.* TO usr_object@'localhost'; GRANT ALTER, CREATE, INSERT, SELECT, UPDATE ON projectdb.* TO usr_object@'localhost'; </pre> ______ [[Web Server Installation|< Web Server Installation]] | [[Additional Database Server Setup after Web Server Installation| Additional Database Server Setup >]] ______