Vtiger Password Reset

Mehul Patel

unread,

Jun 21, 2010, 7:31:49 AM6/21/10

to VGLUG

Hello All,

I had lost my vtiger username password, so i was try to reset admin
password with below mentioned command but given some error ,

Command :

update vtiger_users set user_hash=.21232f297a57a5a743894a0e4a801fc3.,
user_password=.adpexzg3FUZAk.,confirm_password=.adoY/
6Mlw8kqg.,crypt_type=. where user_name=.admin.;

Error :

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'f297a57a5a743894a0e4a801fc3.,
user_password=.adpexzg3FUZAk.,confirm_password=.ad' at line 1

How to reset admin password of vtiger .......?

Regards,

Mehul Patel

Dhaval Soni

unread,

Jun 21, 2010, 7:34:55 AM6/21/10

to vg...@googlegroups.com

Dear Mehul,

On Mon, Jun 21, 2010 at 5:01 PM, Mehul Patel <mehu...@gmail.com> wrote:

Hello All,

I had lost my vtiger username password, so i was try to reset admin
password with below mentioned command but given some error ,

Command :

update vtiger_users set user_hash=.21232f297a57a5a743894a0e4a801fc3.,
user_password=.adpexzg3FUZAk.,confirm_password=.adoY/
6Mlw8kqg.,crypt_type=. where user_name=.admin.;

Error :

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'f297a57a5a743894a0e4a801fc3.,
user_password=.adpexzg3FUZAk.,confirm_password=.ad' at line 1

Are you using which version of vtiger? Try this one

> mysql -u user -ppass

mysql> use vtiger;

mysql> update vtiger_users set user_hash=’21232f297a57a5a743894a0e4a801fc3′, user_password=’adpexzg3FUZAk’,confirm_password=’adoY/6Mlw8kqg’,crypt_type=” where user_name=’admin’;

This will reset the ‘admin’ username to password ‘admin’ using vtiger 5.0.4.

I hope this will works for you..!

How to reset admin password of vtiger .......?

Regards,

Mehul Patel

--
Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.
You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG-un...@googlegroups.com
To post to this group, send email to VG...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/VGLUG

--
Kind regards,
Dhaval Soni
Red Hat Certified Architect
ID: 804 007 900 325 939

M: +91-9662029620

Mehul Patel

unread,

Jun 21, 2010, 7:38:24 AM6/21/10

to VGLUG

I had already use this command & face same error,,

> > For more options, visit this group athttp://groups.google.com/group/VGLUG

Dhaval Soni

unread,

Jun 21, 2010, 7:39:11 AM6/21/10

to vg...@googlegroups.com

On Mon, Jun 21, 2010 at 5:08 PM, Mehul Patel <mehu...@gmail.com> wrote:

I had already use this command & face same error,,

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'f297a57a5a743894a0e4a801fc3.,
user_password=.adpexzg3FUZAk.,confirm_password=.ad' at line 1

Are you using which version of that application?

--

Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.

You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG-un...@googlegroups.com
To post to this group, send email to VG...@googlegroups.com

For more options, visit this group at http://groups.google.com/group/VGLUG

Dhaval Soni

unread,

Jun 21, 2010, 7:41:26 AM6/21/10

to vg...@googlegroups.com

Dear Mehul,

On Mon, Jun 21, 2010 at 5:04 PM, Dhaval Soni <sonid...@gmail.com> wrote:

Dear Mehul,

On Mon, Jun 21, 2010 at 5:01 PM, Mehul Patel <mehu...@gmail.com> wrote:

Hello All,

I had lost my vtiger username password, so i was try to reset admin
password with below mentioned command but given some error ,

Command :

update vtiger_users set user_hash=.21232f297a57a5a743894a0e4a801fc3.,
user_password=.adpexzg3FUZAk.,confirm_password=.adoY/
6Mlw8kqg.,crypt_type=. where user_name=.admin.;

Please cross check your query. Is it . ( DOT ) in front of admin?

Error :

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'f297a57a5a743894a0e4a801fc3.,
user_password=.adpexzg3FUZAk.,confirm_password=.ad' at line 1

Are you using which version of vtiger? Try this one

> mysql -u user -ppass
mysql> use vtiger;
mysql> update vtiger_users set user_hash=’21232f297a57a5a743894a0e4a801fc3′, user_password=’adpexzg3FUZAk’,confirm_password=’adoY/6Mlw8kqg’,crypt_type=” where user_name=’admin’;

This will reset the ‘admin’ username to password ‘admin’ using vtiger 5.0.4.
I hope this will works for you..!

You may go to below links for more references:

http://mtehrani30.blogspot.com/2009/05/reset-vtiger-admin-password.html

http://michaelkimsal.com/blog/reset-vtiger-504-default-admin-password/

