Sorry if this is a duplicate, but I didn't see my last email come
through I and I was concerned I sent it before my subscription to this
list was confirmed...
===
I seem to have gotten myself into a miserable state with MySQL. I ran
it originally with the version that comes with Solaris. Then I
downloaded the Cool Stack AMP package, and tried to start the service.
It has been no end of grief, and the service still goes into
maintenance mode.
Here is the output from the service log file:
/opt/coolstack/mysql_32bit/bin/mysqld_safe --user=mysql --datadir=/opt/coolstack
/mysql_32bit/data --pid-file=/opt/coolstack/mysql_32bit/data/solaris-davidvc.pid
[ Nov 27 07:58:34 Method "start" exited with status 0 ]
[ Nov 27 07:58:34 Stopping because all processes in service exited. ]
[ Nov 27 07:58:34 Executing stop method ("/opt/coolstack/lib/svc/method/svc-cskm
ysql32 stop") ]
[ Nov 27 07:58:34 Method "stop" exited with status 0 ]
[ Nov 27 07:58:34 Restarting too quickly, changing state to maintenance ]
Then when I look at /opt/coolstack/mysql_32bit/data/hostname.err I see
071119 20:45:13 [Warning] Can't create test file /opt/coolstack/mysql_32bit/data
/solaris-davidvc.lower-test
071119 20:45:13 [Warning] Can't create test file /opt/coolstack/mysql_32bit/data
/solaris-davidvc.lower-test
071119 20:45:13 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
071119 20:45:13 mysqld ended
Can you tell me what I should do to make sure MySQL has the right permissions?
Also, how do I set things up so I can connect to MySQL through JDBC?
Thanks,
David
--
David W. Van Couvering
http://davidvancouvering.blogspot.com
