I don't see why this issue cannot be discussed within WebStack alias so that other smart minds can contribute as well.
Ritu Kamboj wrote: > Hi Latha, > > You do not have to register the smf ...the package will do that for > you... > > The first step should be to verify if MySQL user exist ...so the > sequence would be: > > 1) Check if mysql user belonging to mysql group exist > > 2) If the user does not exist, create one. > > 3) Make mysql user the owner of database directory Ritu - Is some one following it up to get this user / group created by default in time for SXDE 01/08 release ? This way, user can start MySQL server by simply enabling the SMF service. This will go a long way towards improving the user experience. > > 4) Enable the MySQL smf service > > 5) check the status of MySQL service to ensure that server started > successfully > > > Here is the snippet from man page for quick reference: > A user "mysql" belonging to group "mysql" is required for starting > MySQL. If such a user does not exist, create one by issuing the > following command: > > .br > example% /usr/sbin/groupadd mysql > .br > example% /usr/sbin/useradd -g mysql mysql > > Make user "mysql" the owner of database directory by issuing the > following command: > > .br > example%chown -R mysql:mysql /var/mysql > > Enable the MySQL service by issuing the following command: > > .br > example% svcadm enable mysql:version_50 > > > The state of the service instance should change to "online", and the > database server should be started. You can verify the same by issuing > the following command: > > .br > example% svcs mysql > .br > STATE STIME FMRI > .br > online 14:30:08 svc:/application/database/mysql:version_50 > > > > Regards, > Ritu > > Latha K wrote: > >> Hi, >> >> I have posted the revised draft at >> http://iecweb.india/iec/pub/Main/Webstack/webstack-gsg.pdf >> >> I have addressed the comments received from Ritu on the MySQL section. >> Added PHP information received from Sriram. >> >> This document is still a work in progress. If you have any comments >> on the sections, please send them to me. >> >> Thanks, >> -Latha > >
