Menu
▾
▴
[Identifiedmail-discuss] IIM web:db connectivity
|
From: Michael T. <mi...@mt...> - 2004-11-27 17:36:50
|
Most likely there's a permission problem on the database for IIM. When you psql, what user are you using? Is there a password for it? Currently IIM just uses the defaults when it connects which I think is just the postgres user (which it tries to create in the install script). Did your machine that you're installing on already have postgres users, etc? IIM was initially written for mysql too, but changed over because of their weird licensing issues. It appears that when I did that I didn't fully get the support for different users/hosts working again, and there's a bit of code support needed in vars.php to get that to work again. If that's what's going on, I'll give you the patch for that. Mike MW Mike Weiner \(5028\) writes: > I apologize if this has been asked earlier, i did check the archives which seem very light with email. I have installed iim on my mail server, which also will serve the web interface as well. And i believe i have the "signing" portion working just fine. However, i cannot seem to get the web application to connect to the database - i can successfully connect at the command line via 'psql iimdb -u' and log in with the admin user and password. When i try this using the web pages, served up on localhost (same box as postgresql db) i get "Could not connect to database" error on the webpage. Now, unfortunately i am more comfortable with MySQL than PostgreSQL but i do believe i have the database setup correctly. I created a db called iimdb and have 2 tables in the schema: > > iimdb=# \dt > List of relations > Schema | Name | Type | Owner > --------+----------+-------+---------- > public | bindings | table | postgres > public | domains | table | postgres > (2 rows) > > i did modify the pg_hba.conf file to allow both local and host connections. > > Can any one give me any pointers? Or have any advice at all to help me get this working? > > Thank you in advance > Michael Weiner > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> > <META NAME="Generator" CONTENT="MS Exchange Server version 6.5.6944.0"> > <TITLE>IIM web:db connectivity</TITLE> > </HEAD> > <BODY> > <!-- Converted from text/plain format --> > > <P><FONT SIZE=2>I apologize if this has been asked earlier, i did check the archives which seem very light with email. I have installed iim on my mail server, which also will serve the web interface as well. And i believe i have the "signing" portion working just fine. However, i cannot seem to get the web application to connect to the database - i can successfully connect at the command line via 'psql iimdb -u' and log in with the admin user and password. When i try this using the web pages, served up on localhost (same box as postgresql db) i get "Could not connect to database" error on the webpage. Now, unfortunately i am more comfortable with MySQL than PostgreSQL but i do believe i have the database setup correctly. I created a db called iimdb and have 2 tables in the schema:<BR> > <BR> > iimdb=# \dt<BR> > List of relations<BR> > Schema | Name | Type | Owner <BR> > --------+----------+-------+----------<BR> > public | bindings | table | postgres<BR> > public | domains | table | postgres<BR> > (2 rows)<BR> > <BR> > i did modify the pg_hba.conf file to allow both local and host connections.<BR> > <BR> > Can any one give me any pointers? Or have any advice at all to help me get this working?<BR> > <BR> > Thank you in advance<BR> > Michael Weiner<BR> > </FONT> > </P> > > </BODY> > </HTML> |
