Drupal on Ingres 10.0?

[jason_d_becker]

Hey All,

I'm pretty new to Ingres, trying to get Drupal working on Ingres 10.0 (126) on Fedora 12.

I actually got it installed without too much trouble by following the instructions here for the most part.

The only real departure AFAICT is that I edited /etc/sysconfig/httpd to include the II_SYSTEM and LD_LIBRARY_PATH instead of sourcing the .ingIIbash env file in the init script and I also created a /etc/httpd/conf.d/ingres.conf for the PassEnv directive instead of including it directly in httpd.conf.

I'm using SQuirreL to explore the drupal DB which requires a password for the apache user so I set one (this is after I installed Drupal which did not require a password). I have since edited settings.php to pass the password in the db_url, i.e.:

$db_url = 'ingres://apache:password@localhost/drupal';

But that doesn't seem to help - I get the White Screen of Death. This is what I get in the Apache error_log:

[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Warning:  ingres_query(): Error: 7 - Unable to close non-result resource statement in /var/www/html/drupal/includes/database.ingres.inc on line 87
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Warning:  ingres_query(): Error: 7 - Unable to close non-result resource statement in /var/www/html/drupal/includes/database.ingres.inc on line 266
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Warning:  ingres_fetch_object(): An error occurred whilst fetching a BLOB in /var/www/html/drupal/includes/database.ingres.inc on line 310
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Warning:  \nquery: SELECT * FROM variable in /var/www/html/drupal/includes/database.ingres.inc on line 294
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Notice:  Undefined variable: variables in /var/www/html/drupal/includes/bootstrap.inc on line 480
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Warning:  ingres_query(): An error occurred when preparing a query for DESCRIBE INPUT in /var/www/html/drupal/includes/database.ingres.inc on line 263
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Warning:  The connection to the server has been aborted.\nquery: UPDATE cache SET data = ?, created = 1279669961, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /var/www/html/drupal/includes/database.ingres.inc on line 294
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Notice:  Undefined variable: variables in /var/www/html/drupal/includes/bootstrap.inc on line 487
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Warning:  The connection to the server has been aborted.\nquery: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /var/www/html/drupal/includes/database.ingres.inc on line 294
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Warning:  The connection to the server has been aborted.\nquery: SELECT COUNT(pid) FROM url_alias in /var/www/html/drupal/includes/database.ingres.inc on line 294
[Tue Jul 20 17:52:41 2010] [error] [client ::1] PHP Fatal error:  Unknown: An error occur when issuing an internal commit in Unknown on line 0

Like I said, it installed just fine. At the end of the install it did present me with these warnings:

* user warning: The DBMS cache is not configured for this page size. query: MODIFY cache_update TO BTREE UNIQUE ON cid WITH PAGE_SIZE=65536 in /var/www/html/drupal/includes/database.inc on line 529.
* user warning: The DBMS cache is not configured for this page size. query: CREATE INDEX cache_update_expire_idx ON cache_update (expire) WITH STRUCTURE = BTREE, PAGE_SIZE=65536 in /var/www/html/drupal/includes/database.inc on line 529.

I did enable "DMF Cache 64k" in cbf, i.e. it is set to ON so I'm not sure what's going on.

Would be nice to know there are people using Drupal with Ingres!

Cheers

[notnull]

Hi Jason,

Which version of Drupal have you installed?

We applied an Ingres specific patch to Drupal 6.17 and attempted an installation with Ingres 10.0.0. While the Drupal installer completes, there were a few errors during operation that still need to be investigated.

[grant]

Hi Jason,

Originally Posted by jason_d_becker

I did enable "DMF Cache 64k" in cbf, i.e. it is set to ON so I'm not sure what's going on.

Did you re-start Ingres after enabling the 64k caché? Also what version of the Ingres PHP driver do you have installed?

regards

grant

[jason_d_becker]

Originally Posted by notnull

Hi Jason,
Which version of Drupal have you installed?

I installed trunk from here: apps - Revision 746: /drupal/trunk

Cheers

[jason_d_becker]

Originally Posted by grant

Hi Jason,

Did you re-start Ingres after enabling the 64k caché? Also what version of the Ingres PHP driver do you have installed?

regards

grant

No, I didn't. I have now and that may have fixed it! I am using 2.2.2 of the PECL Ingres driver.

I come from MySQL, Is there a list of Ingres "System Variables" that note whether they are dynamic or not? i.e. Require a restart?

Thanks!

[nick_bolton]

Anything you alter in cbf is not dynamic.

Some things can be altered dynamically, but there is no centralised tool to amend those settings.

[dejan]

I do not want to start Ingres vs MySQL verbal war - I use and love both. Acually, let me correct mysql, I use MariaDB, not Oracle MySQL...
Back to the topic - I believe many things in MySQL are not "dynamic" either. They are just saved and once MySQL is restarted the new values are applied.
I agree Ingres may have more dynamic values. iisetres is supposed to be used to set those, if i am not mistaken.

[grant]

Hi Dejan,

As far as I am aware what nick_bolton says is true, at least for the DBMS server. iisetres is the command line interface to setting values in config.dat, iigetres being the command used to fetch values. It may be that CBF and VCBF use these commands for setting/fetching values.

A number of years ago there was talk about having some dynamic parameters but I don't believe it ever progressed beyond that.

regards

grant

[kschendel]

Grant is right, it's still just talk. Having the server refresh parameters dynamically sounds nice, but when it's easy to do, we will often have a SET statement of some sort that does it. Dynamically resetting memory parameters and cache settings starts to get tricky, and nobody has ever wanted it badly enough to push it through.

[schma01]

Hi Jason:
Good to see you fixed it and are making progress.
Mary