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: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 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: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 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: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 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
  #7  
Old 12th November 2008, 03:09
DrmCtchr DrmCtchr is offline
Junior Member
 
Join Date: Nov 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have the same problem it seems due to the fact that isp_isp_reseller doesn't seem to contain anything. I have noticed that all the historical backups of sysdb all contain this instead of a list of resellers:

Code:
LOCK TABLES `isp_isp_reseller` WRITE;
/*!40000 ALTER TABLE `isp_isp_reseller` DISABLE KEYS */;
/*!40000 ALTER TABLE `isp_isp_reseller` ENABLE KEYS */;
UNLOCK TABLES;
I'm pretty sure there should be at least one insert between the comments, right?

I'm not really sure how to recreate my resellers. If someone can help me script a reseller recovery perl script or at least point me in the right direction of where I can get the reseller data from and a proper way to reinsert it into the database.. It would be most kind.

Thank you all in advance,

David.
Reply With Quote
  #8  
Old 12th November 2008, 04:01
DrmCtchr DrmCtchr is offline
Junior Member
 
Join Date: Nov 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Obviously, I cant get ALL the data from other places in the database. But if I could at least recreate their record in isp_isp_reseller then I could login as the administrator and manually edit the field info in the UI. Luckily for me there wasn't very many resellers.
D
Reply With Quote
  #9  
Old 26th March 2009, 00:03
rdtech rdtech is offline
Member
 
Join Date: Mar 2008
Posts: 74
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm getting an error with ispconfig. Everything worked fine. I logged in and then while in the systems area, it kicked me off. Now I can't log in at all. I've tried the other account with no luck.

I logged into phpmyadmin and changed the password but it still doest not work. Any idea
Falk?

Till?

http://domain:81/login.php?err=

I've tried restarting the server as well. Theres a problem somewhere but I dont' know where. It doesnt take to me into the back in. If I put in a fake uname and password, then it takes me to an error 101 page
Reply With Quote
  #10  
Old 26th March 2009, 18:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
 
Default

Please check if the MySQL details are correct in /home/admispconfig/ispconfig/lib/config.inc.php.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
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 17:32.


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