Hi, be sure that that the data files directory is owned (or writeable) by the mysql user /var/mysql
If that does not help, could you do a svcs -x Regards, Jan S Martin MC Brown wrote: > Hi, > > Yes, I see the same problem on a brand new install. > > I've CC'd myself on this message (mc at mysql.com), I'll investigate > further in the morning. > > MC > > On 11 Feb 2008, at 12:05, Seema Alevoor wrote: > > >> Can anyone help ? >> This was posted in BOSUG forum. >> >> Note: Avinash is not in the webstack-discuss alias. >> >> >> Thanks, >> Seema. >> >> -------- Original Message -------- >> Subject: Re: [ug-bosug] problems with mysql database server >> Date: Mon, 11 Feb 2008 17:14:26 +0530 >> From: Avinash Joshi <avinashtjoshi at gmail.com> >> To: Mayuresh Nirhali <Mayuresh.Nirhali at Sun.COM> >> CC: Open Solaris : BOSUG <ug-bosug at opensolaris.org> >> References: <3af7c1a80802100355u4802eb19u74965125287fe894 at mail.gmail.com >> >>> <47AFBEA0.2000501 at Sun.COM> <3af7c1a80802110332x16096fcfpbb17d7c0b1cf9ad8 >>> at mail.gmail.com >>> <47B0333E.3050205 at Sun.COM> >>> >> I tried that before...... >> >> Just to confirm it, i tried it again. Still the problem persists. >> >> # svcs mysql >> STATE STIME FMRI >> maintenance 17:13:05 svc:/application/database/mysql:version_50 >> # >> >> On Feb 11, 2008 5:06 PM, Mayuresh Nirhali <Mayuresh.Nirhali at sun.com> >> wrote: >> >>> You have hit http://monaco.sfbay.sun.com/detail.jsf?cr=6638783! >>> >>> As a workaround, create a new user, mysql >>> Do following, >>> >>> % su - >>> % cd /var >>> % mkdir mysql >>> % /usr/sbin/useradd -g mysql -d /var/mysql mysql >>> % chown mysql mysql >>> >>> svcadm disable <mysql> >>> svcadm enable <mysql> >>> >>> see the thread below for more info, >>> http://www.opensolaris.org/jive/thread.jspa?messageID=184154𬽚 >>> >>> Mayuresh >>> >>> >>> Avinash Joshi wrote: >>> >>>> Here is the o/p: >>>> >>>> bash-3.2$ cat /var/svc/log/application-database-mysql:version_50.log >>>> [ Jan 19 15:48:38 Disabled. ] >>>> [ Jan 19 15:48:38 Rereading configuration. ] >>>> [ Jan 20 00:04:24 Rereading configuration. ] >>>> [ Jan 20 00:05:15 Enabled. ] >>>> [ Jan 20 00:05:15 Executing start method ("/lib/svc/method/mysql >>>> start"). ] >>>> svc.startd could not set context for method: chdir: No such file >>>> or directory >>>> [ Jan 20 00:05:15 Method "start" exited with status 96. ] >>>> [ Jan 20 00:09:19 Leaving maintenance because disable requested. ] >>>> [ Jan 20 00:09:19 Disabled. ] >>>> [ Jan 20 00:09:22 Enabled. ] >>>> [ Jan 20 00:09:22 Executing start method ("/lib/svc/method/mysql >>>> start"). ] >>>> svc.startd could not set context for method: chdir: No such file >>>> or directory >>>> [ Jan 20 00:09:22 Method "start" exited with status 96. ] >>>> [ Jan 20 00:11:06 Leaving maintenance because disable requested. ] >>>> [ Jan 20 00:11:06 Disabled. ] >>>> [ Jan 26 11:08:10 Rereading configuration. ] >>>> [ Jan 26 11:08:22 Enabled. ] >>>> [ Jan 26 11:08:22 Executing start method ("/lib/svc/method/mysql >>>> start"). ] >>>> svc.startd could not set context for method: chdir: No such file >>>> or directory >>>> [ Jan 26 11:08:22 Method "start" exited with status 96. ] >>>> [ Jan 26 11:09:36 Leaving maintenance because disable requested. ] >>>> [ Jan 26 11:09:36 Disabled. ] >>>> [ Feb 10 17:04:45 Rereading configuration. ] >>>> [ Feb 10 17:05:38 Enabled. ] >>>> [ Feb 10 17:05:38 Executing start method ("/lib/svc/method/mysql >>>> start"). ] >>>> svc.startd could not set context for method: chdir: No such file >>>> or directory >>>> [ Feb 10 17:05:38 Method "start" exited with status 96. ] >>>> [ Feb 10 17:07:03 Leaving maintenance because disable requested. ] >>>> [ Feb 10 17:07:03 Disabled. ] >>>> [ Feb 10 17:07:06 Enabled. ] >>>> [ Feb 10 17:07:07 Executing start method ("/lib/svc/method/mysql >>>> start"). ] >>>> svc.startd could not set context for method: chdir: No such file >>>> or directory >>>> [ Feb 10 17:07:07 Method "start" exited with status 96. ] >>>> [ Feb 10 19:57:40 Leaving maintenance because disable requested. ] >>>> [ Feb 10 19:58:40 Disabled. ] >>>> [ Feb 11 16:49:42 Executing start method ("/lib/svc/method/mysql >>>> start"). ] >>>> svc.startd could not set context for method: chdir: No such file >>>> or directory >>>> [ Feb 11 16:49:42 Method "start" exited with status 96. ] >>>> [ Feb 11 16:55:47 Leaving maintenance because disable requested. ] >>>> [ Feb 11 16:55:48 Disabled. ] >>>> [ Feb 11 16:57:24 Executing start method ("/lib/svc/method/mysql >>>> start"). ] >>>> svc.startd could not set context for method: chdir: No such file >>>> or directory >>>> [ Feb 11 16:57:25 Method "start" exited with status 96. ] >>>> >>>> On Feb 11, 2008 8:48 AM, Mayuresh Nirhali >>>> <Mayuresh.Nirhali at sun.com> wrote: >>>> >>>> >>>>> What does the log say ?? >>>>> >>>>> /var/svc/log/application-database-mysql:version_50.log >>>>> >>>>> Mayuresh >>>>> >>>>> >>>>> Avinash Joshi wrote: >>>>> >>>>> >>>>>> Hi all. >>>>>> >>>>>> I got a problem here. >>>>>> >>>>>> I want to use the mysql database. >>>>>> I initialized the A.M.P server. The apache server is working >>>>>> fine but >>>>>> I'am having problems in in enabling the mysql databases... >>>>>> >>>>>> Can you please help me??? >>>>>> >>>>>> PS: I am using build 79 >>>>>> >>>>>> bash-3.2$ svcs -v mysql >>>>>> STATE NSTATE STIME CTID FMRI >>>>>> maintenance - 17:07:07 - >>>>>> svc:/application/database/mysql:version_50 >>>>>> bash-3.2$ svcadm enable mysql >>>>>> bash-3.2$ svcs -v mysql >>>>>> STATE NSTATE STIME CTID FMRI >>>>>> maintenance - 17:07:07 - >>>>>> svc:/application/database/mysql:version_50 >>>>>> bash-3.2$ >>>>>> >>>>>> >>>>>> >>>>>> >>>> >>>> >>>> >>> >> >> -- >> Thanks & Regards, >> Avinash Joshi >> Blog: http://avinashtjoshi.wordpress.com/ >> Site: http://avinashtjoshi.googlepages.com/ >> _______________________________________________ >> ug-bosug mailing list >> List-Unsubscribe: mailto:ug-bosug-unsubscribe at opensolaris.org >> List-Owner: mailto:ug-bosug-owner at opensolaris.org >> List-Archives: http://www.opensolaris.org/jive/forum.jspa?forumID=54 >> _______________________________________________ >> >> >> webstack-discuss mailing list >> webstack-discuss at opensolaris.org >> http://mail.opensolaris.org/mailman/listinfo/webstack-discuss >> >> > > -- > Martin 'MC' Brown, mc at mcslp.com > Everything MCslp: http://planet.mcslp.com > > > > _______________________________________________ > > > webstack-discuss mailing list > webstack-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/webstack-discuss >
