Mod_ruid2 disabled remote mySQL access

PelleroWEB

• June 04, 2015 01:37

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.

• 

  JacobPerkins

  • June 04, 2015 13:09

  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?

  0
• 

  PelleroWEB

  • June 05, 2015 05:19

  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?

  
  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.

  0
• 

  cPanelMichael

  • June 05, 2015 12:23

  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:

  0
• 

  PelleroWEB

  • June 06, 2015 09:40

  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:

  0
• 

  cPanelMichael

  • June 08, 2015 12:38

  I understand, thanks. Is that fact preventing a remote mySQL access as well? Please let me know.

  
  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.

  0
• 

  PelleroWEB

  • June 09, 2015 13:40

  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.

  
  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.

  0
• 

  JacobPerkins

  • June 09, 2015 15:26

  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.

  
  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.

  0
• 

  PelleroWEB

  • June 10, 2015 09:31

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

  
  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.

  0
• 

  JacobPerkins

  • June 10, 2015 13:39

  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!

  0
• 

  PelleroWEB

  • June 10, 2015 15:25

  Can you put in a ticket on this?

  
  Done :)

  0
• 

  PelleroWEB

  • June 10, 2015 20:03

  SOLVED

  0
• 

  cPanelMichael

  • June 10, 2015 20:11

  I am happy to see the issue is now resolved. Would you mind sharing the ticket number or updating the thread with the solution? Thank you.

  0
• 

  PelleroWEB

  • June 10, 2015 21:00

  I am happy to see the issue is now resolved. Would you mind sharing the ticket number or updating the thread with the solution?

  
  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: Cheers.

  0

Please sign in to leave a comment.