David Van Couvering wrote:
> 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.
>
>
Not sure (I did not use coolstack but only SXDE dev builds), but did you
create the user/group mysql that is used to run the processes?
> 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?
>
http://www.netbeans.org/kb/60/ide/mysql.html
works for me, along with regular JDBC apis with the correct db url.
With SXDE b79, everything will be simple...
Ludo
> Thanks,
>
> David
>
>
