Re: Fwd: BillMax questions -- Password Problem

["Vijay Kumar Raju" <vijay.raju.k@gmail.com>]

Hi Douglas,

i tried password(), encrypt(), md5() to encrypt the password.  ntries
and password columns are updated successfully.  still not able to get
in.

update auth set ntries=0,password=encrypt('testpass') where user='testuser';
update auth set ntries=0,password=password('testpass') where user='testuser';
update auth set ntries=0,password=md5('testpass') where user='testuser';

Luckily, i kept the backup of database.  So i just restored the "auth"
table.  that solved the above Issue.

Thanks a lot for you Help and suggestions.

Regards,
Vijay Kumar Raju.


On 9/21/06, Douglas Dalrymple <doug_te06@yahoo.com> wrote:
> Try the following select and check the state to see
> if it is 0 :
>
> select * from auth where number=5 \G
>
> The \G gives a vertical listing.
>
> Billmax uses the system crypt library function.
> If this does not generate the same value ad the
> MySQL password() function it won't work.
>
> You might also try encrypting with the encrypt()
> and md5() functions to see if that works.
>
>
>
> --- Vijay Kumar Raju <vijay.raju.k@gmail.com> wrote:
>
> > Hi Douglas,
> >
> > Thanks a lot for your help.
> >
> > yes, i replaced the values in quotes with my values.
> >
> > update auth set
> > ntries=0,password=encrypt('testpass') where
> > user='testuser';
> >
> > select number,user,password,ntries from auth where
> > user='testuser';
> >
> > +--------+---------+---------------+--------+
> > | number | user    | password      | ntries |
> > +--------+---------+---------------+--------+
> > |      5 | testuser | QPfLGtxZIhRfo |      0 |
> > +--------+---------+---------------+--------+
> > 1 row in set (0.00 sec)
> >
> > Database entry is updated sucessfully,  but no idea
> > whats going wrong...
> > Please give me an idea to overcome the above issue.
> >
> > Thanks,
> > - Vijay.
> >
> > On 9/21/06, Douglas Dalrymple <doug_te06@yahoo.com>
> > wrote:
> > > Did you replace the value in quotes with your
> > > information?
> > > Do the following select before and after to check
> > the
> > > results.
> > >
> > > select number,user,password,ntries from auth;
> > >
> > > --- Vijay Kumar Raju <vijay.raju.k@gmail.com>
> > wrote:
> > >
> > > > My Billmax SI has been blocked. since i
> > attempted to
> > > > login with wrong
> > > > password. Got a message something like "Contact
> > > > System Administrator to
> > > > unlock your account"..
> > > >
> > > > So i tried to unlock the account by running the
> > > > following Sql command :
> > > >
> > > > update auth set ntries=0,password=encrypt('your
> > > > password here') where
> > > > user='your user login name';
> > > >
> > > > Still not able to login. getting "Billmax Error
> > > > Messages - Authentication
> > > > error"
> > > >
> > > > Can anyone please help me to solve the above
> > issue
> > > > as soon as possible ?
> > > > any help would be greatly appreciated.
> > > >
> > > > Thanks,
> > > > Vijay.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > ---------- Forwarded message ----------
> > > > From: Kent Andersen <k1ent@altazip.com>
> > > > Date: Mar 18, 2006 10:22 AM
> > > > Subject: Re: BillMax questions -- Password
> > Problem
> > > > To: questions@billmax.com
> > > >
> > > >  Heres the Solution, I hope this gets archived
> > so
> > > > its now searchable
> > > > Unlocking Failed Password accounts:
> > > >
> > > > If so, running
> > > >
> > > > `/usr/local/billmax/bin/dbenv`             <===
> > > > notice the back tics!
> > > >
> > > > will get you the mysql client program going.
> > From
> > > > there you can enter
> > > > the following sql:
> > > >
> > > >
> > > > update auth set ntries=0,password=encrypt('your
> > > > password here') where
> > > > user='your user login name';
> > > >
> > > > will restore things so you can login.
> > > >
> > > >
> > > >  ----- Original Message -----
> > > > *From:* Scott Reed <sreed@nwwnet.net>
> > > > *To:* questions@billmax.com
> > > > *Sent:* Friday, March 17, 2006 8:12 PM
> > > > *Subject:* BillMax questions -- Password Problem
> > > >
> > > > I messed up my BillMax administrative password
> > and
> > > > now it says I must
> > > > contact the administrator to it fixed. The only
> > > > other account on the system
> > > > does not have permission to do permissions.  How
> > do
> > > > I fix my password?
> > > >
> > > > Scott Reed
> > > > Owner
> > > > NewWays
> > > > Wireless Networking
> > > > Network Design, Installation and Administration
> > > > www.nwwnet.net
> > > >
> > > >
> > >
> >
> -----------------------------------------------------------------------------
> > > > To unsubscribe from the "BillMax Questions"
> > mailing
> > > > list, please send a
> > > > message to "majordomo@billmax.com" with
> > "unsubscribe
> > > > questions" in the
> > > > message body. The message must be sent from the
> > > > exact email address on the
> > > > list.
> > > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam
> > protection around
> > > http://mail.yahoo.com
> > >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
-----------------------------------------------------------------------------
To unsubscribe from the "BillMax Questions" mailing list, please
send a message to "majordomo@billmax.com" with "unsubscribe questions"
in the message body. The message must be sent from the exact email
address on the list.