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
