sql-ledger-users

[SL] Problem with login

[Jefi S. <Jef...@op...>]

HI Everyone,
This is only the second problem I have had is 18 months of running 
SQL-Ledger
and I have been able to apply up dates with out any problem
But with going from 2.6.27 to 2.8.4 I have encountered the following error.

*DELETE FROM semaphore
WHERE login = 'Jeremy'
ERROR: relation "semaphore" does not exist
*
Does any one have any suggestions, I have not been able to resolve the 
problem


Many thanks

Jeremy*
*

[SL] Problem starting httpd after configuring sql-ledger - solved

[Bob G. <bo...@rc...>]

When you install sql-ledger and get the following error message when you
start httpd

Starting httpd: [Tue May 22 21:08:12 2007] [warn] The Alias directive
in /etc/httpd/conf.d/sql-ledger-httpd.conf at line 1 will probably never
match because it overlaps an earlier Alias.

It means that you are probably 'including' the sql-ledger-httpd
information twice. The error message comes on the second include.

---

This can happen if you put the sql-ledger config information into the

/etc/httpd/conf.d  directory as:

# ls /etc/httpd/conf.d
auth_mysql.conf  mod_security.conf  phpldapadmin.conf      ssl.conf
auth_pgsql.conf  mrtg.conf          proxy_ajp.conf         trac.conf
authz_ldap.conf  perl.conf          README                 welcome.conf
manual.conf      php.conf           sql-ledger-httpd.conf
# 

The config information in this directory is included by line 209 in the
file /etc/httpd/conf/httpd.conf

# grep -n Include /etc/httpd/conf/httpd.conf

209:Include conf.d/*.conf
<snip>
996:# Include /etc/httpd/conf.d/sql-ledger-httpd.conf
# 

If you also include line 996 as given in the sql-ledger README file,
then httpd will try to include the sql-ledger-httpd.conf information
twice. (Note I have commented out this line).

This error message only happens if you don't quite follow the sql-ledger
README instructions and stick the sql-ledger-httpd.conf file into
the /etc/httpd/conf.d directory rather than the /etc/httpd/conf
directory...