DSL MySQL not loading

Problems with the Linux version of XAMPP, questions, comments, and anything related.

DSL MySQL not loading

Postby LRFLEW » 11. April 2011 18:23

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.
LRFLEW
 
Posts: 3
Joined: 11. April 2011 18:17

Re: DSL MySQL not loading

Postby Sharley » 12. April 2011 03:06

Do you have another instance of MySQL running?

If so stop that instance and try and start the XAMPP MySQL instance again.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: DSL MySQL not loading

Postby LRFLEW » 12. April 2011 03:30

Sharley wrote: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).
LRFLEW
 
Posts: 3
Joined: 11. April 2011 18:17

Re: DSL MySQL not loading

Postby Sharley » 12. April 2011 04:58

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.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: DSL MySQL not loading

Postby LRFLEW » 12. April 2011 18:50

Sharley wrote: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 :P (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 :P, 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 :P


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 :P (now I'm glad I used VirtualBox :)).
LRFLEW
 
Posts: 3
Joined: 11. April 2011 18:17

Re: DSL MySQL not loading

Postby Sharley » 13. April 2011 02:25

See if there is any help in these advanced forum search results using InnoDB as the keyword in the English XAMPP for LINUX forum.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 6 guests