GeoServer login failed

I just had similar issues and solved it by setting my database user to be the owner of the postgis tables.

Create a fresh PostGIS enabled database:

createdb -O [drupaldb-user] [drupaldb-name]
createlang plpgsql [drupaldb-name]
psql -d bhuudb -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
psql -d bhuudb -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql

Set permissions:

ALTER TABLE geometry_columns OWNER TO [drupaldb-user];
ALTER TABLE spatial_ref_sys OWNER TO [drupaldb-user];

Where [drupaldb-name] is the name of the database you wish to use for drupal (and the PostGIS data)
[drupaldb-user] is a user set up in Postgresql for accessing the database for drupal.

Got these great pointers from:
http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/

Hi,

installing Cartaro on Debian Squeeze the following packages are required:

apache2 php5 php5-gd php5-curl php5-pgsql postgresql postgis postgresql-8.4-postgis postgresql-contrib-8.4 tomcat6

PostgreSQL 8.4 and PostGIS 1.5 are recommended but more recent versions should work as well. Try to run SELECT PostGIS_Version(); inside the PostgreSQL database that Drupal uses. This is the way how Cartaro checks if PostGIS is available.

Regarding the GeoServer configuration, have a look at the documentation of the GeoServer module.

Hope that helps.

Friedjoff

Are the package requirements the same for Ubuntu 10.04? I think I have all the correct pieces to this geo-puzzle, but during the configuration stage of installation, I get the white screen. When I go to the site homepage, I cannot login or do anything. There is an interactive map on the page, but that is only fun for a little while. Since I am not getting any errors and cannot login, I am not sure how to troubleshoot this. Anybody else had this problem?

I found the problem to my installation. After installing Google Chrome and going through installation procedure again, it worked fine.

Firefox seems to be having issues with the installation script...?

Firefox works fine here.

If anyone runs into problemes using Firefox, please keep Firebug running to report any JavaScript erros. Thanks!

I am having the same problem as assuton, blank screen on last step of installation Configure site and an interactive map on the home-page with Access denied.
I am pretty sure I have everything configured properly with Ubuntu Server 12.04, PostGIS 1.5, Posgres 9.1, Geoserver able to access PostGIS database and Drupal user as admininistrator in Geoserver.
The script is able to find the geoserver installation under GeoServer URL, but GeoServer workspace is empty and GeoServer namespace is filled just with the sever IP.
I tried with Firefox and Chrome with the same results.
Any help appreciated,
thanks

Can you set the PHP error reporting to a higher level. Maybe that gets us a helpful error message.

I have the same problem as mato. The problem concerns the last installation step. It seems the workspace is not found by Cartaro (in your description* it is said that: "Workspace: The default GeoServer workspace. If this list is empty the connection to GeoServer is probably not working"). I have created a new workspace named "cartaro" with the following namespace: http://localhost/cartaro/includes/database. I thought this is meant by: "Make sure GeoServer is able to access the Drupal database if you want to publish data from Drupal using GeoServer".
* http://drupal.org/node/1504464
I hope anybody can help. Thanks.

I tried again to configure, now an error message shows: GeoServer login failed: check GeoServer URL and site maintenance account.
But my site maintenance account corresponds with my Geoserver user as a ROLE_ADMINISTARTOR. Also, the GeoServer URL (http://localhost:8080/geoserver) is correct. What's the problem? Many thanks!

I'm having trouble to reproduce this problem. Just to prevent any configuration errors, are the following requirements fulfilled?

• PHP's cURL module is installed.
• Username and Password of Drupal and GeoServer administrator are the same.
• Drupal can access GeoServer using the specified GeoServer URL.

BTW: just the GeoServer URL and the user credentials are relevant at this point. Workspace, namespace and datastore will be important later on.

Hello Belinda,

the documentation you're referencing concerns only the GeoServer module installation on an existing Drupal site and isn't relevant for the installation of Cartaro.

Regards,
Friedjoff

A new release of Cartaro will be available soon. This release will return detailed error messages on why the GeoServer login failed.

Anyone who experienced login problems, please try out the new release and report any error messages.

Problem fixed for me, thanks friedjoff: php5-curl was missed, sorry!
After installing and restarting apache everything went fine.
To let Drupal recognize the workspace I was obliged to log-off / log-in.

I have php5-curl installed and my username of geoserver and cartaro are the same. I think the problem is the connection to Geoserver. Cartaro can't recognize the URL of Geoserver. I searched meanwhile in the internet, maybe the problem are administrative rights. I have an extract of the error log file of apache2:
[error] [client 127.0.0.1] File does not exist: /var/www/cartaro/admin, referer: http://localhost/cartaro/install.php?profile=cartaro&locale=en Is there any possibility within Cartaro to set the username as root?
Or do I need a proxy_module within apache or tomcat? Possilbly it has something to do with the XMLHttpRequest?
I will try to find a solution, else I wait for the new release:) Thanks friedjoff.

Hi Belinda,

