nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can't see ADMINISTRATION tab when logging on (simple authentication with SQL Server)

RobinBoyle

Hi,

I have installed Geoportal 1.2 on Windows Server 2008, with Apache-Tomcat 6 as the web server and SQL Server 2005 as the database. The authentication method is Simple Authentication rather than LDAP because we only need one admin user, with all other users just having the ability to search and browse.

Everything appears to have been installed correctly and I can see the Geoportal front page when I navigate to http://localhost:8080/geoportal; however, when I try to log in as the administrator user (gptadmin), I don't get the ADMINISTRATION tab and the green 'Welcome' box doesn't say "Welcome, gptadmin".

I have installed both Geoportal 1.1.1 and Geoportal 1.2 successfully with PostgreSQL as the database on a Windows Server 2003 box.

One thing I did notice was that there is no separate GRANT sql script for SQL Server; as a result there appears to be a missing record in the GPT_USERS table.

Would really appreciate some help on this!

Robin

Vind meer berichten getagd met

Accepted answers

RobinBoyle

Eoin and Clive,

Good news: it's working now!
I deleted the catalina.2012-02-07.log and gpt.2012-02-07.log files, restarted Tomcat.

I think the issue may be down to something not quite right in the gpt.xml file and even though I changed it, perhaps something dodgy with the log files and the fact I didn't restart Tomcat meant it wasn't getting the change through.

Thank you so much for your input - I am very grateful.

Robin

All comments

JörgPriebe

i had the same problem. i could not be solved by deleting the log files + restarting the tomcat.
The tip from eryan helped me, so i deleted the "ldapAdapter section" instead of commenting it out.

best regards from germany

CliveReece

Great news Robin. Yes, you can change .jsp files and the changes should show up in the web app (IFF you clear your browser cache). However, change a configuration file like gpt.xml or gpt.properties and you need to restart the web container (e.g. Tomcat). Sometimes you also need to clear Tomcat's working cache (folder Tomcat\work\Catalina).

RobinBoyle

CliveReece

Robin,

Can you stop Tomcat. Clear out (delete) your old log files. Then start Tomcat again and when you get to the "LDAP connection" error, grab the log file (e.g. gpt.2012-02-07.log) and attach it in your next reply so we can have a look at the error messages?

Adding the copy of your gpt.xml might help as well.

EoinRyan

Yes, the LDAP section is correctly commented-out and the Simple Authentication section is fine.

you could try removing whole ldapAdapter section rather than commenting it out in the xml?

RobinBoyle

Yes, the LDAP section is correctly commented-out and the Simple Authentication section is fine.

EoinRyan

Hi Robin,
If you open your gpt.xml in a web browser does it display okay?

RobinBoyle

Eoin,

Thanks for the input. I already changed the gpt.xml settings for LDAP/Simple Authentication (see below). There's nothing funky with what I've done, is there? (Note that the password has been replaced with ******)

<identity encKey="PtkESRI" realm="Geoportal">
        <simpleAdapter>
            <account username="gptadmin" password="********" encrypted="false"/>
            <roles>
                <role key="gptRegisteredUser"/>
                <role key="gptPublisher"/>
                <role key="gptAdministrator"/>
            </roles>
        </simpleAdapter>

        
    </identity>

Any other ideas about what the problem might be?

Thanks,
Robin

EoinRyan

***UPDATE***

OK, I see where I had a problem: I used the same user for the database owner as the geoportal admin user. I have separated them out now.

...which leads to a new problem! When I log in as gptadmin in the Geoportal login page, I now get "Unable to connect to LDAP." where I should get "Welcome, gptadmin". Just to reiterate, I am not using LDAP; instead, I am using simple authentication, so it shouldn't even be trying to access LDAP.

Apologies if you've spent time thinking about this; the new problem is where it's at now!

Cheers,
Robin

Hi Robin,

The authentication method is specified in your gpt.xml file:


Make sure that the ldapAdaper element is commented out and you have simpleAdapter configured.

Regards,
Eoin

RobinBoyle

***UPDATE***

OK, I see where I had a problem: I used the same user for the database owner as the geoportal admin user. I have separated them out now.

...which leads to a new problem! When I log in as gptadmin in the Geoportal login page, I now get "Unable to connect to LDAP." where I should get "Welcome, gptadmin". Just to reiterate, I am not using LDAP; instead, I am using simple authentication, so it shouldn't even be trying to access LDAP.

Apologies if you've spent time thinking about this; the new problem is where it's at now!

Cheers,
Robin

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.