[NO FIX NEEDED] Multiple admin users for OCS

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
ramon
Posts: 945
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil
Contact:

[NO FIX NEEDED] Multiple admin users for OCS

Postby ramon » Wed Jun 01, 2011 11:37 am

Hello all,

The solution provided in this post (referenced in the Wiki) is not working for OCS 2.3.3.2...
Any ideas on how to add another Admin?

[UPDATE - 02/06/2011]
The database "hack" on the post above DOES WORK for OCS.
Make sure to be working on the right database...
Last edited by ramon on Thu Jun 02, 2011 5:43 am, edited 1 time in total.

asmecher
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm
Contact:

Re: Multiple admin users for OCS

Postby asmecher » Wed Jun 01, 2011 11:49 am

Hi Ramón,

What do you get from:

Code: Select all

SELECT * FROM roles WHERE role_id=1;
Regards,
Alec Smecher
Public Knowledge Project Team

ramon
Posts: 945
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil
Contact:

Re: Multiple admin users for OCS

Postby ramon » Wed Jun 01, 2011 12:34 pm

Alec,

Here's the result.

Code: Select all

conference_id      sched_conf_id      user_id      role_id
       0                 0              1             1
       0                 0              2             1
       0                 0              5             1


In OCS 2.1.2.1, I had 3 administrators and it worked perfectly.
After upgrading to 2.3 it stopped working, which means they don't have access to the administration area.
Other things work fine

asmecher
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm
Contact:

Re: Multiple admin users for OCS

Postby asmecher » Wed Jun 01, 2011 1:30 pm

Hi Ramón,

Hmm, those entries look fine, and we're using the same setup for our own conference installation, which is 2.3.3-1, which is pretty close to what you're using -- is there any chance that you're working on the wrong database? Does that user account otherwise work OK, and what happens if you navigate directly to the admin URL, i.e. http://[something]/index.php/index/index/admin?

Regards,
Alec Smecher
Public Knowledge Project Team

ramon
Posts: 945
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil
Contact:

Re: Multiple admin users for OCS

Postby ramon » Thu Jun 02, 2011 5:41 am

Hello Alec,

I probably got confused with the database, as they were 2 different installations with the same content.
I didn't pay attention to the DB name at the time.
The development database had the hack, while the production site, which I needed to replicate didn't.

Sorry for the mess!


Return to “OCS Technical Support”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest