UCOSP: status report #13
Wednesday, November 18, 2009

I have successfully built the code checked out from Geospatial,
with the dependencies of xerces 2.8 headers, libraries, jam, pax, and pam-devel, GEOS 3.2.0 libraries on Debian as a non-root user.

As I was running runbuild.sh, I ran into problems about the build script could not pick up some libraries(GEOS, LD) on the fly. It turned out to be the case that the path variables are runtime variables, it doesn't influence the linker. In another words, the path variables tell the build script where to find libraries when then are running, while the linker varibales tell the build script where to find the library when it's linking. The most updated code is adjusted such that it simplifies the process for non-root user to compile code.

Before running runbuild.sh, a non-root user need to:

export GEOS_LOC="/path/to/geos-3.2.0rc1/lib"
export GEOS_INC="/path/to/geos-3.2.0rc1/include"
export LD_LIBRARY_PATH=$GEOS_LOC:$LD_LIBRARY_PATH

Besides, if you are not using default libraries, such as using xerces 2.8 instead of 2.7, you need to put the following line to $INC_ROOT/src/tools/port/jam/bldenv
export XERCVERS=28


Chuck Thibert has provided me with a patch which comes with the adjustment for non-root users to start my first try to apply a patch. Alex Trofast and Andrew Ross also provided me with a diff that serves as a guide for me to go through the proper process of building a patch.

Now that I have already applied the patch from Chuck and successfully build Geospatial code. Next, apply the diff!

Posted byA nerdy girl at 7:02 PM 0 comments  

A couple of notes when compiling Geospatial with GEOS, GDAL, MapServer
Sunday, November 15, 2009

I have been following this to compile Geospatial under a Debian environment. There are a couple of notes that I want to make

  • As of date 2009-11-15, thanks to Frank Warmerdam, the above wiki says "--with-python" under the configuration of GDAL. However, it is still not clear why the python is required for GDAL. Since MapServer does not use it, and ogr2ogr does not require it. And that python extension for GDAL picks up gcc instead of g++ when make is run and to the point of compiling c++ code.
  • For the configuration of Mapserver, there is a more detailed description for getting the libraries that Mapserver needs to be build on. That provides the links in 1 place where to get: --with-ogr --with-gd=/usr --with-libiconv=/usr/local --with-png=/usr --with-proj --with-php=yes -with-agg=/usr --with-freetype --with-regex=system

Posted byA nerdy girl at 12:57 PM 0 comments  

UCOSP: status report #12
Friday, November 13, 2009

I have talked with the system administrator, Greg, Andrew, IRC to get me enough quota for the C code to build the code.

I am right now working on the install of the components and build the Ingres code hopefully within this weekend.

Posted byA nerdy girl at 7:03 AM 0 comments  

Labels: , ,

Running install.php of Drupal on Ingres
Friday, November 6, 2009

There are a couple of things to be watch out for before you run the install script:

  • Make sure that you have enable the rewrite module in Apache. To do this, uncomment the following line in \\Apache\conf\httpd.conf
    #LoadModule rewrite_module modules/mod_rewrite.so

  • We need to make sure Drupal will be able to use the modules. To do so, make sure we have these variables set to the following values, if not, then change them:
    • Options Indexes FollowSymLinks
    • AllowOverride All,
    • Order allow,deny
    • Allow from all

  • Since it may take longer than 30 seconds to run the install.php, therefore, we'd better change the maximum execution time in the php.ini located in where the command php -i gives you, to the following line: max_execution_time = 120
  • Make sure that you have the database with the name drupal created in Ingres by the following command: createdb drupal. For Windows user, this will create a database namely drupal with the username system. The command: createdb -uyourusername drupal will create a database with the DBA -uyourusername. By default, for Windows user, createdb -uyourusername drupal, where yourusername is not your windows account name, then you need to type destroydb -usystem drupal or destroydb -uyourusername drupal to delete the database


While you are installing, you should
  • Put drupal as your database name
  • Put username system if your Apache is running as a service, otherwise, put the usename that you've set your apache to be running as.
  • There you go :)

Posted byA nerdy girl at 9:42 AM 0 comments  

Fix: Drupal on Ingres, install.php warnings
Wednesday, November 4, 2009

While running the install script of Drupal on Windows XP, I came across the following warnings.

warning: ingres_query() [function.ingres-query]: Error: 7 - Unable to close non-result resource statement in /some_path_of_mine_where_drupal_sits/

Here is a list of actions that you can try out to make the list of warnings go away:
  • You might want to make sure that you have entered the correct user name (user name that apache runs as). Follow this to check if your Apache is running as a service or locally. If it is running as a service, put system as the user name, otherwise, put the windows account user name.
  • You might want to destroydb/createdb again because error messages during install could mess with it.
  • You might find it takes forever to delete the database, try restarting apache and goes again.


If all these don't work, try consulting the IRC channel #ingres :)

Posted byA nerdy girl at 2:49 PM 0 comments  

Labels: , ,

Fix: Drupal on Ingres,Your web server does not appear to support any common database types.

As of date 2009-Nov-04, Ingres support has not been integrated into the main Drupal product yet.

So when you run install.php under Drupal, if you "Your web server does not appear to support any common database types." Checkout the code from Ingres: http://code.ingres.com/apps/drupal/trunk instead of getting from Drupal.org

Posted byA nerdy girl at 8:42 AM 0 comments  

Labels: ,

Basic sql tutorial in Ingres

Here you go!

Posted byA nerdy girl at 7:26 AM 0 comments  

Labels: , ,

Subscribe to: Posts (Atom)