database logging

[David Wallace Croft]

I am trying to enable mySQL logging as described in the documentation.
I think I have followed the instructions but it does not seem to be
working.  When I dig through the log, I do not see any error messages
related to a failure to connect to the database.

If database logging fails, is this failure logged?  If so, where?

--
David Wallace Croft / [phone] m
http://www.CroftSoft.com/people/david/
_______________________________________________
programd mailing list
programd@...
http://aitools.org/mailman/listinfo/programd

[David Wallace Croft-2]

--- David Wallace Croft <david@...> wrote:
> I am trying to enable mySQL logging as described in the
> documentation.
> I think I have followed the instructions but it does not seem to be
> working.  When I dig through the log, I do not see any error messages
> related to a failure to connect to the database.


I am starting to think that my /var/programd/conf/log4j.xml is not
being read.  I can change it or rename it and logging behavior does not
change.  

I am not experienced with Log4j.  How does programd configure logging
if not by this file?


--
David Wallace Croft / [phone] m
http://www.CroftSoft.com/people/david/
_______________________________________________
programd mailing list
programd@...
http://aitools.org/mailman/listinfo/programd

[David Wallace Croft]

--- David Wallace Croft <david@...> wrote:
> I am trying to enable mySQL logging as described in the
> documentation.
> I think I have followed the instructions but it does not seem to be
> working.  When I dig through the log, I do not see any error messages
> related to a failure to connect to the database.
>
> If database logging fails, is this failure logged?  If so, where?


I am starting to think that my /var/programd/conf/log4j.xml is not
being read.  I can change it or rename it and logging behavior does not
change.  

I am not experienced with Log4j.  How does programd configure logging
if not by this file?


--
David Wallace Croft / [phone] m
http://www.CroftSoft.com/people/david/
_______________________________________________
programd mailing list
programd@...
http://aitools.org/mailman/listinfo/programd

[David Wallace Croft]

--- David Wallace Croft <david@...> wrote:
> I am starting to think that my /var/programd/conf/log4j.xml is not
> being read.  I can change it or rename it and logging behavior does
> not
> change.  
>
> I am not experienced with Log4j.  How does programd configure logging
> if not by this file?


OK, after many, many hours, I made some progress.  Here was my first
clue:
http://wiki.apache.org/logging-log4j/Log4jConfigurationHelp

Here is what I had to do to change logging under JBoss:

* Empty the classpath in the manifest.  This confused JBoss.
* Remove the Log4j JAR from the WEB-INF/lib.
* The log4j.xml in WEB-INF/classes gets ignored.
* Copy the programd log4j.xml instructions to the JBoss log4j.xml

This got me to the point where I stopped getting a log4j initialization
error and I could change the activity log file name.

Tomorrow I will try the JDBC logger.

Is anyone running programd under JBoss with database chat logging?

--
David Wallace Croft / [phone] m
http://www.CroftSoft.com/people/david/
_______________________________________________
programd mailing list
programd@...
http://aitools.org/mailman/listinfo/programd