DSL MySQL not loading

[LRFLEW]

When I try to startup XAMPP, the following message appears:

Code: Select all

XAMPP: Starting Apache with SSL...
XAMPP: Starting MySQL...
XAMPP: Couldn't start MySQL!
XAMPP: Starting ProFTPD...
XAMPP for Linux started.

Why won't MySQL start? If you need any info or logs, please ask. I'm not sure where the XAMPP logs are, otherwise I'd list it.

[Sharley]

Do you have another instance of MySQL running?

If so stop that instance and try and start the XAMPP MySQL instance again.

[LRFLEW]

Do you have another instance of MySQL running?

If so stop that instance and try and start the XAMPP MySQL instance again.

I don't think I have another instance of MySQL (I am on a clean install of DSL; I know DSL comes with sqlite, but I don't know if it would conflict or how to turn it off).

[Sharley]

MySQL in XAMPP uses port 3306 so check if something else is using this port - netstat may help.

MySQL in XAMPP can't share ports and so if it is already in use it can't load MySQL.

[LRFLEW]

MySQL in XAMPP uses port 3306 so check if something else is using this port - netstat may help.

MySQL in XAMPP can't share ports and so if it is already in use it can't load MySQL.

I checked netstat as you suggested, but nothing was using 3306, but I did find something else...

I FINALLY found MySQL's log, and it isn't pretty (note, I'm running DLS in Virtual Box on my main computer to figure out how to set it up before I do the real thing with my computer , so I am retyping the log and it may have spelling and syntax errors).

Code: Select all

110411 17:19:30 mysql_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
110411 17:19:30 [Note] Plugin 'FEDERATED' is disabled.
º/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm (errno:13)
110411 17:19:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
110411 17:19:30  InnoDB: Initializing buffer pool, size = 16.0M
110411 17:19:30  InnoDB: Completed initialization of buffer pool
110411 17:19:30  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld doesn't not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
110411 17:19:30 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/box.pid ended

It seems that the root of the problem comes from InnoDB not having access to the system files, but if I'm running as super user, how can this be.

This is way too confusing


EDIT: this problem may be very deep rooted in the fact that DSL is so light by missing things that you wouldn't expect it to (it didn't even have GCC :O). Even Cherokee didn't like it (not only was MySQL not working (according to the install), the entire system didn't work). If you can figure out what's wrong from this, tell me. Otherwise, I learned my lesson: never use DSL as a webserver (now I'm glad I used VirtualBox ).

[Sharley]

See if there is any help in these advanced forum search results using InnoDB as the keyword in the English XAMPP for LINUX forum.