Encrypted password

Hello All,

   I have downloaded the clients database from downloading link and restored it on my local database.Passwords in tabProfile are encrypted and i am unable to login.
How can i decrypt the password for string like *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Thank you all  



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/gpMn6Sx8m6IJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Hi gangadhar,


You cannot decrypt the password but you can set a new one by logging in as administrator or using an SQL update query setting password=password("new password") for that user.

Sent from my phone


On Sat, Mar 16, 2013 at 1:00 PM, gangadhar kadam <em...@gmail.com> wrote:

Hello All,

I have downloaded the clients database from downloading link and restored it on my local database.Passwords in tabProfile are encrypted and i am unable to login.
How can i decrypt the password for string like *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Thank you all



You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/gpMn6Sx8m6IJ.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

This is MD5 password and hence cannot be decrypted. MD5 comes with one-way encryption , so its not possible for you to decrypt.

On Saturday, 16 March 2013 10:30:22 UTC+3, gangadhar kadam wrote:

Hello All,
   I have downloaded the clients database from downloading link and restored it on my local database.Passwords in tabProfile are encrypted and i am unable to login.
How can i decrypt the password for string like *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Thank you all  



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ucwYRHeg40UJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Thank You Sir,

I have updated the password using update tabProfile set password=password("password") where name='administrator' still i am getting incorrect password error. is there any other way to recover password (except forget password link)


Thank you.
Regards,

On 16 March 2013 13:04, Syed Qadeer <sd...@gmail.com> wrote:
This is MD5 password and hence cannot be decrypted. MD5 comes with one-way encryption , so its not possible for you to decrypt.


On Saturday, 16 March 2013 10:30:22 UTC+3, gangadhar kadam wrote:
Hello All,
I have downloaded the clients database from downloading link and restored it on my local database.Passwords in tabProfile are encrypted and i am unable to login.
How can i decrypt the password for string like *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Thank you all



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ucwYRHeg40UJ.


For more options, visit https://groups.google.com/groups/opt_out.





--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Does the database have an __auth table?


Sent from my phone


On Sat, Mar 16, 2013 at 1:59 PM, गंगाधर कदम <em...@gmail.com> wrote:

Thank You Sir,

I have updated the password using update tabProfile set password=password("password") where name='administrator' still i am getting incorrect password error. is there any other way to recover password (except forget password link)

Thank you.
Regards,

On 16 March 2013 13:04, Syed Qadeer <sd...@gmail.com> wrote:
This is MD5 password and hence cannot be decrypted. MD5 comes with one-way encryption , so its not possible for you to decrypt.


On Saturday, 16 March 2013 10:30:22 UTC+3, gangadhar kadam wrote:
Hello All,
I have downloaded the clients database from downloading link and restored it on my local database.Passwords in tabProfile are encrypted and i am unable to login.
How can i decrypt the password for string like *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Thank you all



You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ucwYRHeg40UJ.


For more options, visit https://groups.google.com/groups/opt_out.





--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

yes sir…



On 16 March 2013 14:02, Anand Doshi <an…@iwebnotes.com> wrote:

Does the database have an __auth table?


Sent from my phone


On Sat, Mar 16, 2013 at 1:59 PM, गंगाधर कदम <em...@gmail.com> wrote:

Thank You Sir,

I have updated the password using update tabProfile set password=password("password") where name='administrator' still i am getting incorrect password error. is there any other way to recover password (except forget password link)

Thank you.
Regards,

On 16 March 2013 13:04, Syed Qadeer <sd...@gmail.com> wrote:
This is MD5 password and hence cannot be decrypted. MD5 comes with one-way encryption , so its not possible for you to decrypt.



On Saturday, 16 March 2013 10:30:22 UTC+3, gangadhar kadam wrote:

Hello All,
I have downloaded the clients database from downloading link and restored it on my local database.Passwords in tabProfile are encrypted and i am unable to login.

How can i decrypt the password for string like *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Thank you all



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ucwYRHeg40UJ.


For more options, visit https://groups.google.com/groups/opt_out.





--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Then set the password in __auth table and not profile table.


Sent from my phone


On Sat, Mar 16, 2013 at 2:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

yes sir..



On 16 March 2013 14:02, Anand Doshi <an...@iwebnotes.com> wrote:

Does the database have an __auth table?


Sent from my phone


On Sat, Mar 16, 2013 at 1:59 PM, गंगाधर कदम <em...@gmail.com> wrote:

Thank You Sir,

I have updated the password using update tabProfile set password=password("password") where name='administrator' still i am getting incorrect password error. is there any other way to recover password (except forget password link)

Thank you.
Regards,

On 16 March 2013 13:04, Syed Qadeer <sd...@gmail.com> wrote:
This is MD5 password and hence cannot be decrypted. MD5 comes with one-way encryption , so its not possible for you to decrypt.



On Saturday, 16 March 2013 10:30:22 UTC+3, gangadhar kadam wrote:

Hello All,
I have downloaded the clients database from downloading link and restored it on my local database.Passwords in tabProfile are encrypted and i am unable to login.

How can i decrypt the password for string like *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Thank you all



You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ucwYRHeg40UJ.


For more options, visit https://groups.google.com/groups/opt_out.





--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.








Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Thank you sir it worked.

On 16 March 2013 14:35, Anand Doshi <an…@iwebnotes.com> wrote:

Then set the password in __auth table and not profile table.


Sent from my phone


On Sat, Mar 16, 2013 at 2:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

yes sir..



On 16 March 2013 14:02, Anand Doshi <an...@iwebnotes.com> wrote:

Does the database have an __auth table?


Sent from my phone


On Sat, Mar 16, 2013 at 1:59 PM, गंगाधर कदम <em...@gmail.com> wrote:

Thank You Sir,

I have updated the password using update tabProfile set password=password("password") where name='administrator' still i am getting incorrect password error. is there any other way to recover password (except forget password link)

Thank you.
Regards,

On 16 March 2013 13:04, Syed Qadeer <sd...@gmail.com> wrote:
This is MD5 password and hence cannot be decrypted. MD5 comes with one-way encryption , so its not possible for you to decrypt.



On Saturday, 16 March 2013 10:30:22 UTC+3, gangadhar kadam wrote:

Hello All,
I have downloaded the clients database from downloading link and restored it on my local database.Passwords in tabProfile are encrypted and i am unable to login.

How can i decrypt the password for string like *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Thank you all



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ucwYRHeg40UJ.


For more options, visit https://groups.google.com/groups/opt_out.





--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.








Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.