Windows Installation

This really seems to be the crux of installing Cartaro. I'll make a video tutorial available as soon as possible.

In the mean time, can you please run the following SQL statement in pgAdmin and tell me the result?

SELECT PostGIS_Version()

Make sure you use the same database.

Looks like PostGIS is not installed.

Have a look at the PostGIS documentation or try the OpenGeo Suite.

Hello,

I have a similar issue with window installation bogging down due to a lack of possible documentation,

I have the latest stack on windows, postgresql 9.1, I have a drupal postgresql database and test site on local host, I have a postgresql postgis 2.0 database that I can access through qgis, and I have geoserver which I assume I can access the postgres postgis database as well. So I have a more or less working stack, with drupal, but no cartaro as yet.

A question is can I point cartaro to these applications? and what are the steps or perhaps I need to achieve this or do I need to add through drupal modules after I install cartaro?

The bigger problem is that the drupal site is the standard localhost installation thru stackbuilder and not the cartaro distribution. Is there a way to modify my current drupal on local host by uncompressing the cartaro in some subfolder or modifying the current drupal installation by adding or replacing a subdirectory in the installation ( or replacing completely ) or should I do a parallel installation?

Thanks for any insights,

Lewis

Hi Lewis,

please download Cartaro and replace the Drupal directory with Cartaro. Now you need to rerun the installation process. Tell us if you notice any Windows specific issues that need to be documented.

Thanks, when I go to the localhost dev site it is prompting me for the setup after replacing with cartaro so it looks like a go. I'll post if any interesting problems occur.

Hi,

I find I can't login to the database I was using on postgresql 9.1, stackbuilder installed a database for drupal 7 on the postgresql for localhost but whatever combination I use there error is the standard
"•Is the database server running?

•Does the database exist, and have you entered the correct database name?
•Have you entered the correct username and password?
•Have you entered the correct database hostname?"

I have another login and user for the postgresql login for pgadminIII (and another for the postgis)
under advanced on the same setup page
I have entered localhost as database host and the nonstandard port.
Tried the other usernames and pwds.
Not sure wherein the error lies.
I can keep trying but no luck so far.

Perhaps a new database with the login and username that matches the postgresql user?

seems a branchy tree.

Lewis

Hi Lewis,

sorry, I don't have Windows available to help you. Maybe this documentation will help you to setup PostgreSQL: http://drupal.org/node/2279

Hi,

I figured out the root for the postgresql superuser drupal wanted, a bit convoluted since that is how stack installer sets up postgresql with drupal database, superuser database, and then of course your own post gis database. luckily there was an extra empty database for the superuser to drop cartaro in (the superuser database).

On installation I get the site on localhost, access denied. Perhaps the instance of geoserver I did not usethe url?
Guess I will have to figure out editing some access file or other.

Thanks for your help.

You may want to see my comment here, which is related to your problem:
http://drupal.org/node/1822002#comment-6657340

My comment is at #5. I could give you additional/further details if you need it. :)

Can someone please review and tell me what I am missing. I am stuck on the last page, last bullet (cartaro not recognizing PostGIS enabled database). Any assistance you could provide would be greatly appreciated. The hole in my wall is getting bigger daily from banging my head into it...

Can someone please review and tell me what I am missing. I am stuck on the last page, last bullet (cartaro not recognizing PostGIS enabled database). Any assistance you could provide would be greatly appreciated. The hole in my wall is getting bigger daily from banging my head into it...

This is related to my previous post here: http://drupal.org/node/1822002#comment-6657340

One of my configurations involve the following stack:
XAMPP 1.8.1 (Apache 2.4.3, PHP 5.4.7) + Cartaro (beta2) + OpenGeo Suite 3 CE (PostgreSQL 9.1, PostGIS 2.0, GeoServer 2.2). Note that in XAMPP, I just need the Apache Server & PHP Engine, in short, MySQL is not needed here. Cartaro requires an Apache web server, PHP interpreter, PostgreSQL+PostGIS database server, & GeoServer map server. Your configuration has satisfied the server requirements, yet, it has no 'cartaro' PostGIS database, instead you've created a 'cartaro' MySQL database which is not needed in this context.

In a nutshell, you must create a 'cartaro' PostGIS spatial database, then, make it the target database for the installation. Do not use the MySQL database since Cartaro requires a PostgreSQL + PostGIS database. PostGIS is an extension of PostgreSQL and is used for measuring area, distances, etc. User data & profiles and other non-spatial data are handled just as a regular PostgreSQL data.. I've attached also here the installation guide I've used in other configuration, I've documented it before for OpenGeo Suite 2.5, but the steps & results are the same. :)

Thanks IKE0088 for trying to put together a nice step-by-step guide. I think a few clarifications which are basically the same as visions' are necessary since not all steps are correct:

• There is no need to install MySQL. Cartaro uses Postgres (with PostGIS) only due to its capabilities for working with spatial data. MySQL's support for spatial data is not enough for Cartaro and therefore MySQL cannot be used.
• Drupal needs to use the Postgres database in step 3 of “Installing Drupal / Cartaro”. Other databases won't do (until they implement proper support for spatial data).

The reason that you are stuck in the end is that Drupal was installed into a MySQL database. PostGIS is not available there and so the installation cannot be successfully completed.

I was finally able to get it working. Kuddos to Visions and Augustus. One thing I did have to add was copying the libpq.dll from "xampp/php" to the "xampp/apache/bin" directory.

Might be another bug, but upon installation of sample data, Cartaro presents all locations with the same location (middle of the ocean). See attached. Any thoughts?

That's a bug with Cartaro beta2 version, the solution is to use the Cartaro dev version + PostGIS dev version. Note that the Cartaro dev version doesn't ship with the PostGIS dev version, you must download the PostGIS dev version & overwrite the postgis folder in the Cartaro dev version before installing or re-installing it.

See my detailed issue report & the solution given by friedjoff regarding this issue:
http://drupal.org/node/1824990

clarification