[GENERAL] pgAdmin3 question

2006-04-07 Thread lmyho
Hi All,

Have a question on pgAdmin3:

We have test database created in the initdb cluster, but on the Add Server page 
of
pgAdmin3, the Maintenance DB dropdown box does not show this database.  How can 
we
make it to display this db in the dropdown box too?  

As the Maintenance DB dropdown box doesn't show this test db, we have to allow 
the
owner of this test db (a new user created for this test db only) to access 'all'
database in the pg_hba.conf file in order to allow it to login through pgAdmin. 
And
once loged in, it of course has access to all databases including the postgres. 
 How
can we control this situation through pgAdmin?

Any help would be greatly appreciated.

Thanks,
leo

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [GENERAL] pgAdmin3 question

2006-04-07 Thread lmyho

--- Dave Page dpage@vale-housing.co.uk wrote:

  We have test database created in the initdb cluster, but on the Add Server 
  page
 of
  pgAdmin3, the Maintenance DB dropdown box does not show this database.  How 
  can
 we
  make it to display this db in the dropdown box too?  
 
 You can't without hacking the code. 

How to do this?

  As the Maintenance DB dropdown box doesn't show this test db, we have to 
  allow
 the
  owner of this test db (a new user created for this test db only) to access 
  'all'
  database in the pg_hba.conf file in order to allow it to login through 
  pgAdmin.
 And
  once loged in, it of course has access to all databases including the 
  postgres. 
 How
  can we control this situation through pgAdmin?
 
 No, you don't have to allow access to all databases. You can type the name of 
 the
 preferred maintenance DB, 

