Difference between Entity in Webtools & database table in MySql

[su2]

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.

[Abdullah Shaikh-3]

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 <[hidden email]> 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.
>
>

[su2]

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 <[e-mail]> 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.
>
>

[Jacques Le Roux]

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" <[hidden email]>

>
> 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.
>

[rajsaini]

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" <[hidden email]>
>>
>> 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.
>>
>
>
>

[su2]

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" <[e-mail]>
>
> 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.
>

[c.schinzer]

that should be user_login
that at least it in postgres.
i can't imagine different namings for different rdbms.


2009/9/11 su2 <[hidden email]>

>
> 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" <[hidden email]>
> >>
> >> 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

[BJ Freeman]

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 <[hidden email]> 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.

[BJ Freeman]

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" <[hidden email]>
>>> 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.

[BJ Freeman]

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" <[hidden email]>
>>>> 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.

[Divesh Dutta]

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.
>
>