Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 4.x > Installation and deployment > Logging & Debugging View modes: 
User avatar
Member
Member
matthew.mcguire-ctv - 8/13/2009 10:49:44 AM
   
Logging & Debugging
I'm trying to log sql queries and show the SQL Debug tab in Site Manager-> Administration->System. I need to debug an issue regarding sql performance when adding webparts

I added the following to my web.config in appSettings section:

<add key="CMSDebugSQLQueries" value="true" />
<add key="CMSDebugSQLQueriesLogLength" value="20" />
<add key="CMSLogSQLQueries" value="true" />

However, the application is not logging to <web root>/AppData/logsql.log and also, the SQL Debug tab is not present where the documentation tells me to look.

Can anyone suggest solutions or explain what I have done wrong, or haven't done? Thanks.

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 8/14/2009 7:36:00 AM
   
RE:Logging & Debugging
Hi,

could you please make sure that the web.config file was saved correctly and that the keys were added? I have tried to turn the SQL debug on right now and it is working fine.

Best Regards,
Juraj Ondrus

User avatar
Member
Member
matthew.mcguire - 8/18/2009 9:51:02 AM
   
RE:Logging & Debugging
I do apologize about this - The issue was found last week to be that the FTP account I was using and the home folder of the webserver were pointing to different directories. Once this was realized and resolved, logging was found to be working.

Thanks for your attention in this matter, regardless. Feel free to remove this post should you wish to do so.