Changes

From SME Server
Jump to navigationJump to search

Template Tutorial (view source)

Revision as of 03:42, 5 March 2010

2,213 bytes added ,  03:42, 5 March 2010
added mysql section
Line 88: Line 88:     
Check your change is working
 
Check your change is working
 +
 +
====mysql====
 +
 +
Q) Is slaving SME's MySQL server for replication possible?  Is binary logging possible?  If so, do you edit the my.cnf file or some file to initiate binary logging?
 +
 +
A) First step is to go to the mysql web site and research what you want to do, see http://dev.mysql.com/doc/
 +
 +
When you find out what needs to be added to the /etc/my.cnf file, you can then make appropriate changes via a sme server custom template.
 +
 +
Examine the template fragments in /etc/e-smith/templates/etc/my.cnf
 +
 +
Determine which fragment your revised code needs to go into. See the 000readme fragment for info.
 +
 +
If no fragment is suitable you will need to create a new fragment. In the following example replace 005mysql with the appropriate existing or new fragment name.
 +
 +
Let's say you wish to modify the /etc/e-smith/templates/etc/my.cnf/005mysqld
 +
 +
Copy the existing template to the custom template tree (or create a new custom template)
 +
cp /etc/e-smith/templates/etc/my.cnf/005mysqld /etc/e-smith/templates-custom/etc/my.cnf/005mysqld
 +
Edit and make your required additions & changes. This is where you add the changes determined from the mysql documentation.
 +
pico -w /etc/e-smith/templates-custom/etc/my.cnf/005mysqld
 +
Save and exit
 +
Ctrl o
 +
Ctrl x
 +
Expand template and restart mysqld
 +
expand-template /etc/my.cnf
 +
sv t /service/mysqld
 +
Check status of the service
 +
sv s /service/mysqld
 +
 +
In this particular example there appears to be a requirement to share the mysql databases with LAN (local) or WAN (external) users. To achieve this you may need to change access permissions to your mysql databases, refer
 +
http://wiki.contribs.org/SME_Server:Documentation:FAQ#Access_MySQL_from_the_local_network
 +
http://wiki.contribs.org/SME_Server:Documentation:FAQ#Access_MySQL_from_a_remote_network
 +
http://wiki.contribs.org/SME_Server:Documentation:FAQ#Create_MySQL_user.28s.29_with_access_from_other_computers
 +
 +
 +
Check your changes are working
 +
 +
Removal
 +
To remove these custom changes you delete the custom template, expand the template and then restart the service, as follows
 +
rm /etc/e-smith/templates-custom/etc/my.cnf/005mysqld
 +
expand-template /etc/my.cnf
 +
sv t /service/mysqld
 +
Check status of the service
 +
sv s /service/mysqld
    
====php.ini====
 
====php.ini====
RayMitchell
624

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/14335"

Navigation menu