Re: Problems with horde-imp under postgresql
Hello, Horde/Imp/PostgreSql works perfect. In our Company we have this installation, specially we have installed the tar.gz files from horde.org Unpack the horde.tar.gz (v2.0) into your webroot, the imp into the horde-folder. Your problem is, the access-permissions in the file pg_hba.conf. The difference between mysql and postgresql is, that you define the access-permission in that file and NOT in the database. If you db and your horde installation is on the same host, then you can put the following lines to this file. localall password host all 127.0.0.1 255.0.0.0 password Put this lines in front of the other settings oder comment them out. In my opinion this concept is much more powerfull than the mysql-concept. Our installation was tested about over 10 weeks successfully and will go in production next time. Greeting Sven signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: Problems with horde-imp under postgresql
Hello, Horde/Imp/PostgreSql works perfect. In our Company we have this installation, specially we have installed the tar.gz files from horde.org Unpack the horde.tar.gz (v2.0) into your webroot, the imp into the horde-folder. Your problem is, the access-permissions in the file pg_hba.conf. The difference between mysql and postgresql is, that you define the access-permission in that file and NOT in the database. If you db and your horde installation is on the same host, then you can put the following lines to this file. localall password host all 127.0.0.1 255.0.0.0 password Put this lines in front of the other settings oder comment them out. In my opinion this concept is much more powerfull than the mysql-concept. Our installation was tested about over 10 weeks successfully and will go in production next time. Greeting Sven signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: Problems with horde-imp under postgresql
Hummm, I'm using the default configuration, right from the "box", though I agree with you. I been scrambling my postgres config files and get no result. Can you give me any lead. Thanks, rak On Wed, Oct 09, 2002 at 05:53:33PM +0200, Christian Zagrodnick wrote: > Hi > > you have chosen ident authentication meaning dbuser == systemuser which > is proably not the case. So change the authentication scheme used to > something usefull. :) > > On Wed, Oct 09, 2002 at 12:59:30PM -0300, UnKnown wrote: > > Hi all, again, I'm having some troubles configuring the imp, after traying > > allmost evrything, I still recive the same error when opening the imp page > > > > Trascrip.. > > > > Warning: Unable to connect to PostgresSQL server: FATAL 1: IDENT > > authentication failed for user "hordemgr" in /etc/horde/db_pgsql.inc on line > > 40 > > > > Warning: 0 is not a PostgresSQL link index in /etc/horde/db_pgsql.inc on > > line 52 > > > > > > The user hordemgr exist the password is double check, y work this several > > times, permisions ar as follow, default by the way... > > > > horde=# \dp > >Access privileges for database "horde" > > Table | Access privileges > > -+--- > > active_sessions | {=,postgres=arwdRxt,hordemgr=arw} > > auth_user | {=,postgres=arwdRxt,hordemgr=arw} > > auth_user_md5 | {=,postgres=arwdRxt,hordemgr=arw} > > imp_addr| {=,postgres=arwdRxt,hordemgr=arw} > > imp_pref| {=,postgres=arwdRxt,hordemgr=arw} > > (5 rows) > > > > horde=# > > > > > > So, if you got any idea is well came. > > > > Cherss, > > rak > > > > > > -- > > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > > -- > Christian Zagrodnick > > gocept gmbh & co. kg - schalaunische strasse 6 - 06366 koethen/anhalt > fon. +49 3496 3099114 - fax. +49 3496 3099118 - mob. +49 173 9078826 >
Re: Problems with horde-imp under postgresql
Hummm, I'm using the default configuration, right from the "box", though I agree with you. I been scrambling my postgres config files and get no result. Can you give me any lead. Thanks, rak On Wed, Oct 09, 2002 at 05:53:33PM +0200, Christian Zagrodnick wrote: > Hi > > you have chosen ident authentication meaning dbuser == systemuser which > is proably not the case. So change the authentication scheme used to > something usefull. :) > > On Wed, Oct 09, 2002 at 12:59:30PM -0300, UnKnown wrote: > > Hi all, again, I'm having some troubles configuring the imp, after traying > > allmost evrything, I still recive the same error when opening the imp page > > > > Trascrip.. > > > > Warning: Unable to connect to PostgresSQL server: FATAL 1: IDENT > > authentication failed for user "hordemgr" in /etc/horde/db_pgsql.inc on line > > 40 > > > > Warning: 0 is not a PostgresSQL link index in /etc/horde/db_pgsql.inc on > > line 52 > > > > > > The user hordemgr exist the password is double check, y work this several > > times, permisions ar as follow, default by the way... > > > > horde=# \dp > >Access privileges for database "horde" > > Table | Access privileges > > -+--- > > active_sessions | {=,postgres=arwdRxt,hordemgr=arw} > > auth_user | {=,postgres=arwdRxt,hordemgr=arw} > > auth_user_md5 | {=,postgres=arwdRxt,hordemgr=arw} > > imp_addr| {=,postgres=arwdRxt,hordemgr=arw} > > imp_pref| {=,postgres=arwdRxt,hordemgr=arw} > > (5 rows) > > > > horde=# > > > > > > So, if you got any idea is well came. > > > > Cherss, > > rak > > > > > > -- > > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > > -- > Christian Zagrodnick > > gocept gmbh & co. kg - schalaunische strasse 6 - 06366 koethen/anhalt > fon. +49 3496 3099114 - fax. +49 3496 3099118 - mob. +49 173 9078826 > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Problems with horde-imp under postgresql
Quoting UnKnown <[EMAIL PROTECTED]>: > Hi all, again, I'm having some troubles configuring the imp, > after traying allmost evrything, This is about the only real problem that I have had with Debian in years of running it on my servers. When I was upgrading some time in May I think, IMP would not work with PostgresSQL. I did try for about a week with the users getting restless. > So, if you got any idea is well came. Give up and go for MySQL. >From my perception, the problem is the user / table creation / access is not abstract enough. e.g. There is no general "Debian" way to create a database user. The IMP developer has to recode for each database and changes in migrating of each to Debian could be breaking some thing that does work on other platforms. Is it a deb-conf, apt or .. what kind of problem? After moving to mySQL I have had no problems and think MySQL is more than good enough for this application. Regards [EMAIL PROTECTED]
Re: Problems with horde-imp under postgresql
Quoting UnKnown <[EMAIL PROTECTED]>: > Hi all, again, I'm having some troubles configuring the imp, > after traying allmost evrything, This is about the only real problem that I have had with Debian in years of running it on my servers. When I was upgrading some time in May I think, IMP would not work with PostgresSQL. I did try for about a week with the users getting restless. > So, if you got any idea is well came. Give up and go for MySQL. >From my perception, the problem is the user / table creation / access is not abstract enough. e.g. There is no general "Debian" way to create a database user. The IMP developer has to recode for each database and changes in migrating of each to Debian could be breaking some thing that does work on other platforms. Is it a deb-conf, apt or .. what kind of problem? After moving to mySQL I have had no problems and think MySQL is more than good enough for this application. Regards [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Problems with horde-imp under postgresql
Hi all, again, I'm having some troubles configuring the imp, after traying allmost evrything, I still recive the same error when opening the imp page Trascrip.. Warning: Unable to connect to PostgresSQL server: FATAL 1: IDENT authentication failed for user "hordemgr" in /etc/horde/db_pgsql.inc on line 40 Warning: 0 is not a PostgresSQL link index in /etc/horde/db_pgsql.inc on line 52 The user hordemgr exist the password is double check, y work this several times, permisions ar as follow, default by the way... horde=# \dp Access privileges for database "horde" Table | Access privileges -+--- active_sessions | {=,postgres=arwdRxt,hordemgr=arw} auth_user | {=,postgres=arwdRxt,hordemgr=arw} auth_user_md5 | {=,postgres=arwdRxt,hordemgr=arw} imp_addr| {=,postgres=arwdRxt,hordemgr=arw} imp_pref| {=,postgres=arwdRxt,hordemgr=arw} (5 rows) horde=# So, if you got any idea is well came. Cherss, rak
Problems with horde-imp under postgresql
Hi all, again, I'm having some troubles configuring the imp, after traying allmost evrything, I still recive the same error when opening the imp page Trascrip.. Warning: Unable to connect to PostgresSQL server: FATAL 1: IDENT authentication failed for user "hordemgr" in /etc/horde/db_pgsql.inc on line 40 Warning: 0 is not a PostgresSQL link index in /etc/horde/db_pgsql.inc on line 52 The user hordemgr exist the password is double check, y work this several times, permisions ar as follow, default by the way... horde=# \dp Access privileges for database "horde" Table | Access privileges -+--- active_sessions | {=,postgres=arwdRxt,hordemgr=arw} auth_user | {=,postgres=arwdRxt,hordemgr=arw} auth_user_md5 | {=,postgres=arwdRxt,hordemgr=arw} imp_addr| {=,postgres=arwdRxt,hordemgr=arw} imp_pref| {=,postgres=arwdRxt,hordemgr=arw} (5 rows) horde=# So, if you got any idea is well came. Cherss, rak -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]