Re: pgadmin4 setup.py, first time run - Mailing list pgadmin-hackers

<div style="font-family: Verdana;font-size: 12.0px;"><div>I'd this issue on Ubuntu x64. And using Python editor IDLE to
runsetup.py</div><div> </div><div>regards,</div><div>Prasad Somwanshi<br /><br />  <br />  <br /><br /> Sent: Monday,
September07, 2015 at 12:36 PM<br /> From: "Khushboo Vashi" <khushboo.vashi@enterprisedb.com><br /> To: "Dave
Page"<dpage@pgadmin.org><br /> Cc: Prasad <prasad.s@mail.com>, pgadmin-hackers
<pgadmin-hackers@postgresql.org><br/> Subject: Re: [pgadmin-hackers] pgadmin4 setup.py, first time run<br /><br
/>Hi Dave,<br /><br /> I have tried to reproduce the issue but couldn't reproduce it on UBUNTU as well as on MAC.<br
/><br/> I have checked the online examples of SQLAlchemyUserDatastore, and I think<br /> it is logical that before
assigningthe new role to the newly created user,  user should be committed first.<br />  Thanks,Khushboo<br /><br />
 <br/> On Mon, Sep 7, 2015 at 1:49 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:<br /><br /> Yes. I
amlooking into this.<br />  Thanks,Khushboo<br /><br />  <br /> On Mon, Sep 7, 2015 at 1:31 PM, Dave Page
<dpage@pgadmin.org[dpage@pgadmin.org]>wrote:Khushboo, can you look at this please?<br /><br /> Thanks.<br /><br
/>On Sun, Sep 6, 2015 at 12:42 AM, Prasad <prasad.s@mail.com[prasad.s@mail.com]> wrote:<br /> > Hi,<br />
><br/> > When you try to run pgadmin4 for first time(without presence of pgadmin4.db), it ask you to run
setup.py.When you run it, it throws python error as follows,<br /> > Traceback (most recent call last):<br /> > 
 File"/home/test/Development/pgadmin4/web/setup.py", line 145, in <module><br /> >     do_setup(app)<br />
>  File "/home/test/Development/pgadmin4/web/setup.py", line 57, in do_setup<br /> >   
 user_datastore.add_role_to_user(email,'Administrators')<br /> >   File
"/usr/local/lib/python2.7/dist-packages/Flask_Security-1.7.4-py2.7.egg/flask_security/datastore.py",line 106, in
add_role_to_user<br/> >     if role not in user.roles:<br /> > AttributeError: 'NoneType' object has no attribute
'roles'<br/> ><br /> > It's because,user_datastore.create_role,user_datastore.create_user and
user_datastore.add_role_to_userall calls are for in one database transaction. It need to commit it after first two
callsor creating role and user for add_role_to_user to work,<br /> ><br /> > Find attached patch for this.<br />
><br/> > regards,<br /> > Prasad Somwanshi<br /> ><br /> ><br /> > --<br /> > Sent via
pgadmin-hackersmailing list (pgadmin-hackers@postgresql.org[pgadmin-hackers@postgresql.org])<br /> > To make changes
toyour subscription:<br /> > <a href="http://www.postgresql.org/mailpref/pgadmin-hackers"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-hackers</a>[<a
href="http://www.postgresql.org/mailpref/pgadmin-hackers"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-hackers</a>]<br/> ><br /><br /><br /><br /> --<br /> Dave
Page<br/> Blog: <a href="http://pgsnake.blogspot.com" target="_blank">http://pgsnake.blogspot.com</a>[<a
href="http://pgsnake.blogspot.com"target="_blank">http://pgsnake.blogspot.com</a>]<br /> Twitter: @pgsnake<br /><br />
EnterpriseDBUK: <a href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com</a>[<a
href="http://www.enterprisedb.com"target="_blank">http://www.enterprisedb.com</a>]<br /> The Enterprise PostgreSQL
Company</div></div>