RE: [gnome-db] alternative instructions to compile libgda on cygwin

[Rodrigo Moya <rodrigo gnome-db org>]

On Sun, 2002-07-07 at 00:46, Fernando Martins wrote:
> Hi!
> 
> Thanks, Daniel and Gonzalo, for your answers.
> 
> I made some dirty modifications [*] to ./configure in order to have the
> libgda compiled with the postgresql provider. No more errors at this point.
> Postgresql server is running fine and I'm now trying gda-test.
> 
you shouldn't be modifying configure, but configure.in. If people have
to modify configure, that means we'll have to hack it every time we do a
release for windows.

The correct fix is to make configure.in aware of the cygwin environment,
so that it compiles correctly on it. As I said in my previous post,
libxml (gnome-xml in CVS) and mono (http://www.go-mono.com) might check
for cygwin, since they both use autotools on windows and linux.

> After reading some code, I realised the first problem was an empty
> ~/.libgda/config file. I suppose this is normal and in Linux one could use
> gnome-db-fe to edit it. In cygwin, I guess I could have used
> gda-config-tool.exe but I found it simpler to copy libgda/data/config and
> hand-edit the file. This is the file I have. Please let me know if you find
> something wrong with it:
> 
> 
> <?xml version="1.0"?>
> <libgda-config>
> 	<section path="/apps/libgda/Datasources/postgres">
> 		<entry name="Provider" type="string" value="postgres"/>
> 		<entry name="Username" type="string" value="fmartins"/>
> 		<entry name="DSN" type="string"
> value="DSN=DATABASE=test;HOST=127.0.0.1;PORT=5432"/>
> 		<entry name="Description" type="string" value="postgresql test database"/>
> 	</section>
> </libgda-config>
> 
> 
> 
> The next error given by gda-test is:
> 
> 
> > =========================================
> > = Testing provider configuration API
> > =========================================
> > ** Message: ERROR: Error opening directory
> '/usr/local/lib/libgda/providers':
> > No such file or directory
> 
> followed in the end by:
> 
> > =========================================
> > = Testing GDA client API
> > =========================================
> >  Data source = postgres, User = fmartins
> > ** Message: ERROR: Error opening directory >
> '/usr/local/lib/libgda/providers':
> >  No such file or directory
> > ** Message: ERROR: Provider postgres is not installed
> > ** ERROR: could not open connection to postgres
> 
> These are the files I have in the providers directory (which exists, in
> fact):
> 
> libgda-default.a
> libgda-default.la
> libgda-postgres.a
> libgda-postgres.la
> 
> Any hints of what could be wrong?
> 
yes. The code checks explicitly for the .so version of the library
(gda_config_get_provider_list in gda-config.c). So, if the cygwin
compilation does not generate a .so file, we should maybe check for the
other versions.

Although I'd prefer if we could generate either the .so file, and make
no changes to the code, or the .dll file, and make a special case for
windows in the code.

cheers