You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by su2 <sh...@pexsupply.com> on 2009/09/11 18:48:40 UTC
Difference between Entity in Webtools & database table in MySql
Hello All,
What is the Difference between Entity in Webtools & database table in MySql
?
Currently I am not able to login to any backend (partymgr/ordermngr) Screen.
I wanted to know if is there any manual way to find out the password in
database table. I tired looking for the entity PartyAndUserLogin in MySql
database but was not able to find the same named table.
I really appreciate your help.
Thank you.
--
View this message in context: http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Difference between Entity in Webtools & database table in MySql
Posted by Divesh Dutta <di...@hotwaxmedia.com>.
See my comments inline:
su2 wrote:
> Hello All,
>
> What is the Difference between Entity in Webtools & database table in MySql
> ?
>
> Currently I am not able to login to any backend (partymgr/ordermngr) Screen.
> I wanted to know if is there any manual way to find out the password in
> database table. I tired looking for the entity PartyAndUserLogin in MySql
> database but was not able to find the same named table.
>
Table name should be party_and_user_login in mysql database
> I really appreciate your help.
>
> Thank you.
>
>
Re: Difference between Entity in Webtools & database table in MySql
Posted by su2 <sh...@pexsupply.com>.
Hi Abdullah,
This makes sense why I was not able find the "PartyAndUserLogin". In this
case where, in which table all the data of viewentity is stored? Is there
any where it is mentioned on view entity screen or is there any other way?
Thanks for the help.
abdullah shaikh wrote:
>
> There is no difference, they both are same. what user/password are you
> trying with ?. There is no manual way to find out the password as the
> password is encrypted.
>
> The entity that you define in ofbiz, let say for example
> "PartyAcctgPreference", is named as "party_acctg_preference" in database,
> that is the camel-case name is separated by "_".
>
> And regarding the "PartyAndUserLogin", its not a entity, its a ViewEntity,
> which dynamically gets created in ofiz using the normal entities. Hence
> you
> won't find them in the database.
>
> On Fri, Sep 11, 2009 at 10:18 PM, su2 <sh...@pexsupply.com> wrote:
>
>>
>> Hello All,
>>
>> What is the Difference between Entity in Webtools & database table in
>> MySql
>> ?
>>
>> Currently I am not able to login to any backend (partymgr/ordermngr)
>> Screen.
>> I wanted to know if is there any manual way to find out the password in
>> database table. I tired looking for the entity PartyAndUserLogin in MySql
>> database but was not able to find the same named table.
>>
>> I really appreciate your help.
>>
>> Thank you.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25406516.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Difference between Entity in Webtools & database table in MySql
Posted by BJ Freeman <bj...@free-man.net>.
not stored in DB
they are defined in the entities.xml files.
su2 sent the following on 9/11/2009 11:53 AM:
> Hi Abdullah,
>
> This makes sense why I was not able find the "PartyAndUserLogin". In this
> case where, in which table all the data of viewentity is stored? Is there
> any where it is mentioned on view entity screen or is there any other way?
>
> Thanks for the help.
>
>
>
>
>
>
> abdullah shaikh wrote:
>> There is no difference, they both are same. what user/password are you
>> trying with ?. There is no manual way to find out the password as the
>> password is encrypted.
>>
>> The entity that you define in ofbiz, let say for example
>> "PartyAcctgPreference", is named as "party_acctg_preference" in database,
>> that is the camel-case name is separated by "_".
>>
>> And regarding the "PartyAndUserLogin", its not a entity, its a ViewEntity,
>> which dynamically gets created in ofiz using the normal entities. Hence
>> you
>> won't find them in the database.
>>
>> On Fri, Sep 11, 2009 at 10:18 PM, su2 <sh...@pexsupply.com> wrote:
>>
>>> Hello All,
>>>
>>> What is the Difference between Entity in Webtools & database table in
>>> MySql
>>> ?
>>>
>>> Currently I am not able to login to any backend (partymgr/ordermngr)
>>> Screen.
>>> I wanted to know if is there any manual way to find out the password in
>>> database table. I tired looking for the entity PartyAndUserLogin in MySql
>>> database but was not able to find the same named table.
>>>
>>> I really appreciate your help.
>>>
>>> Thank you.
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>
>
--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.
Re: Difference between Entity in Webtools & database table in MySql
Posted by Abdullah Shaikh <ab...@viithiisys.com>.
There is no difference, they both are same. what user/password are you
trying with ?. There is no manual way to find out the password as the
password is encrypted.
The entity that you define in ofbiz, let say for example
"PartyAcctgPreference", is named as "party_acctg_preference" in database,
that is the camel-case name is separated by "_".
And regarding the "PartyAndUserLogin", its not a entity, its a ViewEntity,
which dynamically gets created in ofiz using the normal entities. Hence you
won't find them in the database.
On Fri, Sep 11, 2009 at 10:18 PM, su2 <sh...@pexsupply.com> wrote:
>
> Hello All,
>
> What is the Difference between Entity in Webtools & database table in MySql
> ?
>
> Currently I am not able to login to any backend (partymgr/ordermngr)
> Screen.
> I wanted to know if is there any manual way to find out the password in
> database table. I tired looking for the entity PartyAndUserLogin in MySql
> database but was not able to find the same named table.
>
> I really appreciate your help.
>
> Thank you.
>
> --
> View this message in context:
> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
Re: Difference between Entity in Webtools & database table in MySql
Posted by Raj Saini <ra...@gmail.com>.
There is a way to get into the system. Encrypt a password using SHA1 and
update the current password column of the table with the encrypted
password. If needed I would install the separate instance of OFBiz,
create admin password something life OFBiz and then copy this password
and update the DB table with the encrypted password of the target OFBiz.
And then you should be able to login with the updated password.
Thanks,
Raj
Jacques Le Roux wrote:
> Anyway passwords are one way encrypted (SHA1), so you will not be able
> to read them (except with a very powerful system ready to run a long
> time....)
>
> Jacques
>
> From: "su2" <sh...@pexsupply.com>
>>
>> Hello All,
>>
>> What is the Difference between Entity in Webtools & database table in
>> MySql
>> ?
>>
>> Currently I am not able to login to any backend (partymgr/ordermngr)
>> Screen.
>> I wanted to know if is there any manual way to find out the password in
>> database table. I tired looking for the entity PartyAndUserLogin in
>> MySql
>> database but was not able to find the same named table.
>>
>> I really appreciate your help.
>>
>> Thank you.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
>>
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
>
Re: Difference between Entity in Webtools & database table in MySql
Posted by Carsten Schinzer <c....@googlemail.com>.
that should be user_login
that at least it in postgres.
i can't imagine different namings for different rdbms.
2009/9/11 su2 <sh...@pexsupply.com>
>
> Ok but in what database table?
>
> jacques.le.roux wrote:
> >
> > Anyway passwords are one way encrypted (SHA1), so you will not be able to
> > read them (except with a very powerful system ready to run
> > a long time....)
> >
> > Jacques
> >
> > From: "su2" <sh...@pexsupply.com>
> >>
> >> Hello All,
> >>
> >> What is the Difference between Entity in Webtools & database table in
> >> MySql
> >> ?
> >>
> >> Currently I am not able to login to any backend (partymgr/ordermngr)
> >> Screen.
> >> I wanted to know if is there any manual way to find out the password in
> >> database table. I tired looking for the entity PartyAndUserLogin in
> MySql
> >> database but was not able to find the same named table.
> >>
> >> I really appreciate your help.
> >>
> >> Thank you.
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>
> >
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25408448.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
--
Best
Carsten Schinzer
Waisenhausstr. 53a
80637 München
Germany
Re: Difference between Entity in Webtools & database table in MySql
Posted by su2 <sh...@pexsupply.com>.
Ok but in what database table?
jacques.le.roux wrote:
>
> Anyway passwords are one way encrypted (SHA1), so you will not be able to
> read them (except with a very powerful system ready to run
> a long time....)
>
> Jacques
>
> From: "su2" <sh...@pexsupply.com>
>>
>> Hello All,
>>
>> What is the Difference between Entity in Webtools & database table in
>> MySql
>> ?
>>
>> Currently I am not able to login to any backend (partymgr/ordermngr)
>> Screen.
>> I wanted to know if is there any manual way to find out the password in
>> database table. I tired looking for the entity PartyAndUserLogin in MySql
>> database but was not able to find the same named table.
>>
>> I really appreciate your help.
>>
>> Thank you.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
>
>
--
View this message in context: http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25408448.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Difference between Entity in Webtools & database table in MySql
Posted by BJ Freeman <bj...@free-man.net>.
if you read the build.xml you will see code to add a admin login not
related to a party.
create-admin-user-login
su2 sent the following on 9/11/2009 2:15 PM:
> Ok but in what database table?
>
> jacques.le.roux wrote:
>> Anyway passwords are one way encrypted (SHA1), so you will not be able to
>> read them (except with a very powerful system ready to run
>> a long time....)
>>
>> Jacques
>>
>> From: "su2" <sh...@pexsupply.com>
>>> Hello All,
>>>
>>> What is the Difference between Entity in Webtools & database table in
>>> MySql
>>> ?
>>>
>>> Currently I am not able to login to any backend (partymgr/ordermngr)
>>> Screen.
>>> I wanted to know if is there any manual way to find out the password in
>>> database table. I tired looking for the entity PartyAndUserLogin in MySql
>>> database but was not able to find the same named table.
>>>
>>> I really appreciate your help.
>>>
>>> Thank you.
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>>
>
--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.
Re: Difference between Entity in Webtools & database table in MySql
Posted by BJ Freeman <bj...@free-man.net>.
sorry
load-admin-user-login
BJ Freeman sent the following on 9/11/2009 3:47 PM:
> if you read the build.xml you will see code to add a admin login not
> related to a party.
> create-admin-user-login
>
> su2 sent the following on 9/11/2009 2:15 PM:
>> Ok but in what database table?
>>
>> jacques.le.roux wrote:
>>> Anyway passwords are one way encrypted (SHA1), so you will not be able to
>>> read them (except with a very powerful system ready to run
>>> a long time....)
>>>
>>> Jacques
>>>
>>> From: "su2" <sh...@pexsupply.com>
>>>> Hello All,
>>>>
>>>> What is the Difference between Entity in Webtools & database table in
>>>> MySql
>>>> ?
>>>>
>>>> Currently I am not able to login to any backend (partymgr/ordermngr)
>>>> Screen.
>>>> I wanted to know if is there any manual way to find out the password in
>>>> database table. I tired looking for the entity PartyAndUserLogin in MySql
>>>> database but was not able to find the same named table.
>>>>
>>>> I really appreciate your help.
>>>>
>>>> Thank you.
>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>
>>>
>
--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.
Re: Difference between Entity in Webtools & database table in MySql
Posted by Jacques Le Roux <ja...@les7arts.com>.
Anyway passwords are one way encrypted (SHA1), so you will not be able to read them (except with a very powerful system ready to run
a long time....)
Jacques
From: "su2" <sh...@pexsupply.com>
>
> Hello All,
>
> What is the Difference between Entity in Webtools & database table in MySql
> ?
>
> Currently I am not able to login to any backend (partymgr/ordermngr) Screen.
> I wanted to know if is there any manual way to find out the password in
> database table. I tired looking for the entity PartyAndUserLogin in MySql
> database but was not able to find the same named table.
>
> I really appreciate your help.
>
> Thank you.
>
> --
> View this message in context:
> http://www.nabble.com/Difference-between-Entity-in-Webtools---database-table-in-MySql-tp25404534p25404534.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>