Problem configuring linux (mysql) for jreceiver.

Hi Folks,

I've been running tRio for quite some time and want to switch from a Windows 98 box to Linux. I'm running SuSE 9.1 Pro and have been following the tutorial on the jreceiver site but have hit a snag.

I've got the java runtime and have installed jetty, but am having a problem setting up the MySQL database.

When I issue the

UPDATE user SET Password=PASSWORD('********') WHERE user='jreceiver_app';

command, MySQL responds with

ERROR 1146: Table 'jreceiver.user' doesn't exist

I don't see anywhere in the tutorial where I'm supposed to define this table.

Suggestions? Is there a more complete set of instructions somewhere else?

Thanks,

Jim.

Jim,

I'm guessing here, but try:

UPDATE mysql.user SET Password=PASSWORD('********') WHERE user='jreceiver_app'

Cheers
Paul

Thanks Paul,

I realized that the problem was that I didn't start MySQL correctly. Doh!

However, trying to complete the installation of JReceiver,
issueing the following command causes the error dump below.

$JREC_HOME/bin/jrec_jetty.sh start

I've tried to find some relevant description to the problem, but so far am at a loss. Any help would be appreciated.
(BTW, the MySQL daemon is running!)

---jetty.log---
22:31:12.369 EVENT Starting Jetty/4.2.21
22:31:14.382 EVENT Started WebApplicationContext[/jrec_serv,jar:file:/usr/local/JReceiver-0.2.5/dist/jrec_serv.war!/]
22:31:14.953 EVENT connection-pool-init: getProperties: external file=/usr/local/jreceiver/etc/jreceiver.properties
22:31:15.171 WARN!! connection-pool-init: JRec: unable to load pool configuration
Message: sql-problem initializing pool
Root cause: java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the
machine/port you are trying to connect to? (java.net.ConnectException)
at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at jreceiver.server.util.db.ConnectionPool.getNewConnection(ConnectionPool.java:203)
at jreceiver.server.util.db.ConnectionPool.initializePool(ConnectionPool.java:193)
at jreceiver.server.util.db.ConnectionPool.<init>(ConnectionPool.java:49)
at jreceiver.server.util.db.ConnectionPool.getInstance(ConnectionPool.java:79)
at jreceiver.server.util.db.ConnectionPoolInit.init(ConnectionPoolInit.java:30)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at org.mortbay.jetty.servlet.ServletHolder.start(ServletHolder.java:220)
at org.mortbay.jetty.servlet.ServletHandler.initializeServlets(ServletHandler.java:445)
at org.mortbay.jetty.servlet.WebApplicationHandler.initializeServlets(WebApplicationHandler.java:150)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:458)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)

Have you tried the jreceiver troubleshooting steps for this problem? See http://jreceiver.sourceforge.net/jrec-trouble.html .

Cheers
Paul

Hi Paul,

I have tried the guide, to no avail.
All of the components work by themselves, i.e. Java, MySQL, Jetty, but when started with JReceiver, no joy.

Any other suggestions would be greatly appreciated.

Cheers,

Jim.