The CRM (client relationship management) tool I've been using (a simple
TreeLine application I built) needs to be updated. While there are a couple
of handfuls of F/OSS CRM/SFA applications available all but one are
hardwired for MySQL backends (one also accepts MariaDB, the OSS fork of
MySQL). About 20 years ago when I moved everything to linux I also installed
and learned PostgreSQL and SQLite which I've used extensively over the
years. I neither need nor want to install, maintain, and learn a third
RDBMS.
Yesterday, while thinking I'd need to write my own application from
scratch I found XRMS on sourceforge.net. This has the capabilities I need
without the overhead of those I don't need. The front end is any Web browser
(I refer to these as BUIs), the middleware is PHP, and the backend can be
any RDBMS supported by adodb. Version 5.14, installed here, supports
postgres and sqlite among many others.
The last version of XRMS was uploaded a decade ago: April and July 2006.
However, after blowing off the dust I figured it was still usable since
everything can be upgraded or tweaked to work with the installed php-5.6.24
and later versions.
The application itself is installed in /opt/xrms/. Now I need to create
the tables and procedures the application requires, and I've hit the wall of
my ignorance in installing a local php application. Help from those of you
who do this regularly is needed, either on or off the maillist.
The xrms INSTALL instructions (based on MySQL) are:
"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';"
I created a postgres database (running psql as user postgres) with this:
create database xrms owned by rshepard
Because I'm the database owner I automatically have all privileges. I have
not created a user 'xrms.' I then set paths and other identifying
information in xrms's conf files.
The next step is:
" Now, to setup the database schema and basic dataset, point your web
browser to:
http://www.yourserver.com/path_to_xrms/install/install.php";
and when I try http://localhost/opt/xrms/install/install.php firefox tells
me that the file is not found.
I've obviously missed some critical points and need a clue on what I've
done incorrectly, and what the correct procedures are.
If there are docs on how to do this, please point me to them.
Rich
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
