Re: [Bacula-users] Trying to get bacula working with postgres
I got it to work. I had to add the following line to /etc/postgresql/8.1/main/pg_hba.conf: hostbacula bacula,root 127.0.0.1/32 trust Bacula is connecting with TCP/IP, not a Unix domain socket. This was confusing me. Thanks for your help. I would definitely recommend that you switch that to using Unix domain sockets. That can give you significantly better pure-transfer performance from PostgreSQL, depending on the exact platform. //Magnus - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Trying to get bacula working with postgres
On Wed, 23 Aug 2006, Magnus Hagander wrote: I got it to work. I had to add the following line to /etc/postgresql/8.1/main/pg_hba.conf: hostbacula bacula,root 127.0.0.1/32 trust Bacula is connecting with TCP/IP, not a Unix domain socket. This was confusing me. Thanks for your help. I would definitely recommend that you switch that to using Unix domain sockets. That can give you significantly better pure-transfer performance from PostgreSQL, depending on the exact platform. Ditto for mysql, if it's not using Unix domain sockets already. AB - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Trying to get bacula working with postgres
On Tue, Aug 22, 2006 at 03:39:03PM -0700, Scott Simpson wrote: I'm trying to get bacula working with Postgres but I'm having trouble getting the director to connect. I can connect to Postgres as bacula: sh-3.1$ id uid=118(bacula) gid=118(bacula) groups=26(tape),118(bacula) sh-3.1$ psql -Ubacula bacula Welcome to psql 8.1.4, the PostgreSQL interactive terminal. In this case, the unix user bacula is connecting as the postgres bacula user. This works. So far, so good. Next I try running the director manually: [EMAIL PROTECTED]:/etc/bacula# /usr/sbin/bacula-dir -c /etc/bacula/bacula-dir.conf -u bacula -g bacula 22-Aug 15:33 bacula-dir: Fatal error: Could not open database bacula. 22-Aug 15:33 bacula-dir: Fatal error: postgresql.c:174 Unable to connect to PostgreSQL server. In this case, the unix root user is connecting as the postgres bacula user. It fails. If as root you try to connect to postgres using the same psql command as above, does it still work? Also, what database authentication mechanism are you using? - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Trying to get bacula working with postgres
On Tuesday 22 August 2006 15:54, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED]:/etc/bacula# /usr/sbin/bacula-dir -c /etc/bacula/bacula-dir.conf -u bacula -g bacula 22-Aug 15:33 bacula-dir: Fatal error: Could not open database bacula. 22-Aug 15:33 bacula-dir: Fatal error: postgresql.c:174 Unable to connect to PostgreSQL server. In this case, the unix root user is connecting as the postgres bacula user. It fails. If as root you try to connect to postgres using the same psql command as above, does it still work? Also, what database authentication mechanism are you using? I'm passing the -u bacula option to bacula-dir to run as the bacula user. Are you saying that it connects to postgres BEFORE doing a seteuid(2) call? If so, that is weird. I would think if I tell the bacula-dir command to run as bacula it should connect to postgres as bacula not root. - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Trying to get bacula working with postgres
I got it to work. I had to add the following line to /etc/postgresql/8.1/main/pg_hba.conf: hostbacula bacula,root 127.0.0.1/32 trust Bacula is connecting with TCP/IP, not a Unix domain socket. This was confusing me. Thanks for your help. Scott - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users