Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 25th August 2011, 15:42
gawry gawry is offline
Junior Member
 
Join Date: Jun 2010
Posts: 23
Thanks: 3
Thanked 1 Time in 1 Post
Default

I'm trying to run cakephp with ispconfig but with no success.

Right now I have two problems.

I'm getting a 500 Internal server error when using the .htaccess that Turbanator mentioned. I was able to make it work setting a different DocumentRoot.

I was writing this and then i tested again. DocumentRoot works for the front page but everything else seems to get a 404.

And my database server is refusing external connections. (I have a separate mysql server). Is there a way to make ISPConfig make the mysql accept connections from the web server by default?
Reply With Quote
Sponsored Links
  #12  
Old 26th August 2011, 13:00
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Quote:
Originally Posted by gawry View Post
I'm getting a 500 Internal server error when using the .htaccess that Turbanator mentioned. I was able to make it work setting a different DocumentRoot.
Did you check Apache's error log?

Quote:
Originally Posted by gawry View Post
And my database server is refusing external connections. (I have a separate mysql server). Is there a way to make ISPConfig make the mysql accept connections from the web server by default?
Does MySQL listen on all interfaces? What's the output of
Code:
netstat -tap | grep mysql
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #13  
Old 26th August 2011, 17:04
gawry gawry is offline
Junior Member
 
Join Date: Jun 2010
Posts: 23
Thanks: 3
Thanked 1 Time in 1 Post
Default

I've solved the configuration problem. I'm not really sure of what happened but i've made it to work without adding the DocumentRoot.

Code:
tcp        0      0 *:mysql                 *:*                     LISTEN      11912/mysqld
Reply With Quote
  #14  
Old 26th August 2011, 19:10
gawry gawry is offline
Junior Member
 
Join Date: Jun 2010
Posts: 23
Thanks: 3
Thanked 1 Time in 1 Post
Default

I believe I was not clear. I've solved the apache configuration problem. I believe that mysql users still need to be manually allowed get access from another server.
Reply With Quote
  #15  
Old 3rd September 2011, 00:27
gawry gawry is offline
Junior Member
 
Join Date: Jun 2010
Posts: 23
Thanks: 3
Thanked 1 Time in 1 Post
Default

I have a separate server for MySQL and the databases i create in ispconfig cant be acessed from the webserver ( which is another machine )

Is there a problem in my configuration or ISPConfig does not handle proper configuration of user access in mysql databases that are located in a different server?

Last edited by gawry; 3rd September 2011 at 01:21.
Reply With Quote
  #16  
Old 3rd September 2011, 11:32
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Can you check the mysql.user table on the separate MySQL server and check if the Host column holds the correct hosts that are allowed to connect? Also, is MySQL listening on all interfaces? You can check that with
Code:
netstat -tap | grep mysql
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #17  
Old 3rd September 2011, 15:25
gawry gawry is offline
Junior Member
 
Join Date: Jun 2010
Posts: 23
Thanks: 3
Thanked 1 Time in 1 Post
Default

The funny thing is that i've added both ip's from the webserver when i was adding the mysql user. Even doing this it didn't work. It only worked when i added a wildcard( '%' ) as the host.

Code:
tcp        0      0 *:mysql                 *:*                     LISTEN      11912/mysqld    
tcp        0      0 db.domain.com:60468  web.domain.com:mysql TIME_WAIT   -
Reply With Quote
  #18  
Old 4th September 2011, 19:07
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

Quote:
Originally Posted by gawry View Post
The funny thing is that i've added both ip's from the webserver when i was adding the mysql user.
Maybe you should have used hostnames instead of IP addresses. That might be the problem. But it's good to hear that you at least got it going with wildcards.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 +2. The time now is 02:01.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.