The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mod_ruid2 disabled remote mySQL access

Discussion in 'Database Discussions' started by PelleroWEB, Jun 4, 2015.

  1. PelleroWEB

    PelleroWEB Member

    Joined:
    Feb 13, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    As we use a Mod_ruid2 and Cagef to increase a security level, one downside we noticed is that users cant access their mySQL databases remotely anymore.

    Are there any workaround for this? I've been looking around but couldn't find any usable info about this.

    Hope someone, or cPanel staff, can shed some light on this.

    Cheers.
     
  2. cPJacob

    cPJacob cPanel Product Owner
    Staff Member

    Joined:
    May 2, 2014
    Messages:
    510
    Likes Received:
    66
    Trophy Points:
    28
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Hello,
    This is odd. I'm not sure how CageFS and mod_ruid2 would prevent remote MySQL access. Remote MySQL access is usually done over port 3306, which CageFS nor mod_ruid2 should prevent access to. Could you elaborate a bit on how they are being blocked, or prevented from accessing MySQL remotely?
     
    PelleroWEB likes this.
  3. PelleroWEB

    PelleroWEB Member

    Joined:
    Feb 13, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Our server admin claim that that both mod_userdir is disabled due to security reasons AND because of mod_ruid2 remote mySQL access is not possible. Unless disabled mod_ruid2 and recompiling EasyApache?

    Not sure what is going on, thus I would need to know if there are any native conflicts for such setup?

    In other words, I need both mod_ruid2 + mod_userdir + remote mySQL access.

    I will appreciate if you could elaborate over this.

    Cheers.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    This mod_userdir module allows visitors to access a site on your server with the example.com/~account syntax. This method to access websites causes a conflict with the mod_ruid2 Apache module. This is documented at:

    Apache Mod_Ruid2

    Thank you.
     
    PelleroWEB likes this.
  5. PelleroWEB

    PelleroWEB Member

    Joined:
    Feb 13, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I understand, thanks. Is that fact preventing a remote mySQL access as well? Please let me know.

    Cheers.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you provide more information on how it's blocking access to the remote MySQL server? For instance, does it work with Mod_Ruid2 is disabled? What error message do you receive?

    Thank you.
     
  7. PelleroWEB

    PelleroWEB Member

    Joined:
    Feb 13, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Well, yes, simply when Mod_Ruid2 is enabled it is impossible to establish a remote MySQL connection, that's all. I have been told that only disabling Mod_Ruid2 and recompiling Apache would solve that problem.

    But the problem is that we need to have both of them.

    Question 2: Is Mod_Ruid2 incompatibility with mod_userdir on the architecture level meaning there will be no *FIX* for that in the future?

    Cheers.
     
  8. cPJacob

    cPJacob cPanel Product Owner
    Staff Member

    Joined:
    May 2, 2014
    Messages:
    510
    Likes Received:
    66
    Trophy Points:
    28
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Hello,

    We need more information than you've provided regarding mod_ruid2 blocking MySQL. Please provide more info than 'It does not work'.

    In regards to mod_userdir, this is correct, mod_ruid2 does not work mod_userdir at this time. We have no plans currently to look into if it's possible to get this working properly.
     
    PelleroWEB likes this.
  9. PelleroWEB

    PelleroWEB Member

    Joined:
    Feb 13, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Remote MySQL connection can not be established. Remote software just return following error:

    "Can't connect to MySQL on yourdomainxxxxx.com"

    Our sys admin confirmed that it should be so as we a re using mod_ruid2.

    I would appreciate if someone could help. If you need a test account or server access, please let me know and I will PM necessary credentials.

    Cheers.
     
  10. cPJacob

    cPJacob cPanel Product Owner
    Staff Member

    Joined:
    May 2, 2014
    Messages:
    510
    Likes Received:
    66
    Trophy Points:
    28
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Hello,

    Can you put in a ticket on this? Our support team can assist you a lot quicker then we could in the forums. Please use the link in my signature and we'll get you taken care of!
     
    PelleroWEB likes this.
  11. PelleroWEB

    PelleroWEB Member

    Joined:
    Feb 13, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Done :)
     
  12. PelleroWEB

    PelleroWEB Member

    Joined:
    Feb 13, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
  13. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  14. PelleroWEB

    PelleroWEB Member

    Joined:
    Feb 13, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Sure, it was basically a question of allowing port 3306 in server firewall + restrict the access by the IP in the host access control. Info here: https://documentation.cpanel.net/display/ALD/Host+Access+Control

    Also following info shall be used for allowing port 3306:

    http://www.cyberciti.biz/tips/linux-iptables-18-allow-mysql-server-incoming-request.html

    Cheers.
     

Share This Page