Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-23 Thread Mark Kirkwood
[EMAIL PROTECTED] wrote: I got the answer that is in module config of postgresl-webmin , there is a check box for Use DBI to connect if available?yes nothe default is yes , but if I choosed no everything went fine. I also test it in the desktop mechine and get the same er

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-23 Thread G u i d o B a r o s i o
Sorry, just a fool tip, cause I haven't seen that you already done the pg_ctl stop && pg_ctl start ... (I mean, did you reload your conf settings?) Regards, Guido > > > I used you perl script and found the error => > > > [EMAIL PROTECTED] tmp]# perl relacl.pl > > > DBI connect('dbname=template1

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-23 Thread amrit
> Well, sure looks like you only have one running. Your data directory is > /var/lib/pgsql/data so lets see the files: > > /var/lib/pgsql/data/pg_hba.conf > /var/lib/pgsql/data/pg_ident.conf > /var/lib/pgsql/data/postmaster.opts > > Might also be useful to know any nondefault settings in postgresql

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-22 Thread Mark Kirkwood
[EMAIL PROTECTED] wrote: After being a detector I found that [EMAIL PROTECTED] ~]# rpm -qa|grep -i postgres postgresql-7.4.5-3.1.tlc postgresql-python-7.4.5-3.1.tlc postgresql-jdbc-7.4.5-3.1.tlc postgresql-tcl-7.4.5-3.1.tlc postgresql-server-7.4.5-3.1.tlc postgresql-libs-7.4.5-3.1.tlc postgresql-do

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-22 Thread amrit
> > I used you perl script and found the error => > > [EMAIL PROTECTED] tmp]# perl relacl.pl > > DBI connect('dbname=template1;port=5432','postgres',...) failed: FATAL: > IDENT > > authentication failed for user "postgres" at relacl.pl line 21 > > Error in connect to DBI:Pg:dbname=template1;port=54

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-21 Thread Mark Kirkwood
[EMAIL PROTECTED] wrote: I used you perl script and found the error => [EMAIL PROTECTED] tmp]# perl relacl.pl DBI connect('dbname=template1;port=5432','postgres',...) failed: FATAL: IDENT authentication failed for user "postgres" at relacl.pl line 21 Error in connect to DBI:Pg:dbname=template1;por

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-21 Thread amrit
> Ok - I must be looking at the *updated* FC3 distribution... > > I may have 'jumped the gun' a little - the situation I describe above > will prevent *any* access at all to Pg from webmin. If this is the case > then check you have (perl) DBI and (perl) DBD-Pg components installed. > > If on the ot

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-21 Thread Mark Kirkwood
Mark Kirkwood wrote: If on the other hand you can do *some* Pg admin from webmin, and you are only having problems with the grants then there is something it does not like about the *particular* statement. The way to debug this is to do a tiny perl DBI program that tries to execute the statement :

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-21 Thread Mark Kirkwood
[EMAIL PROTECTED] wrote: I would suspect a DBI/DBD installation issue, either perl DBI cannot find DBD-Pg (not installed ?) or DBD-Pg cannot find your Pg 7.4.5. I note that FC3 comes with Pg 7.4.6 - did you installed 7.4.5 from source? If so this could be why the perl database modules cannot find i

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-20 Thread amrit
> I would suspect a DBI/DBD installation issue, either perl DBI cannot > find DBD-Pg (not installed ?) or DBD-Pg cannot find your Pg 7.4.5. > > I note that FC3 comes with Pg 7.4.6 - did you installed 7.4.5 from > source? If so this could be why the perl database modules cannot find it > (you may ne

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-20 Thread Mark Kirkwood
[EMAIL PROTECTED] wrote: I newly installed the postgresql 7.4.5 and FC 3 in my server and transfer the data from 7.3.2 with just a few problems. After I use the webmin 1.8 to config the grant previllage to the users ,I found that there is an error in the grant previlege . postgresql --> Grant Previ

[PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

2005-02-20 Thread amrit
I newly installed the postgresql 7.4.5 and FC 3 in my server and transfer the data from 7.3.2 with just a few problems. After I use the webmin 1.8 to config the grant previllage to the users ,I found that there is an error in the grant previlege . postgresql --> Grant Previlege --> error select re