Skip to main content
New Participant
Nov 25, 2024 7:56 PM UTC
Question

Default mariadb Database connection details

Can anyone help me to find default mariadb connection details in system logs?  I am not able to find in data server logs. Please let me know the exact path of that.

6 replies

varuntejg243705
Inspiring
Nov 26, 2024 5:44 AM UTC

Hi [mention:8841326c8cb445808c24f31b29f522b0:e9ed411860ed4f2ba0265705b8793d05] ,

if you are using On-premise server, then the probable path will be : C:\Users\Administrator\Documents\Appian\logs\tomcat-stdOut.log.yyyy.mm.dd.

The concept -  Data Server is used for enabling the integration between Appian applications and external databases or data sources.
It manages the connections, security, performance, and troubleshooting aspects, allowing users to retrieve, update, and store data while maintaining seamless integration between Appian and other systems.

Here for handling internal db source, we need to point to Tomcat server resources.

I hope you got the exact info needed.

gayatria0439
Participating Frequently
Nov 26, 2024 7:07 AM UTC

Hello [tag:Pavan],

If you would like to review the Appian system logs, please follow these steps:

  1. Click on 'System Logs' under the '9-Dot Bento Menu'.
  2. Select 'System Logs', and then click on 'perflogs/'.
  3. Inside the 'perflogs', you will find the 'perf_monitor_rdbms.csv' files. Based on the date and time, you can download the relevant files.
varuntejg243705
Inspiring
Nov 26, 2024 7:17 AM UTC

Hi [mention:0bc4c4bef9ec41cd9ea711bb76538c5d:e9ed411860ed4f2ba0265705b8793d05] ,

'perf_monitor_rdbms.csv' logs only displays the performance metrics of the relational db, but doesn't show the exact connection details.

tomcat-stdOut.log.yyyy.mm.dd, have overall logs related to data-server, search-server, app-server-tomcat, deployment and plugins data.

gayatria0439
Participating Frequently
Nov 26, 2024 8:26 AM UTC

Hi [mention:3f9551bc38d94a79ae62f9d520dbad6d:e9ed411860ed4f2ba0265705b8793d05] ,

Thank you for the information. I completely agree with this.

New Participant
Nov 27, 2024 8:18 AM UTC

Check the MariaDB log file, typically located at /var/log/mysql/mariadb.log or /var/log/mysql/error.log, for connection details.

New Participant
Dec 2, 2024 8:53 AM UTC

Thanks Yasir for this Best Typically Located Sharing mid birthday.