#1  
Old 6th March 2013, 16:49
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Default Database Remote Access issue

Hi Guys,

if I try to connect my pc by a simple database client from a remote location to a database previously configured in ISPConfig with the Remote Access option enabled I get an error message:

SQLSTATE[28000] [1045] Access denied for user 'myuser_adm'@'webserver.mydomain.com' (using password: YES)

If I try to delete in the textbox "Remote Access IPs" the automatic IP set, the IP remains the same.

How have I to solve it?

thanks
Reply With Quote
Sponsored Links
  #2  
Old 6th March 2013, 17:20
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Default

Hi Guys,

I have found a bug in ISPConfig.
Updating ISPConfig to the last version of the software I have noticed that the database users have the password hidden with the MD5 method.

The problem are the old users who have a clear password!

The upgrade doesn't update the clear passwords to the MD5 password.

Another bug is the check of the Remote Access Control. ISPConfig doesn't update the preferences set in the administration control panel.

I cannot share the user database credencials but I can tell you that some of these credencials in the web_database_user have not a password encrypted.

Please this is really important to solve.

thanks
Reply With Quote
  #3  
Old 6th March 2013, 17:27
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,804
Thanks: 840
Thanked 5,614 Times in 4,425 Posts
Default

Quote:
I have found a bug in ISPConfig.
Thats no bug and nothing that requires a change at all. The encryption has been changed and it is implemented in a way that does not require to alter any old records. We just decided to save passwords in encrypted form for mysql users now. Just for your info,Plesk stores them still in plaintext.

Quote:
Another bug is the check of the Remote Access Control. ISPConfig doesn't update the preferences set in the administration control panel.
Which remote access control? You mean remote users in the System module? If I edit and save them, changes are saved fine on my server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.

Last edited by till; 6th March 2013 at 17:30.
Reply With Quote
  #4  
Old 6th March 2013, 17:32
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Default

I am talking about the bug that doesn't update the old plaintext password to the new md5 password. ISPConfig has created a little bit confusing in the records of the mysql table mentioned above.

Yes, remote connection checkbox preference is not saved.

thanks
Reply With Quote
  #5  
Old 6th March 2013, 18:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,804
Thanks: 840
Thanked 5,614 Times in 4,425 Posts
Default

Quote:
I am talking about the bug that doesn't update the old plaintext password to the new md5 password.
Thst intended and not a bug. I explained that already.

Quote:
ISPConfig has created a little bit confusing in the records of the mysql table mentioned above.
No. Its exactly as it should be.

Quote:
Yes, remote connection checkbox preference is not saved.
You still did not explain about which form you are talking here.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 6th March 2013, 18:25
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Default

If this promiscous credencials methods are not the problem why deleting and recreating the user attached to the database solve the problem?

Code:
You still did not explain about which form you are talking here.
Go to the administration panel > Web sites > Database > Select a database > Remote IPs checkbox
Reply With Quote
  #7  
Old 12th March 2013, 13:41
rickyaliasgar rickyaliasgar is offline
Junior Member
 
Join Date: Jan 2013
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
Default

Try remotely accessing your computer using remote support tool such as logmeinrescue, gosupportnow, GoToMyPC etc. and check whether it works or no.
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
Mysql remote access - ERROR 1045 (28000): Access denied for user spazio Installation/Configuration 3 18th September 2012 14:52
howto - disable default remote access to sql, enable webserver access automatically radim_h Tips/Tricks/Mods 3 28th August 2012 14:29
limit FTP access by specific Remote Access IPs for specified ftpuser prisfeo Installation/Configuration 3 9th February 2010 11:06
Can't Remote Access mysql 4.1 dedibox Installation/Configuration 2 24th August 2006 11:32
configuring IPTABLES firewall adityavpratap HOWTO-Related Questions 9 27th May 2006 22:42


All times are GMT +2. The time now is 11:17.


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