I'm using vpopmail 5.4.10 successfully with PostgreSQL. How about permissions for your vpopmail sql user? Did you GRANT that user permissions to the database?
How about trying to use the "postgres" user? Kind of like using "root" so I wouldn't leave it that way but at least it may indicate if it's a permissions issue? How about running the commandline utilities? /home/vpopmail/bin/vuserinfo <email addy> Does that yield a failed connection as well? Charlie > -----Original Message----- > From: Joshua Coucke [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 31, 2005 7:08 AM > To: vchkpw@inter7.com > Subject: [vchkpw] Switching from Mysql to Postgresql > > Hey, > > I used the QMR install with the MySQL option to install > vpopmail. Now, however, I need to switch from MySQL to > PostgreSQL as the backend for the whole thing. The problem I > am having is that when I recompile vpopmail to use PostgreSQL > and then procede to check my email I get an error telling me > that authorazation failed. > > As far as I can tell I have provided the correct username and > database for vpopmail in the vpgsql.h file. And I have > imported into postgres the database from mysql. > > The other odd thing is that vqadmin and qmailadmin still seem > to be using the mysql database after recompiling vpopmail for > use with postgres. > > I am using vpopmail v5.4.10, postgres v8.0.1, and Fedora Core 3. > > Any ideas on the subject would be helpful. > > I tried to google for this but nothing came up. > > Joshua Coucke > > > >
