Hi, I've just installed Maypole 2.10 on FreeBSD 5.4 running Apache2,
mod_perl2 and Postgresql 7.4.8. I've applied the MVC.pm patch to
get Maypole working with Apache2 & mod_perl2. Here is what I did to
get the BeerDb working on the system.
Following the suggestions in the mailing list from David Baird,
I changed BeerDb.pm to connect to the database as follows:
BeerDB->setup("dbi:Pg:dbname=beerdb","wkt", "",
{ options => {AutoCommit => 1,PrintError => 1} } );
I found that Postgres could not create the BeerDb tables using the
schema provided in the Maypole documentation; specifically, with
create table brewery (
id int not null auto_increment primary key,
.... );
Postgresql cannot grok the "auto_increment" option.
I replaced this with the following column definition:
id serial PRIMARY KEY,
This allowed read access to the table, but the insertion of new records
failed. After changing the column definition to:
id serial NOT NULL PRIMARY KEY,
everything seems to work, including edits and insertions.
I hope this is of some use.
Cheers,
Warren
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Maypole-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/maypole-users