the new release is available. Can you please run the installation of Cartaro again and report any error messages? Thanks!

Hello friedjoff,

thanks for your reply. I get this error message:

GeoServer login failed: Could not contact GeoServer. Please check the GeoServer URL and your site maintenance account.

Any idea? I configured additionally the webserver regarding clean URLs, but its not working. As I wrote earlier, the Apache error log lists the path (var/www/cartaro/admin). Maybe it has something to do with the local .htaccess? I keep trying:)

Thank you.

Hello Belinda,

looks like Drupal can't access GeoServer. I don't think clean URLs, Apache logs and .htaccess files play any role in this regard. Can you give more details about your setup, like the location of Drupal and GeoServer as well as the configuration of Apache and the Java application server (e.g. Tomcat)?

Hello friedjoff,

I am working with the Ubuntu 12.04. Version. The webspace of my apache2 webserver is located at /var/www/. At this place cartaro is located /var/www/cartaro. Tomcat7 is at this place: /var/lib/tomcat7. Here, Geoserver is installed: /var/lib/tomcat7/webapps/geoserver.
The configuration directories for both apache and tomcat are at /etc/.

Hi,

everything looks fine as far as I can tell from the screenshots. Somehow Drupal/PHP doesn't seem to be able to get through to GeoServer. The new GeoServer module will return a more detailed error message and will be available in the next Cartaro release, maybe that will help us. Sorry for this try and error approach.

Hi,

I've the same kind of problem than Belinda.

I'm working on Windows XP under a ms4w apache web server. My geoserver is install locally (http://localhost:8080/geoserver) with Tomcat 7. My geoserver is 2.2 RC1.
I have activate the Apache mod_rewrite.so and the php_curl is also configured.

Drupal install give me the following message : GeoServer login failed: Could not contact GeoServer. Please check the GeoServer URL and your site maintenance account.

With Firebug, I've got this message : "NetworkError: 404 Not Found - http://localhost:85/cartaro/admin/config/search/clean-urls/check"

Apache can't find a file :
[Thu Aug 09 09:26:39 2012] [error] [client 127.0.0.1] File does not exist: C:/ms4w/Apache/htdocs/cartaro/admin, referer: http://localhost:85/cartaro/install.php?profile=minimal&locale=en

And the geoserver log give me this kind of message (I give you just a piece) : 09 ao¹t 09:26:37 INFO [geoserver.filters] - Creating a new http session outside
of the web UI! (normally not desirable), the path is/j_spring_security_check
java.lang.Exception: Full stack trace for the session creation path
at org.geoserver.filters.SessionDebugFilter$SessionDebugWrapper.getSessi
on(SessionDebugFilter.java:93)
at javax.servlet.http.HttpServletRequestWrapper.getSession(HttpServletRe
questWrapper.java:209)
at org.springframework.security.web.context.HttpSessionSecurityContextRe
pository$SaveToSessionResponseWrapper.createNewSessionIfAllowed(HttpSessionSecur
ityContextRepository.java:339)
at org.springframework.security.web.context.HttpSessionSecurityContextRe
pository$SaveToSessionResponseWrapper.saveContext(HttpSessionSecurityContextRepo
sitory.java:280)

Finally, is there something to change in the geoserver configuration ? Or is it something else ?

Thanks ..

Hi Christophe,

thanks for this detailed bug report, Tomcat 7 might be the problem. I'll look into this, in the mean time you can try Tomcat 6 and replace the GeoServer module in cartaro/profiles/cartaro/modules/contrib/geoserver with a current dev release.

Hi,

I tried with Tomcat 6 and geoserver 2.1.2. With this configuration, it's good.

Thanks...

The format of the cookie file from Tomcat 7 has changed a bit. Fixed in the GeoServer module.

Hello,

when creating the postgis database in the example in the getting started section does the DBUSER and DBNAME expect you will substitute
a username and database name of your own, or are these the correct values themselves, sorry if a silly question but I am prompted for a password either way that does not accept any values and I fail.
Is ther a better forum for this?

Thanks,

Lewis

Hi Lewis,

DBUSER needs to be replaced with the user name that you want to use to install Cartaro. That means it should equal the user name that you type into the forms whilst installing Drupal.

DBNAME needs to be replaced with the name of the database into which you want to install Cartaro/Drupal.

In other words prior to installing Drupal/Cartaro you need to create a database along with a user for Drupal. The user needs to be granted to create tables within the database.

Note that your issue is different from what is discussed in this issue. If these hints are not enough please open a new issue and make sure to state clearly which of the commands you are trying to execute asks for the password. Do also include the versions of Postgres and PostGIS you are trying to use.

Thanks,

I was using freidjoff examples in thread to set up debian squeeze which got me to install a working geoserver, can log in. I do not see a post gis database using same instructions in freidjoffs' thread to set up db, dbuser. I get prompted for the password I set up but it sees the dbname as the dbusername and doesn't recognize the password. The versions are the same as in the thread above for squeeze setup.

Lewis