Jaromír Talíř wrote:
Hi Julian,
according to log, it looks like database installation didn't finish
correctly. create_object() is postgresql stored procedure written in
plpgsql language. This language must be installed (createlang command)
into database before SQL script with FRED database structure is loaded.
We have fred-dbmanager script that takes care of this dependency:
$ grep -A4 -B5 createlang /usr/sbin/fred-dbmanager
if [ "$(get_db_version)" = "" ]; then
/usr/bin//createuser fred -SDR -p 5432 > /dev/null 2>&1
/usr/bin//createdb fred -O fred -E UTF8 \
-p 5432 > /dev/null 2>&1
/usr/bin//createlang plpgsql fred \
-p 5432 > /dev/null 2>&1
/usr/bin//psql fred -U fred -f $STRUCTSQL -p 5432 >/dev/null
2>&1
fi
In default installation command '/usr/sbin/fred-dbmanager install' is
called during fred startup inside command '/etc/init.d/fred-server
start'.
That was the trick;
REG-FRED_A(a)192.168.0.18> create_contact CID:ID02 'Jan Ban'
info(a)mail.com Street Brno 123000 CZ
Do you really want to send this command to the server? (y/N): y
Contact ID: CID:ID02
Created on: 2008-11-05T16:46:15+10:00
I now have success. Thank you very much! Next problem, on the webadmin
page and click on statistics, I get a 404. Where does that info come from?
--julian