Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 10th September 2012, 11:24
Wisdown Wisdown is offline
Member
 
Join Date: Aug 2012
Posts: 82
Thanks: 7
Thanked 2 Times in 2 Posts
Default Setting phpmyadmin on multiserver setup

Hey guys,

Someone have an link on how to setup the phpmyadmin for the multiserver setup?

Looking around i found this post:

http://www.howtoforge.com/forums/showthread.php?t=55811

After try i get my db.server.com isnt accepting connections from my web.server.com.

Should i add 2 users like ISPConfig setup does?
I mean root@IP and root@web.server.com

Since this user need have full access on db.server.com, i would set to use the ispconfig login instead make a new one?
Reply With Quote
Sponsored Links
  #2  
Old 10th September 2012, 11:31
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,995
Thanks: 840
Thanked 5,649 Times in 4,459 Posts
Default

Quote:
Should i add 2 users like ISPConfig setup does?
I mean root@IP and root@web.server.com
Ypu can do that. Or try to add the one with the Ip first, if it does not work, change it to the hostname. Dont forget to reload mysql or flush priveliges after you changed a user.

Quote:
Since this user need have full access on db.server.com, i would set to use the ispconfig login instead make a new one?
That depends on your setup. If the db server is not the amster server, then you can reuse it. If the master server is not the db server, then create a new user as the one created for the ispconfig setup allows only access from a slave to the master and not from one slave to another.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 10th September 2012, 11:53
Wisdown Wisdown is offline
Member
 
Join Date: Aug 2012
Posts: 82
Thanks: 7
Thanked 2 Times in 2 Posts
Default

I tried adding only the IP.
Worked only for root.

But when i try log as user i get acces denied, example:

root@192.168.0.3 > OK
c1db@192.168.0.3 > Access Denied
c1db@web.server.com > Access Denied

On my setup like i did with root i will need add the users one by one?
Reply With Quote
  #4  
Old 10th September 2012, 13:59
Wisdown Wisdown is offline
Member
 
Join Date: Aug 2012
Posts: 82
Thanks: 7
Thanked 2 Times in 2 Posts
Default

Someone have the phpmyadmin working in multiserver enviroment and would share how to get this working please?

I have tried on web.server.com:

dpkg-reconfigure phpmyadmin

Then i set to connect directly on the other server: db.server.com

But when i try log seems the phpmyadmin send the login as:

username@web.server.com

And so, pop error about access denied.
There someway to rewrite the domain name inside of phpmyadmin?
I mean for try log as:

username@db.server.com (already exists since ISPConfig created by the pannel)
instead
username@web.server.com (dont exists)
Reply With Quote
  #5  
Old 10th September 2012, 14:09
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,995
Thanks: 840
Thanked 5,649 Times in 4,459 Posts
Default

Quote:
On my setup like i did with root i will need add the users one by one?
Then you might have missed to enable remote access for the user.Login to ispconfig, go to the database settings and enable remote access.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following 2 Users Say Thank You to till For This Useful Post:
HarborTech (5th February 2013), Wisdown (10th September 2012)
  #6  
Old 10th September 2012, 14:38
Wisdown Wisdown is offline
Member
 
Join Date: Aug 2012
Posts: 82
Thanks: 7
Thanked 2 Times in 2 Posts
Default

Quote:
Originally Posted by till View Post
Then you might have missed to enable remote access for the user.Login to ispconfig, go to the database settings and enable remote access.
Yeah is it.
I have checked now to enable remote access and worked pretty nice.

Since i dindt oppened the port 3306 on my firewall, i dindt worry about someone try bruteforce attacks on my db.server.com right?
Reply With Quote
  #7  
Old 10th September 2012, 14:43
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,995
Thanks: 840
Thanked 5,649 Times in 4,459 Posts
Default

Quote:
Since i dindt oppened the port 3306 on my firewall, i dindt worry about someone try bruteforce attacks on my db.server.com right?
Yes. And even without that you wont have to worry as you can restrict the access by ip address to allow access from the web server only.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 12th September 2012, 18:52
Wisdown Wisdown is offline
Member
 
