Hi, Check your bind-address in my.cnf (on the computer running your mysql server) and make sure it will allow MySQL to accept connections from any computer on your network. Normally it defaults to 127.0.0.1
I can't recall where the file lives on the appliance, but on Debian based systems it is in: /etc/mysql/my.cnf and look for bind-address in that file, change it to: bind-address=0.0.0.0 You'll probably have to be root to change / save this file. You could do further access controls (check the MySQL documentation for this), but at least for testing - this will let you know if it is the problem. If you are okay with any computer on the network being able to access MySQL, then 0.0.0.0 is okay (recognizing this could be a security risk, but a limited one if you are on a private network). Restart your mysql daemon, restart your rivendell daemons, and see if it fixes things. Also, check your /etc/rd.conf and look for the hostname line under the [mysql] configuration. Make sure your hostname is pointing to the IP address where your MySQL server is running. If the hostname needs to be updated, then update it and restart your rivendell daemons. Lorne Tyndale > I have a RD server and a client, both built from the latest version of > the "Appliance" DVD (the install's a good job, well done to all). > > When there was just the server, all the rd apps worked - rdadmin, > rdlibrary etc. Then I built the client and started enabling > communication between the two; today I have done only three things to > the server: > > 1. Changed its host name to "rdserver", using the recipe on the > "post-installation" page > 2. Enabled export of /var/snd by adding it to /etc/exports. It mounts > correctly from the client. > 3. Given "rduser" at "rdclienta" (which is its name) privileges to the > database with CREATE USER 'rduser'@'%' IDENTIFIED BY 'letmein'; GRANT > ALL PRIVILEGES ON Rivendell.* TO 'rduser'@'%' WITH GRANT OPTION; > > But now when I execute "rdlibrary" on _either_ machine, rdclienta or > rdserver, I get a blank list of carts, and an SQL error. The SQL > statement is quite long so I've edited it; it's roughly this: > > select CART.NUMBER,CART.FORCED_LENGTH (long list of fields) from > CART left join GROUPS on CART.GROUP_NAME=GROUPS.NAME > left join CUTS on CART.NUMBER=CUTS.CART_NUMBER where > () && ( > (CART.TITLE like "%%") || > ( more tests like that ) > ) && ( > (TYPE=1) || other types > ) > order by CART.NUMBER limit 100; > > The site of the error is, as you will see, that empty pair of parens; if > I take that out the statement returns my list of assets. > > So the question: what did I do to cause rdlibrary to generate invalid > SQL, and what can I do -- short of rebuilding! -- to fix it? > > -- > > Henry Law Manchester, England > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
