Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

[15:02:31 CDT(-0500)] <Daskreech> http://pastebin.ca/2185902 is the error that I'm getting

[15:03:24 CDT(-0500)] <EricDalquist> if you scroll down to the bottom: http://pastebin.ca/raw/2185902 you see the last Cause By says "Connection refused"

[15:03:32 CDT(-0500)] <EricDalquist> so either your database isn't running

[15:03:39 CDT(-0500)] <EricDalquist> or the JDBC connection string is incorrect

[15:03:39 CDT(-0500)] <Daskreech> It seems that I can't get in contact with postgresql but I can't figure out why that would be

[15:03:48 CDT(-0500)] <Daskreech> Right but I can psql in to the database

[15:03:57 CDT(-0500)] <EricDalquist> one of the best ways to test is to use http://squirrel-sql.sourceforge.net/

[15:04:02 CDT(-0500)] <EricDalquist> it is a java SQL client

[15:04:02 CDT(-0500)] <Daskreech> as far as I know the jdbc string hasn't changed

[15:04:20 CDT(-0500)] <EricDalquist> from the same machine setup squirrel using the same JDBC connection info

[15:04:24 CDT(-0500)] <EricDalquist> and the same JDBC driver

[15:04:31 CDT(-0500)] <Daskreech> hmm ok

[15:04:33 CDT(-0500)] <EricDalquist> that should help you track down the problem

[15:04:39 CDT(-0500)] <Daskreech> Does it have more expressive errors?

[15:04:55 CDT(-0500)] <EricDalquist> probably not but it has a faster turn around time for testing

[15:05:15 CDT(-0500)] <EricDalquist> there isn't much else to know other than the JDBC driver can't connect to the JDBC URL it was provided with

[15:05:32 CDT(-0500)] <EricDalquist> so either the DB is down, there is some sort of network issue or the JDBC URL is wrong

[15:06:19 CDT(-0500)] <Daskreech> hmm ok

[15:06:42 CDT(-0500)] <Daskreech> that was my diagnosis as well but I"ll plug away at it

[15:07:10 CDT(-0500)] <EricDalquist> good luck ... sorry there isn't more info there

[15:07:23 CDT(-0500)] <Daskreech> Yeah I think someone screwed around with the database

[15:07:25 CDT(-0500)] <EricDalquist> I'm assuming you're using psql from the same machine that you're trying to start uPortal on?

[15:07:32 CDT(-0500)] <Daskreech> Yes

[15:07:44 CDT(-0500)] <EricDalquist> yeah then my next guess would be network or jdbc url issues

[15:08:05 CDT(-0500)] <EricDalquist> often the native database clients deal with minor config changes better than a JDBC URL will

[15:08:20 CDT(-0500)] <EricDalquist> which is why testing with something like squirrel is better for verification

[15:08:33 CDT(-0500)] <Daskreech> and it's a localhost/database connection

[15:08:45 CDT(-0500)] <Daskreech> Alright thanks