reset password
Author Message
Phobe
Posts: 40
Posted 11:51 Oct 03, 2010 |

Anyone get CSNS working with the CS3 databases? I'm getting the following error:

2010-10-03 11:42:33,983 ERROR JDBCExceptionReporter: Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host "96.229.212.220", user "cs520stu02", database "cs520stu02", SSL off)

I can't connect to the database using pgAdmin with a similar error as well. I had to use phppgadmin to execute my sql files.

cysun
Posts: 2935
Posted 12:35 Oct 03, 2010 |

The PostgreSQL database on CS3 is configured to only allow connections from Cal State LA IP addresses. For CS520, you should install PostgreSQL on your own computer because otherwise it's going to be very inefficient to do development.

Phobe
Posts: 40
Posted 21:20 Oct 03, 2010 |

Ah. In that case, wouldn't it be a better idea to SSH tunnel to the SQL server? That way the settings will be the same for CS3 deployment and the development environment.

cysun
Posts: 2935
Posted 21:55 Oct 03, 2010 |
Phobe wrote:

Ah. In that case, wouldn't it be a better idea to SSH tunnel to the SQL server? That way the settings will be the same for CS3 deployment and the development environment.

You can create the same setting as CS3 on your own computer, but if you prefer tunneling, that's fine.