[Pgpool-hackers] General SSL question

[Tatsuo Ishii]

As the error message says, pgpool-II does not support MD5
authentication. Plesae use trust or clear text password
authentication.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I'm new to pgpool implementation. I'm following the examples in the tutorial
> and am having difficulty with the configuring replication setup.  I've found
> very some info on this, but it
> a bit confusing.
> 
> Thanks in advance.
> 
> Ted
> 
> 
> Here are my steps.  I've configured pgpool.config with 5 nodes with 
> replication and load balancing set to true.
> 
> I've setup 5 postgres instances on the same machine using port 5432-5436.
> Each instance has its own data directory.
> 
> For example, postmaster -D /opt/PostgreSQL/8.4/data -h localhost
> -p 5432 &
> 
> 
> Port 5432 is the master.
> 
> I'm using localhost as the host so that everything is contained on a single
> machine.
> 
> I've executed this command to start the server: 
> /opt/bin/pgpool -c -f /usr/local/etc/pgpool.conf -F /usr/local/etc/pcp.conf
> -a /usr/local/etc/pool_hba.conf -n -d
> 
> And, I've attempted to replicate a database with this: 
> createdb -p 9999 -U postgres  bench_replication -T template_postgis -W
> 
> I get the followong message:
> createdb: could not connect to database postgres: ERROR:  MD5 authentication
> is unsupported in replication, master-slave and parallel modes.
> HINT:  check pg_hba.con
> 
> The server logs shows:
> 
> 2010-04-30 23:38:29 DEBUG: pid 29493: I am 29493 accept fd 5
> 2010-04-30 23:38:29 DEBUG: pid 29493: Protocol Major: 3 Minor: 0 database: 
> postgres user: postgres
> 2010-04-30 23:38:29 DEBUG: pid 29493: new_connection: connecting 0 backend
> 2010-04-30 23:38:29 DEBUG: pid 29493: new_connection: connecting 1 backend
> 2010-04-30 23:38:29 DEBUG: pid 29493: pool_ssl: SSL requested but SSL support
> is not available
> 2010-04-30 23:38:29 DEBUG: pid 29493: pool_ssl: SSL requested but SSL support
> is not available
> 2010-04-30 23:38:29 DEBUG: pid 29493: pool_read_message_length: slot: 0 length:
> 12
> 2010-04-30 23:38:29 DEBUG: pid 29493: pool_read_message_length: slot: 1 length:
> 12
> 
> _______________________________________________
> Pgpool-hackers mailing list
> Pgpool-hackers at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-hackers