Mysql : NetBeans 6.1 : OpenSolaris 2008.05

I am trying to install "glassfish - mysql bundled netbeans 6.1" on open solaris 05/08. During the installation , I got some Gtk warnings like :

(:1464): Gtk-WARNING **: Attempting to add a widget with type GtkButton to a GtkComboBoxEntry (need an instance of GtkEntry or of a subclass)

(:1464): Gtk-CRITICAL **: file gtkwidget.c: line 3236: assertion `GTK_WIDGET_ANCHORED (widget) || GTK_IS_INVISIBLE (widget)' failed

(:1464): Gtk-CRITICAL **: file gtkstyle.c: line 5879: assertion `style->depth == gdk_drawable_get_depth (window)' failed

(:1464): Gtk-CRITICAL **: file gtkstyle.c: line 5879: assertion `style->depth == gdk_drawable_get_depth (window)' failed

Anyway , during the installation of netbeans I have selected all default locations. thus mysql and glassfish were installed in my home directory.

I have tried to start mysql server with the following configuration :

[Click on the image to get larger view]

[Click on the image to get larger view]

but , after clicking 'start' I received an error like :

"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)".

Which means , Mysql server is not running at all. So , I tried to start it manually.
In terminal , I typed "mysqld_safe --user=mysql --log &" which results :

ritwik@ritwik:~$ cd mysql
ritwik@ritwik:~/mysql$ bin/mysqld_safe --user=mysql --log &
[1] 764
ritwik@ritwik:~/mysql$ nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
bin/mysqld_safe[380]: /var/lib/mysql/ritwik.err: cannot create [Permission denied]
bin/mysqld_safe[388]: eval[1]: /var/lib/mysql/ritwik.err: cannot create [Permission denied]
STOPPING server from pid file /var/lib/mysql/ritwik.pid
tee: /var/lib/mysql/ritwik.err: Permission denied
080604 18:26:41 mysqld ended
tee: /var/lib/mysql/ritwik.err: Permission denied


[1]+ Exit 1 bin/mysqld_safe --user=mysql --log

From the result , I think some permission related factor is creating problems. That's why I changed permission of the above said directories as a super user.

Now "bin/mysqld_safe --user=mysql --log &" results :

ritwik@ritwik:~/mysql$ nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /export/home/ritwik/mysql/data

Thus MySql server is running and doing all desirable functions.

NetBeans 6.1 on OpenSolaris 2008.05

Open Solaris 05/2008 has an excellent feature of adding packages graphically and netbeans option is also there but I was trying to install it in the same I have done before. Because , NetBeans 6.0.1 will be installed if you execute "pkg install netbeans" or choose netbeans from package manager (IPS GUI) , but I want to install NetBeans 6.1.

During installation , I got some warnings / critical problems regarding Gtk. Those were like :

(:1464): Gtk-WARNING **: Attempting to add a widget with type GtkButton to a GtkComboBoxEntry (need an instance of GtkEntry or of a subclass)

(:1464): Gtk-CRITICAL **: file gtkwidget.c: line 3236: assertion `GTK_WIDGET_ANCHORED (widget) || GTK_IS_INVISIBLE (widget)' failed

(:1464): Gtk-CRITICAL **: file gtkstyle.c: line 5879: assertion `style->depth == gdk_drawable_get_depth (window)' failed

(:1464): Gtk-CRITICAL **: file gtkstyle.c: line 5879: assertion `style->depth == gdk_drawable_get_depth (window)' failed

otherwise everything was fine. "MySql" server was bundled with sxde 9/07 but that's not true for open solaris 05/08. so I decided to download and install MySql server. I downloaded "mysql-5.1.24-rc-solaris10-i386.pkg" and tried to install it in my system. I have used "pkgadd" command as root for installation , but at last the following error results :

## Executing postinstall script.
ERROR: 1004 Can't create file '/var/tmp/installCgaqqb/#sql2a8_1_0.frm' (errno: 13)
080603 23:51:00 [ERROR] Aborting

080603 23:51:00 [Note] /opt/mysql/mysql/bin/mysqld: Shutdown complete


Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.

and , "/opt/mysql/mysql/bin/mysqld --skip-grant &" results :

080604 0:05:33 [Warning] Can't create test file /opt/mysql/mysql/data/ritwik.lower-test
080604 0:05:33 [Warning] Can't create test file /opt/mysql/mysql/data/ritwik.lower-test
[1] 720
ritwik@ritwik:~$ 080604 0:05:33 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.

[1]+ Exit 1 /opt/mysql/mysql/bin/mysqld --skip-grant

I don't know what's the actual reason behind it.... may be the operating system is the reason.. as I was using an installer which is made for solaris 10 and I am using open solaris 05/08.

Anyway , under such circumstances I decided to install the Glassfish - Mysql bundled version of NetBeans IDE 6.1. I did it , got the same "Gtk" error during installation , otherwise everything was normal !!!!

Next : A minor problem while starting MySql server.

If you want to install Mysql in your open solaris 05/08 system , check out "web stack components" from "Open Solaris 05/2008 (part - IV)".