MySQL and OZ 3.3.5

[omro]

Hi All,

Am trying to install MySQL on OZ 3.3.5, but it's not installing. The output is the following:

Code: [Select]

Dealing with package /mnt/cf/mysql_3.22.32-2_arm.ipk
Installing mysql (3.22.32-2) to root...
Installing mysql (3.22.32-2) to root...
Package mysql wants to install file /usr/lib/libform.so.5
    But that file is already provided by package libncurses5
Package mysql wants to install file /usr/lib/libmenu.so.5
    But that file is already provided by package libncurses5
Package mysql wants to install file /usr/lib/libpanel.so.5
    But that file is already provided by package libncurses5
Package mysql wants to install file /usr/lib/libncurses.so.5
    But that file is already provided by package libncurses5
Cannot find package mysql.
Check the spelling or perhaps run 'ipkg update'
Finished
Not entirely sure what all this means, so if anyone has any ideas, I'd appreciate it!

[lardman]

It looks like mysql comes with libncurses included (which already exists on your machine). You could use the '--force-overwrite' option which will overwrite the existing files. There may be other options (though I can't remember any off the top of my head), otherwise you'll need to alter the package itself.


Si

[omro]

I did that, thanks for the suggestion. It seemed to install fine, as did the required patch.

However, when I go to run MySQL I get the following...

Code: [Select]

# ./mysqld
./mysqld: Can't create/write to file '/dev/null' (Errcode: 13)
040912  1:23:01  ./mysqld: Can't create/write to file '/var/lib/mysql/mysqld.pid' (Errcode: 13)
040912  1:23:01  ./mysqld: Can't find file: './mysql/host.frm' (errno: 13)    
I'm a little confused as to what all this means.

I'm running OZ 3.3.5 and have used to linux-migration.org notes to transfer some of the directories to the SD card.

Thanks for any help!

[aplanas]

Uhmm Are you root?

[totaln00b]

By default, I think that mysql on the zaurus runs as "Daemon", so a quick and dirty workaround is to edit /etc/mysql/my.conf to say user=root rather than user=daemon. Then when you start mysql start with user=root too.

Note that this is fine if you use your zaurus for local stuff but a bit of a security risk if you use it as a web server for others to access.

[omro]

Seeing as it's only on my handheld and it's just to facilitate the local PHP in Apache (PHP is the only language I can program in), I can cope with the risk.

Thanks for the info, I now have PHP and MySQL happily working on OZ 3.3.5