Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th May 2007, 20:13
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default Reseller can't login

Hello to all,

I have this strange problem:
One of the resellers can't login to his account anymore. He used to be able to do that, but all the sudden he can't.
I changed his username and password, and the problem persists. I also tried to login with the new username and password, and ISPConfig rejects the credentials.
What could be wrong?

P.S. Maybe important: this guy has two reseller account and somehow the usernames for both were the same.
Reply With Quote
Sponsored Links
  #2  
Old 18th May 2007, 09:24
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,977
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

Is the user account listed correctly in the database table sys_user ? Or is it listed twice? Then change one of the usernames in this table.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 18th May 2007, 09:55
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default

Currently the account username is different, but still, he can't login. It is listed in the database table sys_user. With the same other attributes as this user's other reseller account.

Maybe I could create another reseller, then a user for him and move all websites to the new user?
Reply With Quote
  #4  
Old 18th May 2007, 10:02
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,977
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

Quote:
Originally Posted by smartcall
Maybe I could create another reseller, then a user for him and move all websites to the new user?
This will work of course, but i hope we will find another solution.

Please edit the user entry in the sys_user table and set a new password with e.g. phpmyadmin. The password is md5 encrypted and stored in the "passwort" column.

A SQL statement like this should work:

Code:
update sys_user set passwort = md5('newpassword') WHERE username = 'resellerusername';
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 18th May 2007, 10:14
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default

Thanks.

That solved the problem. Strange is why this didn't work from thr frontend?
Reply With Quote
  #6  
Old 18th May 2007, 10:22
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,977
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

Quote:
Originally Posted by smartcall
That solved the problem. Strange is why this didn't work from thr frontend?
It might be that the connection between reseller and cp user is somewhat broken. Please check if the "doc_id" of the user from the table sys_user is correct in the column reseller_userid in the table isp_isp_reseller for this reseller.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
Demo login not working for Reseller and Customer openairhoster General 1 23rd April 2007 09:40
Unable to authenticate to SMTP server ashkev Installation/Configuration 15 6th February 2007 17:46
kann keine mails empfangen odin1 Installation/Configuration 5 6th July 2006 12:13
Details on problem /mailuser login and more (long) linutzy Installation/Configuration 11 15th February 2006 18:45
Total Frustration-HELP palkat Installation/Configuration 17 3rd September 2005 17:28


All times are GMT +2. The time now is 07:34.


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