I'm working with the XRMS Contact Management System developers to get the
application working with postgres as well as the original MySQL. My role is
trying what they've produced and reporting errors.
The application runs on a httpd server (apache-1.3.34 here) with any
browser; similar to SQL-Ledger, but xrms is written in php rather than perl.
I've not yet been able to get last Friday's CVS version to install properly
after I dropped the old database and created a new one. I'm still missing
something on the proper syntax to grant priviledges to these tables to the
application. I'd appreciate some help translating from mysql to postgres
here.
Following are what the INSTALL file provides for MySQL, and what I've done
in postgresql-8.1.2.
mysql:
Create a MySQL database to hold the XRMS tables, and pick a valid MySQL
account for XRMS to use.
Example:
from a mysql prompt
create database xrms;
grant all privileges on xrms.* to xrms@localhost identified by
'yourpasswordhere';
postgres (from my user account):
createdb contacts
createuser xrms # This creates the ROLE xrms
grant all on contacts to xrms; # This generates an error at 'to'.
When I request a list of databases (psql -l), the one named contacts is
there. However, when I open the database (psql contacts), there's no one
home; that is, 'psql -d' returns 'no relations found.'
I need a clue on how to let user 'xrms' access the database 'contacts' so
the install script runs correctly.
TIA,
Rich
--
Richard B. Shepard, Ph.D. | Quantifying subjectivity for the
Applied Ecosystem Services, Inc.(TM) | benefit of business and society.
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863