Overclockers Australia Forums
OCAU News - Wiki - QuickLinks - Pix - Sponsors  

Go Back   Overclockers Australia Forums > Software Topics > Other Operating Systems

Notices


Sign up for a free OCAU account and this ad will go away!
Search our forums with Google:
Reply
 
Thread Tools
Old 28th April 2008, 11:49 AM   #1
MorbosuS Thread Starter
Member
 
MorbosuS's Avatar
 
Join Date: Feb 2004
Location: Co. Cork
Posts: 582
Default Issues getting MySQL to start with XAMPP

Hello
I have been unable to start MySQL using a guide like:
http://www.debianadmin.com/xampp-all...in-debian.html

I cant start anything which uses XAMP + MySQL because it cannot find the service. http://localhost/xampp status says MySQL is deactivated.

Code:
XAMPP Status
	
Component	
Status	
Hint	
	MySQL database	 DEACTIVATED 		
	PHP	 ACTIVATED 		
	Perl	 ACTIVATED 		
	Common Gateway Interface (CGI)	 ACTIVATED 		
	Server Side Includes (SSI)	 ACTIVATED
Yet when i start XAMPP this component says it is working:

Code:
/opt/lampp/lampp start
Starting XAMPP for Linux 1.6.6...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
At first i thought it was the firewall so i changed iptables:

Code:
#allow MySQL Default port:
iptables -A TRUSTED -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
However this does not seem to affect the situation.
Moreover the configuration file for mySQL in /opt/lampp/etc/my.cnf
is the same as the default configuration file.

I should be able to use a content creation program like joomla to create a database.

Code:
Pre-installation check for Joomla! 1.5.3 Production/Stable [ Vahi ] 22-April-2008 22:00 GMT:
If any of these items is not supported (marked as No) your system does not match the minimum requirements necessary. Please take the appropriate actions to correct the errors. Failure to do so could lead to your Joomla! installation not functioning correctly.
PHP Version >= 4.3.10 	Yes  
- Zlib Compression Support 	Yes  
- XML Support 	Yes  
- MySQL Support 	Yes  
MB Language is Default 	Yes  
MB String Overload Off 	Yes  
configuration.php Writable 	Yes
Code:
An Error has occurred!:

Could not connect to the database. Connector returned number: Unable to connect to the database:Could not connect to MySQL
I am assuming this problem traces back to XAMPP not starting MySQL or there is some step to be done before all of this to configure mySQL which is not mentinoned in any tutorials i have found so far.
__________________
Main System IE: AsusEEE PC, 1000h 40gb SSD, Sidux, Ubuntu, Gentoo
Back In Aus: Q6600, 8600gts, 2gb ddr2, centOS 4.6, Sidux
MorbosuS is offline   Reply With Quote

Join OCAU to remove this ad!
Old 28th April 2008, 1:46 PM   #2
MorbosuS Thread Starter
Member
 
MorbosuS's Avatar
 
Join Date: Feb 2004
Location: Co. Cork
Posts: 582
Default

update: it seems to all be related to permissions. I reinstalled XAMPP and its fine. Looking at posts on various forum all related to issues to do with permissions. I solved about 10 and still had issues starting MySQL.

update: 2 days later and the problem has not occured again since i reinstalled XAMPP. I dont know enough about what was going on to work out what was wrong however i am happy the problem cleared up.
__________________
Main System IE: AsusEEE PC, 1000h 40gb SSD, Sidux, Ubuntu, Gentoo
Back In Aus: Q6600, 8600gts, 2gb ddr2, centOS 4.6, Sidux

Last edited by MorbosuS; 30th April 2008 at 3:55 PM.
MorbosuS is offline   Reply With Quote
Reply

Bookmarks

Sign up for a free OCAU account and this ad will go away!

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +10. The time now is 11:35 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd. -
OCAU is not responsible for the content of individual messages posted by others.
Other content copyright Overclockers Australia.
OCAU is hosted by Internode!