how to get admin access

[ac...@reviewjournal.com]

Hello! I'm the new data editor at the Las Vegas Review-Journal, the larger of two daily newspapers in Southern Nevada. I don't have admin access to our PANDA <panda.reviewjournal.com>, and the account for my predecessor has been deactivated. For now, I'm using a reporter login. But eventually I need to go in and maintain our database. I do have Python training, just no admin access. How do I go about it?

Adelaide Chen

Data editor, Las Vegas Review-Journal

702-383-0281 desk

702-383-0264 newsroom

[w higgins]

can you get access to the server it's on?

This message may contain confidential and/or privileged information. If you are not the intended recipient or authorized to receive this for the intended recipient, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by sending a reply e-mail and delete this message. Thank you for your cooperation.

--
You received this message because you are subscribed to the Google Groups "PANDA Project Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to panda-project-u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[w higgins]

if you can ssh to the server, this should give admin access to your existing account.

from there you could create/adjust users in the admin.

cd /opt/panda/

sudo -u panda python manage.py shell

from django.contrib.auth.models import User

u = User.objects.get(username=[EXISTING USER EMAIL])

u.is_staff = True

u.is_superuser = True

u.set_password('PASSWORD OF YOUR CHOOSING')

u.save()

[Mike Stucka]

What Mr. Higgins said. You're going to, at some point, need command-line access to the server, which appears to be hosted by Amazon. That means among other things you'll need certain credentials to get in ...

But more short-term, whoever disabled your predecessor's account presumably has access to create accounts, because that's how it's set up. Unless your predecessor disabled his own account ...

If that's the case, you can try to go the route Mr. Higgins suggested in the second email that just arrived. If not, this *might* work:
Connect to box with SSH, then type this:
sudo -u postgres psql postgres
\connect panda

update auth_user set is_superuser="t" where email="thatrepor...@yourdomainname.com";

That'd make the reporter account a superuser account, which you could then use to create more accounts, and take away the superuser abilities of the reporter account later.

On Fri, Nov 6, 2015 at 1:31 PM, w higgins <higs...@gmail.com> wrote:

--

Mike Stucka
stu...@whitedoggies.com
(478) 213-4742 cell

26.58584, -80.16876 icbm
“A computer lets you make more mistakes faster than any invention in human history, with the possible exceptions of handguns and tequila.” -- Mitch Ratcliffe