Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#231428 - 24/08/2004 10:25 Problem configuring linux (mysql) for jreceiver.
riocanada
newbie

Registered: 08/10/2003
Posts: 78
Loc: Ontario, Canada
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.
_________________________
[3 rebadged Dell DARs, 1 Rio Receiver] [JReceiver 0.2.5 and tRio 0.1.6 on SuSE 9.3 Pro]

Top
#231429 - 24/08/2004 10:46 Re: Problem configuring linux (mysql) for jreceiver. [Re: riocanada]
pauln
enthusiast

Registered: 03/12/2001
Posts: 332
Loc: UK
Jim,

I'm guessing here, but try:

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

Cheers
Paul

Top
#231430 - 26/08/2004 23:23 Re: Problem configuring linux (mysql) for jreceiver. [Re: pauln]
riocanada
newbie

Registered: 08/10/2003
Posts: 78
Loc: Ontario, Canada
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)
_________________________
[3 rebadged Dell DARs, 1 Rio Receiver] [JReceiver 0.2.5 and tRio 0.1.6 on SuSE 9.3 Pro]

Top
#231431 - 27/08/2004 05:57 Re: Problem configuring linux (mysql) for jreceiver. [Re: riocanada]
pauln
enthusiast

Registered: 03/12/2001
Posts: 332
Loc: UK
Have you tried the jreceiver troubleshooting steps for this problem? See http://jreceiver.sourceforge.net/jrec-trouble.html .

Cheers
Paul

Top
#231432 - 27/08/2004 15:21 Re: Problem configuring linux (mysql) for jreceiver. [Re: pauln]
riocanada
newbie

Registered: 08/10/2003
Posts: 78
Loc: Ontario, Canada
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.
_________________________
[3 rebadged Dell DARs, 1 Rio Receiver] [JReceiver 0.2.5 and tRio 0.1.6 on SuSE 9.3 Pro]

Top