Re: Postgesql and SSL

oh yeah i forgot to show you that it's linked successfully:

# sudo ldd /home/`whoami`/Software/PostgreSQL-9/bin/* | grep ssl
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00cc4000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00214000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00e9b000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00110000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00110000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x0044f000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x0061b000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00110000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x004fb000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00b1a000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00284000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00135000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x004b6000)
        libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00603000)

On Fri, Mar 19, 2010 at 1:33 PM, Kiswono Prayogo <kiswono@gmail.com> wrote:
> Hi, i had the same problem building using latest cvs, it works fine on
> 64-bit ubuntu, but on 32-bit ubuntu (virtualbox) when i started the
> postgres it shows:
> # idir=/home/`whoami`/Software/PostgreSQL-9
> # sudo su -p postgres -c "$idir/bin/postgres -D $idir/data" ;
> LOG: SSL is not supported by this build
> FATAL: invalid value for parameter "ssl": 1
>
> * normally on my 64-bit, it shows:
> LOG:  database system was shut down at 2010-03-19 12:02:00 WIT
> LOG:  autovacuum launcher started
> LOG:  database system is ready to accept connections
> ... query errors goes here ...^C
> LOG:  received fast shutdown request
> LOG:  aborting any active transactions
> LOG:  autovacuum launcher shutting down
> LOG:  shutting down
> LOG:  database system is shut down
>
> * my configuration (32-bit and 64-bit differ only on shared_buffers value)
> # idir=/home/`whoami`/Software/PostgreSQL-9
> # sudo cat $idir/data/postgresql.conf | egrep -v "^\s*(#|$)"
> listen_addresses = 'localhost'          # what IP address(es) to listen on;
> port = 5432                             # (change requires restart)
> max_connections = 100                   # (change requires restart)
> unix_socket_directory = '/tmp'          # (change requires restart)
> ssl = true                              # (change requires restart)
> password_encryption = on
> shared_buffers = 28MB                   # min 128kB
> datestyle = 'iso, mdy'
> lc_messages = 'en_US.UTF-8'                     # locale for system
> error message
> lc_monetary = 'en_US.UTF-8'                     # locale for monetary formatting
> lc_numeric = 'en_US.UTF-8'                      # locale for number formatting
> lc_time = 'en_US.UTF-8'                         # locale for time formatting
> default_text_search_config = 'pg_catalog.english'
>
> * my build configuration:
> # idir=/home/`whoami`/Software/PostgreSQL-9
> # ./configure --with-pam --with-openssl --with-libxml --with-libxslt
> --prefix=$idir && make && make install
>
> * installed libraries (dpkg -l | grep ssl):
> libssl-dev     0.9.8g-16ubuntu3.1
> openssl       0.9.8g-16ubuntu3.1
> libssl0.9.8    0.9.8g-16ubuntu3.1
>
> * full script for download, compile and configuring
> http://pastebin.com/vmzryH82
>
> --
> Regards,
> Kiswono P
> GB
>



--
Regards,
Kiswono P
GB