JDBC No jalan !!!!

Israel Zavalza Bahena izavalza@buzon.contanet.mx
Fri, 05 Jun 1998 12:37:42 -0600


ya, ya esta....


hay que darle enel booteo del postmaster la opcion -i....



gracias, y si tienen el 6.1 se los agradecere....




bye



Israel Zavalza Bahena wrote:
> 
> Posiblemente, el problemita no esta en los JDBC's sino el los sockets
> Unix de postgresql...
> 
> doy esto  desde otra maquina ...
> 
> # psql -h icaro
> Connection to database 'root' failed.
> connectDB() failed: Is the postmaster running and accepting TCP/IP(with
> -i) connections at 'icaro' on port '5432'?
> #
> 
> y para verificar, doy telnet desde otra maquina...
> 
> $ telnet zeus 5432
> Trying 200.34.40.125...
> telnet: Unable to connect to remote host: Connection refused
> $ telnet icaro 5432
> Trying 200.34.40.65...
> telnet: Unable to connect to remote host: Connection refused
> $
> 
> este es mi archivo de configuracion pg_hba localizado en
> /usr/local/pgsql/data...
> 
> # The above would allow anyone anywhere except from 192.168.0.1 to
> connect to
> # any database under any username.
> 
> #host         all        192.168.0.0  255.255.255.0      ident
> omicron
> #
> # The above would allow users from 192.168.0.x hosts to connect to any
> # database, but if e.g. Ident says the user is "bryanh" and he requests
> to
> # connect as Postgres user "guest1", the connection is only allowed if
> # there is an entry for map "omicron" in pg_ident.conf that says
> "bryanh" is
> # allowed to connect as "guest1".
> 
> # By default, allow anything over UNIX domain sockets and localhost.
> 
> local        all                                         trust
> host         all         127.0.0.1     255.255.255.255   trust
> host         all         0.0.0.0       255.255.255.255   trust
> 
> Estoy haciendo algo mal?    me falta algo? POR FAVOR  !!!!!!
> 
> gracias.
> 
> Israel Zavalza Bahena wrote:
> >
> > Hola ...
> >
> > tengo un problemita con los JDBC's para postgresql-6.3.2
> >
> > Tengo ya compilado el programa en un RedHat y Solaris, corriendo el
> > demonio de postmaster...
> >
> > PERO, a la hora de querer probar la interfase java con los ejemplos,
> > aparece el siguiente mensaje ...
> >
> > # java example.psql jdbc:postgresql:regression postgres checo
> > PostgreSQL psql example v6.3 rev 1
> >
> > Connecting to Database URL = jdbc:postgresql:regression
> > Exception caught.
> > java.sql.SQLException: Connection failed: java.net.ConnectException:
> > Connection refused
> > java.sql.SQLException: Connection failed: java.net.ConnectException:
> > Connection refused
> >         at postgresql.Connection.<init>(Connection.java:190)
> >         at postgresql.Driver.connect(Driver.java:87)
> >         at java.sql.DriverManager.getConnection(DriverManager.java:91)
> >         at java.sql.DriverManager.getConnection(DriverManager.java:134)
> >         at example.psql.<init>(psql.java:30)
> >         at example.psql.main(psql.java:204)
> >
> > Tengo otra maquina con Postgres 6.1 y Linux Slackware, y alli jalan los
> > drivers sin problema....
> >
> > alguna idea ?
> >
> > Gracias.