[Mono-list] mod_mono and postgres

John (Doc) Soliday jlsolida@gapac.com
18 Sep 2003 10:23:04 -0400


In the examples handled by index.aspx (default xsp/mono build), there
are some DB examples, the first of which is dbpage1.aspx.

I've got postgres running, I've created a database called "monotest",
created a table called "test" and the user monotest/monotest has been
granted "ALL" priviledges to the DB.

I still get an error with mod_mono, though:

OUTPUT FROM http://127.0.0.1:8080/mono/dbpage1.aspx in browser:
===============================================================
Database Error
Sorry, a database error has occurred. 

You should set up a database for user 'monotest', password 'monotest'
and dbname 'monotest'. 

Then modify the variables DBProviderAssembly, DBConnectionType and
DBConnectionString in server.exe.config file to fit your needs. 

The database should have a table called customers created with the
following command (or similar): 

CREATE TABLE "test" (
"person" character varying(256) NOT NULL,
"email" character varying(256) NOT NULL
);

The error was: 

 System.MissingMethodException: A missing method exception has occurred.
in <0x00042> 06 Mono.Data.PostgreSqlClient.PostgresLibrary:PQconnectdb
(string)
in <0x000ad> 00 Mono.Data.PostgreSqlClient.PgSqlConnection:Open ()
in <0x00194> 00 ASP.dbpage1_aspx:Page_Init (object,System.EventArgs)


I couldn't find a "server.exe.config" file, but
"mod-mono-server.exe.config" contains the following:
====================================================
        <add key="DBProviderAssembly"
             value="Mono.Data.PostgreSqlClient"/>
        <add key="DBConnectionType"
             value="Mono.Data.PostgreSqlClient.PgSqlConnection"/>
        <add key="DBConnectionString"
value="hostaddr=127.0.0.1;user=monotest;password=monotest;dbname=monotest"/>

Any ideas of why it's still complaining?

Thanks,

-- 
John (Doc) Soliday
Commerce Services
(404) 652-3343
jlsolida@gapac.com