Yea! Worked by typing the new db name!  Sorry didn't notice that we can type a 
name
into the dropdown box.:(

Thank you!

A further question: we are using Debian system.  So when we leave the 'Address' 
box
blank (on the Add Server page of pgAdmin), according to the help file, it will 
go to
use the default Postgresql socket on the local machine. 
 We actually have a line as 'local all all   ident sameuser' in the pg_hba.conf
file.  But when I tried, pgAdmin couldn't log the user in and shows Ident
Authentication Failed.  Then I modified the line pg_hba.conf file to 'local 
all all
 ident', and aaded a map line in the pg_ident.conf file to map the new user to 
user
'postgres'.  Still not work.

What has I done wrong?  Or how should I use the ident authen way through 
pgAdmin?

Thank you for your help!!

regards,
leo

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[GENERAL] Debian package for freeradius_postgresql module

2006-04-06 Thread lmyho
Hello All,

We have a project which is built on postgresql and freeradius on debian system. 
I
have installed postgresql-8.1 on the Debian system, and lately freeradius-1.1.0
also. Things seems ok, but when we started to test, we found that the postgresql
module of freeradius is missing in the debian distribution! 

After desperately checking, we were told that debian doesn't distribute the 
binary
module of freeradius for postgresql because of the incompatible license of 
these two
apps! However we can build the debian pkg from the source ourself if we need.  
So
we did it.  But this problem: we got so many...so many warnings during the 
process
of building the debian packages, tons of the warnings!  So although we have the
packages now, we don't know if we can use them with so many so many warnings??!

I want to post some of the warnings here for your advice.  Please tell me with 
such
kind of warnings, will the built packages still usable??  Further more, I am 
afraid
it is because our system is not purly dev system, so that we got those 
warnings...
so, if any one of you could possibly help us to get a v1.1.0 postgresql module 
of
freeradius, I would be so much grateful!! Or, if you can help us to get the 
newest
v1.1.1 freeradius package set fro debian (include the postgresql module), that 
will
be great also!  I deeply hope to get help from you...  

We specifically need this module bacause the codes in postgresql to work with
freeradius have been built, can't imagine all work will be trashed...:(


Please see the warning samples:

radius.c: In function 'make_secret':
radius.c:167: warning: pointer targets in passing argument 2 of 
'librad_MD5Update'
differ in signedness
radius.c: In function 'make_passwd':
radius.c:205: warning: pointer targets in passing argument 2 of 
'librad_MD5Update'
differ in signedness
radius.c: In function 'make_tunnel_passwd':
radius.c:294: warning: pointer targets in passing argument 2 of 
'librad_MD5Update'
differ in signedness

rlm_passwd.c: In function 'build_hash_table':
rlm_passwd.c:218: warning: pointer targets in passing argument 1 of 'hash' 
differ in
signedness
rlm_passwd.c:232: warning: pointer targets in passing argument 1 of 'hash' 
differ in
signedness
rlm_passwd.c: In function 'get_pw_nam':
rlm_passwd.c:299: warning: pointer targets in passing argument 1 of 'hash' 
differ in
signedness
rlm_passwd.c: In function 'passwd_authorize':
rlm_passwd.c:536: warning: pointer targets in assignment differ in signedness
rlm_preprocess.c: In function 'cisco_vsa_hack':
rlm_preprocess.c:126: warning: pointer targets in passing argument 1 of
'__builtin_strchr' differ in signedness
rlm_preprocess.c:144: warning: pointer targets in assignment differ in 
signedness
rlm_preprocess.c: In function 'rad_mangle':
rlm_preprocess.c:203: warning: pointer targets in passing argument 1 of
'__builtin_strchr' differ in signedness
rlm_preprocess.c:206: warning: pointer targets in passing argument 1 of 'strcpy'
differ in signedness
rlm_preprocess.c: In function 'huntgroup_access':
rlm_preprocess.c:375: warning: pointer targets in passing argument 1 of 
'strNcpy'
differ in signedness
rlm_preprocess.c:376: warning: pointer targets in passing argument 1 of 'strlen'
differ in signedness
rlm_preprocess.c: In function 'add_nas_attr':
rlm_preprocess.c:404: warning: pointer targets in passing argument 1 of
'ip_hostname' differ in signedness
rlm_preprocess.c:425: warning: pointer targets in passing argument 1 of
'ip_hostname' differ in signedness
rlm_radutmp.c: In function 'radutmp_checksimul':
rlm_radutmp.c:658: warning: pointer targets in assignment differ in signedness
rlm_realm.c: In function 'check_for_realm':
rlm_realm.c:209: warning: pointer targets in passing argument 1 of 'strcpy' 
differ
in signedness
rlm_sql.c: In function 'sql_groupcmp':
rlm_sql.c:564: warning: pointer targets in passing argument 1 of 'strlen' 
differ in
signedness
rlm_sql.c:564: warning: pointer targets in passing argument 2 of 
'__builtin_strcmp'
differ in signedness
rlm_sql.c:564: warning: pointer targets in passing argument 2 of 
'__builtin_strcmp'
differ in signedness
rlm_sql.c:564: warning: pointer targets in passing argument 1 of 'strlen' 
differ in
signedness
rlm_sql.c:564: warning: pointer targets in passing argument 2 of 
'__builtin_strcmp'
differ in signedness
rlm_sql.c:564: warning: pointer targets in passing argument 2 of 
'__builtin_strcmp'
differ in signedness
rlm_sql.c: In function 'rlm_sql_authorize':
rlm_sql.c:824: warning: pointer targets in assignment differ in signedness
rlm_sql.c: In function 'rlm_sql_checksimul':
rlm_sql.c:1227: warning: pointer targets in assignment differ in signedness
...

Please advise me if these warnings are serious??  

Any help would be greatly appreciated!  Thank you!!

Regrads,
leo

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---(end of 

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-06 Thread lmyho

  After desperately checking, we were told that debian doesn't distribute the
 binary
  module of freeradius for postgresql because of the incompatible license of 
  these
 two
  apps! However we can build the debian pkg from the source ourself if we 
  need. 
 So
 
 Sounds terribly unlikely, PostgreSQLs licence doesn't conflict with any
 use anywhere. Can you provide a reference?
 

I wish things are not like this too! so I won't have to go through so much 
trouble! 
But that's what happened:-( 

This is the ref was given:
The old / original BSD license is not compatible.
http://www.gnu.org/licenses/license-list.html#GPLIncompatibleLicenses 

Anyway to change this?? So debian users can easily use postgresql and freeradius
together...

Thanks!!

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq