> Let's assume my backends are Linux boxes. On them only root and postgres > users are defined (at OS level). In Postgres server, I defined an > additionnal user "rouser", so that my Postgres base has 2 users : postgres > and rouser. > > In my understanding, I should be able to do the following to access > pgpool-test database logging with that user : > > psql -p 9999 pgpool-test -U rouser > > Unfortunately, the authentication fails, because my pool_passwd doesn't > include a line like this : > > rouser:md5XXXXXXXXXXXXXXXXXXXXX > > Since XXXXXXXXXXXX is not equal to MD5(password), does anyone have a trick ? > I Wish I need not create a "rouser" Linux user for this, nor use postgres > user. > > The pg_md5.c code shows : > > pw = getpwuid(getuid()); > ... > > pg_md5_encrypt(password, pw->pw_name, strlen(pw->pw_name), md5); > > Which is not very encouraging...
Probably pg_md5 should have "-u user" option or something like this, which allows pgpool super user to create an entry in pool_passwd corresonding to non OS user entry. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