Join Date: Aug 2012
Posts: 82
Thanks: 7
Thanked 2 Times in 2 Posts
Default

Today i got sometime to back on play on my server and notice an problem with this setup.

I`m able to log as user, see database / tables, but, when i try run any SQL query i get an error:

ERROR 403 - Forbidden!

When i click to check the documentation, i get same error.

Looking on /var/log/apache2/error.log and access.log, i dindt find anything about this error.

I`m missing an include somewhere? I mean, I need add something else on path inside of ISPConfig?
Btw, my phpmyadmin is using ssl, would be this?
Reply With Quote
  #9  
Old 13th September 2012, 15:56
Wisdown Wisdown is offline
Member
 
Join Date: Aug 2012
Posts: 82
Thanks: 7
Thanked 2 Times in 2 Posts
Default

Just updating my tests, i have tried use:

# Order Deny,Allow
# Deny from All
Allow from LAN IP

Dindt worked, then:

# Order Deny,Allow
# Deny from All
Allow from All

Samething, so:

# Order Deny,Allow
# Deny from All
Allow from All
Require all granted

No luck too, my question now would be, there an way to specific the detail for log on apache?
My guess for there no info on apache logs would be because something would have be set for minimun details.
Reply With Quote
  #10  
Old 13th September 2012, 17:57
Wisdown Wisdown is offline
Member
 
Join Date: Aug 2012
Posts: 82
Thanks: 7
Thanked 2 Times in 2 Posts
 
Default

After some reasearch i found where are the real logs of apache, seems they still on this place:

/var/log/ispconfig/httpd/mydomain.com/error.log

On the log i noticed this:

Quote:
[warn] RSA server certificate wildcard CommonName ( CN ) `*.mydomain.com' does NOT match server name!?

[warn] RSA server certificate wildcard CommonName ( CN ) `*.mydomain.com' does NOT match server name!?

[error] [client XXX.XXX.XXX.XXX] ModSecurity: Access_denied with code 403 (phase 4). Pattern match "(?:\\b( ?:f( ?:tp_( ?:nb_ ) ? ) )"
[Thu Sep 13 10:33:59 2012] [error] [client XXX.XXX.XXX.XXX] ModSecurity: Access denied with code 403 ( phase 4 ) . Pattern match "( ?:\\b ( ?:f ( ?:tp_( ?:nb_ ) ?f? ( ?:ge|pu ) t|get ( ?:s?s|c ) |scanf|write|open|read ) |gz( ? ?:encod|writ)e|compress|open|read)|s( ?:ession_start|candir ) |read ( ?: ( ?:gz ) ?file|dir ) |move_uploaded_file| ( ?roc_|bz ) open ) |\\$_( ?: ( ?os|ge ) t|session ) ) \\b" at RESPONSE_BODY. [file "/etc/apache2/mod-security/modsecurity_crs_50_outbound.conf"] [line "64"] [id "970015"] [msg "PHP source code leakage"] [severity "WARNING"] [tag "LEAKAGE/SOURCE_CODE"] [hostname "mydomain.com"] [uri "/phpmyadmin/Documentation.html"] [unique_id "UFHgx8CoZAMAAG5ETOUAAAAE"]
So the * certificate is useless then?
I mean, i will need do an new certificate specific for web.server.com, for db.server.com, etc... ???
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiserver setup - Mail server installation blinden Installation/Configuration 2 16th August 2012 02:50
phpmyadmin multiserver beenfishing Installation/Configuration 4 23rd April 2012 22:45
Moving servers - multiserver setup DKLeader Installation/Configuration 2 9th January 2012 12:52
Multiserver enviroment and mysql database setup themark General 2 23rd December 2011 16:59
Setting up Bind on CentOS 5.2 simplified webservers setup newb question. tritone HOWTO-Related Questions 1 1st September 2008 09:19


All times are GMT +2. The time now is 15:42.


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