data source not found

[davecramer]

Looking for Connection Identifier ConnectionIdentifier(lift) but failed to find either a JNDI data source with the name lift or a lift connection manager with the correct name
net.liftweb.db.DB$$anonfun$newConnection$2.apply(DB.scala:188)
net.liftweb.db.DB$$anonfun$newConnection$2.apply(DB.scala:188)
net.liftweb.common.EmptyBox.openOr(Box.scala:574)
net.liftweb.db.DB$class.newConnection(DB.scala:187)
net.liftweb.db.DB$class.getConnection(DB.scala:293)
net.liftweb.db.DB$class.use(DB.scala:666)
net.liftweb.db.DB$$anon$1.use(DB.scala:38)

[josephks]

If you aren't running pg on the same machine as you are running the monitor you have to configure your database connection.

[davecramer]

I tried two machines both with pg running on them. Same error

[josephks]

That message means that app can't connect to the database. Make sure you can connect with psql using localhost. If that works ok try explicitly configuring the db connection in the default.props file.

[davecramer]

I can connect to template1 no problem using psql -h localhost -U postgres template1
This is exactly what is in default.props

[josephks]

And there is no helpful exception on the console? Somehow some way the app can't connect to the database. Could it be your jvm security settings? Do you see anything in the pg logs indicating the connection was refused?

[josephks]

And there is no helpful exception on the console? Somehow some way the app can't connect to the database. Could it be your jvm security settings? Do you see anything in the pg logs indicating the connection was refused?

[josephks]

And there is no helpful exception on the console? Somehow some way the app can't connect to the database. Could it be your jvm security settings? Do you see anything in the pg logs indicating the connection was refused?

[josephks]

And there is no helpful exception on the console? Somehow some way the app can't connect to the database. Could it be your jvm security settings? Do you see anything in the pg logs indicating the connection was refused?

[davecramer]

Joseph, where should this properties file be when the system is running ?

FYI I am one of the maintainers of the JDBC driver, my jvm is not the problem

[josephks]

I pushed an example to github. It goes under src/main/resources/props.

[davecramer]

ok there is a default.props file there. How about when it is running where is it supposed to live ? Where is the pgjdbc jar when it is running ?

[josephks]

Are you running this from sbt? The jdbc driver is a dependency, and should also be included in any war file built. The props file is also included in any war file built.

[davecramer]

I am running this from the sbt, I guess I could try building a war and running it

[josephks]

It runs fine from sbt for me. Do you think that the jdbc jar isn't being found in the classpath? It could by an ivy issue. Try removing your ~/.ivy and rerunning.

[davecramer]

I have no idea, wouldn't you get a class not found error instead ?

[josephks]

I forgot about this quirk of Lift, that if you specify a user in the config file but no password the user wouldn't be used. Were you specifying a user in the config w/o a password?

Back to basics: Are you sure there is nothing in the pg log file or in the sbt window that indicates what the problem is? If I try to access the webapp and pg isn't running I get a org.postgresql.util.PSQLException above the NPE.

[josephks]

Just pushed an update that should work around Lift's password problem

[davecramer]

that worked now I just have

Welcome to the PostgresQL Monitor!

Your database version is: PostgreSQL 9.0.7 on x86_64-apple-darwin11.3.0, compiled by GCC i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.9.00), 64-bit

Your database encoding is: UTF8

on the screen

[josephks]

OK great. I've been using it on 9.1.x dbs so I don't know if there will be any issues with 9.0.x.

[davecramer]

Is there no menu or anything ?

[josephks]

No, I kind of had the idea that everyone would customize the web pages for their own setups, and this was version 0.1. I just pushed some updated templates, including links on the front page.

I just noticed that the bandwidth charts are having some javascript issues that I thought I fixed already. Don't be surprised if they don't work.

[davecramer]

OK, I figured it out thanks.

So why scala ? seems like an awful lot of dependancies to do a couple of fairly simple things ?

Dave

[josephks]

The dependency list isn't all that large. Some of that stuff is only there for testing. I have persistence-api as a dependency for the ORM generator, which isn't really done. You can try it by going to /api/schema/jpa

I like programming in Scala because it makes some things just so much easier than Java. Lift in particular makes comet updates easy. Both of them do have learning curves though. Lift makes ajax and comet stuff easy but its basic orm stuff isn't as easy to use as other frameworks like Rails. It's mostly just a lack of documentation.

[josephks]

I pushed a fix for the bandwidth chart problem.