How to reset admin password of vtiger .......?

Regards,

Mehul Patel

--
Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.
You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG-un...@googlegroups.com
To post to this group, send email to VG...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/VGLUG

--
Kind regards,
Dhaval Soni
Red Hat Certified Architect
ID: 804 007 900 325 939

M: +91-9662029620

Mehul Patel

unread,

Jun 21, 2010, 7:44:31 AM6/21/10

to VGLUG

I had already use this links & try it but same problem

On Jun 21, 4:41 pm, Dhaval Soni <sonidha...@gmail.com> wrote:
> Dear Mehul,
>
>
>
> On Mon, Jun 21, 2010 at 5:04 PM, Dhaval Soni <sonidha...@gmail.com> wrote:
> > Dear Mehul,
>

> > On Mon, Jun 21, 2010 at 5:01 PM, Mehul Patel <mehu....@gmail.com> wrote:
>
> >> Hello All,
>
> >> I had lost my vtiger username password, so i was try to reset admin
> >> password with below mentioned command but given some error ,
>
> >> Command :
>
> >> update vtiger_users set user_hash=.21232f297a57a5a743894a0e4a801fc3.,
> >> user_password=.adpexzg3FUZAk.,confirm_password=.adoY/

> >> 6Mlw8kqg.,crypt_type=. where user_name*=.admin.;*

Mehul Patel

unread,

Jun 21, 2010, 7:47:32 AM6/21/10

to VGLUG

Dear Dhaval,

pls find below error,

mysql> update vtiger_users set user_password='adpexzg3FUZAk' where
user_name='admin' ;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> vtiger_users set crypt_type='' where user_name='admin' ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right

syntax to use near 'vtiger_users set crypt_type='' where
user_name='admin'' at line 1

Regards,

Mehul Patel

On Jun 21, 4:41 pm, Dhaval Soni <sonidha...@gmail.com> wrote:
> Dear Mehul,
>
>
>
> On Mon, Jun 21, 2010 at 5:04 PM, Dhaval Soni <sonidha...@gmail.com> wrote:
> > Dear Mehul,
>

> > On Mon, Jun 21, 2010 at 5:01 PM, Mehul Patel <mehu....@gmail.com> wrote:
>
> >> Hello All,
>
> >> I had lost my vtiger username password, so i was try to reset admin
> >> password with below mentioned command but given some error ,
>
> >> Command :
>
> >> update vtiger_users set user_hash=.21232f297a57a5a743894a0e4a801fc3.,
> >> user_password=.adpexzg3FUZAk.,confirm_password=.adoY/

> >> 6Mlw8kqg.,crypt_type=. where user_name*=.admin.;*

Dhaval Soni

unread,

Jun 21, 2010, 7:56:32 AM6/21/10

to vg...@googlegroups.com

Dear Mehul,

On Mon, Jun 21, 2010 at 5:17 PM, Mehul Patel <mehu...@gmail.com> wrote:

Dear Dhaval,

pls find below error,

mysql> update vtiger_users set user_password='adpexzg3FUZAk' where
user_name='admin' ;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> vtiger_users set crypt_type='' where user_name='admin' ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right

syntax to use near 'vtiger_users set crypt_type='' where
user_name='admin'' at line 1

Will you pleas check this one?

Assumption: You have access to the vtiger database.

1. Login to the mysql database.
2. Using the following commands on mysql command line :-

Code:

use <vtiger_database_name>;

For versions < 5.0.4 :

Code:

update vtiger_users set user_password = 'adpexzg3FUZAk' where user_name = 'admin';

For versions 5.0.4 or later:

Code:

update vtiger_users set user_password = 'adpexzg3FUZAk', crypt_type = '' where user_name = 'admin';

This will reset the password to 'admin'.

Note: Replace 'admin' with whichever user_name you want to reset the password for.

Link to Article: http://forums.vtiger.com/viewtopic.php?t=20372

I never used this application before, but after searching on google I am updating you. But which version are you using? Which version are you using of that app?

Thank you,

--

Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.

You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG-un...@googlegroups.com
To post to this group, send email to VG...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/VGLUG

punit dambiwal

unread,

Jun 21, 2010, 7:36:35 AM6/21/10

to vg...@googlegroups.com

Dear Mehul,

Please reset your admin password through your mysql database/phpmyadmin.

--
Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.
You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG-un...@googlegroups.com
To post to this group, send email to VG...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/VGLUG

--
Thanks & Regards,

Punit Dambiwal
http://www.unixsurgeon.com
RedHat Certified Engineer

Sr. Linux Administrator
ZNet Technologies Pvt Ltd (Znet India) - India's Top 5 Web Hosting Company.
Website: http://www.znetindia.com/
Mobile :- 09314239083 | Office :- 08875002225

Reply all

Reply to author

Forward