Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Logging to a datasource

Description

I have a Datasource with root access to a MySQL database. The Web context is configured to output the remoteclient log to my datasource, specifying a table that doesn’t yet exist in the database. I have restarted Lucee. When an email is sent, a line is written to the text log file and no new table is created in my log database.

Environment

Windows 8 and Windows 2019
Java 1.8.0_231

Attachments

3
  • 27 Nov 2019, 09:02 pm
  • 27 Nov 2019, 09:02 pm
  • 27 Nov 2019, 09:02 pm

Activity

Show:

Pothys - MitrahSoft 2 December 2019 at 13:41

,
I found the issue. Sorry, initially, I've checked with JDK 1.8.0_211. In this version, I can't able to see any issues, it works as expected to me. So, I've changed the java version to 1.8.0_221, 1.8.0_231. now I could see the exact issues. Yes, if we set logging to the data source, it is written to a log file instead of written to the table. And no new table is created. So, confirmed the issue happened on the above JDK version.

Simon Goldschmidt 1 December 2019 at 23:25

In some further testing, I set up every log to output to the datasource. The log table has been created and populated with a number of "application" records, but "exception", "requesttimeout" and "remoteclient" logs continue to output only to the text files.

Simon Goldschmidt 27 November 2019 at 21:02

Hi I have attached Datasource and Logging configuration. When my application sends an email, it logs to the text file and no database table “lucee1” is created. Are there any other steps I can take or any logs that might contain clues as to the issue? I created a new database with a new datasource, tried a different table name, changed the MySQL extension from 8.0.15 to 5.1.20 and always got the same result. Thanks.. Simon

 

Pothys - MitrahSoft 27 November 2019 at 13:34

, I've checked this ticket as per you said with both affected version and latest version 5.3.5.45-SNAPSHOT. It working as expected in my local. I didn't restart the lucee. It worked with as normal, the table also created successfully in my DB. Could you please check again with this? and report here back. Because it'll improve the status of the ticket.

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 27 November 2019 at 01:07
Updated 19 May 2021 at 11:13

Flag notifications