Errata
From Chasers_wiki
This page lists known problems and fixes with different versions of CHASERS.
Known problems and/or fixes for different released versions of CHASERS are listed here.
Contents |
gpl_snapshot1a
(no problems listed yet. All fixes listed for gpl_snapshot1 are included in this release).
gpl_snapshot1
(Note: all the problems in this version have been fixed in the new version, gpl_snapshot1a. Please download that version, and save yourself a lot of headache!)
Several directories and files have permission problems
- The permissions are not set correctly for several directories. Fix this by typing the following commands, as root:
cd /var/www/html/chasers/ chmod o+x config database images photos reports schema scripts
- The permissions are not set correctly for the sample report. Fix this by typing the following command, as root:
chmod o+r /var/www/html/chasers/reports/cfg/simple_client_report.cfg
Bug in get_alert_text function
- The postgres get_alert_text function is improperly defined. On newer versions, this may prevent you from running install.sql. Fix this by editing the file /var/www/html/chasers/database/pg/client/functions/create.alert_notify.sql. Find this line:
CREATE OR REPLACE FUNCTION get_alert_text(INTEGER,TEXT,TEXT) RETURNS text AS $$
and change it to:
CREATE OR REPLACE FUNCTION get_alert_text(INTEGER,TEXT,INTEGER) RETURNS text AS $$
Can't login with IPv6 systems
By default, CHASERS only allows access from the localhost. This is defined only as "127.0.0.1", and not as "::1" as needed for IPv6.
If you have already installed CHASERS, and can't log in, you can fix this problem by adding a record to the access table. As root, type:
psql -U {USER} -h localhost {DATABASE}
(replacing {USER} and {DATABASE} with the same values you used in add.initial.db.sql.)
Enter your password. Again it should match what you used before. Type (or copy/paste) these commands:
INSERT INTO tbl_db_access (access_ip,
is_internal,
description,
added_by,
changed_by
) VALUES (
'::1',
true,
'Localhost',
1,
1);
\q
To fix this problem permanently in case you want to re-install CHASERS, edit the file /var/www/html/chasers/database/pg/client/add.initial_access.sql. Replace this section:
INSERT INTO tbl_db_access (access_ip,
is_internal,
description,
added_by,
changed_by
) VALUES (
'127.0.0.1',
true,
'Localhost',
1,
1)
with this instead:
INSERT INTO tbl_db_access (access_ip,
is_internal,
description,
added_by,
changed_by
) VALUES (
'127.0.0.1',
true,
'Localhost',
1,
1),
(
'::1',
true,
'Localhost',
1,
1)
Can't add a staff record or calendar
This problem shows up with newer versions of Postgres, probably 8.3+. We discovered it on Fedora 9. There are a couple of extra postgres function needed.
If you have already installed CHASERS, and can't add a new staff account, you can fix this problem by adding the missing function directly to the database. As root, type:
psql -U {USER} -h localhost {DATABASE}
(replacing {USER} and {DATABASE} with the same values you used in add.initial.db.sql.)
Enter your password. Again it should match what you used before. Type (or copy/paste) these commands:
CREATE OR REPLACE FUNCTION be_null( x float ) RETURNS BOOLEAN AS $$
SELECT $1 IS NULL;
$$ LANGUAGE sql IMMUTABLE;
CREATE OR REPLACE FUNCTION be_null( x interval ) RETURNS BOOLEAN AS $$
SELECT $1 IS NULL;
$$ LANGUAGE sql IMMUTABLE;
To fix this problem permanently in case you want to re-install CHASERS, edit the file /var/www/html/chasers/database/pg/client/functions/create.functions.sql. Find these lines:
CREATE OR REPLACE FUNCTION be_null( x smallint ) RETURNS boolean AS $$
SELECT $1 IS NULL;
$$ LANGUAGE sql IMMUTABLE;
and add the following lines immediately after:
CREATE OR REPLACE FUNCTION be_null( x float ) RETURNS BOOLEAN AS $$
SELECT $1 IS NULL;
$$ LANGUAGE sql IMMUTABLE;
CREATE OR REPLACE FUNCTION be_null( x interval ) RETURNS BOOLEAN AS $$
SELECT $1 IS NULL;
$$ LANGUAGE sql IMMUTABLE;
