How to enable exception.log and system.log in Magento database?

Question

In Magento how do I enable exception.log and system.log at the database level?

I know I can do it through admin backend (which I do not want to do).

What value needs to be changed? I assumed that dev/log/active needed to be set to 1 in core_config_data, but I did this and that did not enable logging. Thanks!

make sure you have write permission (777) for directory `var/log/` — Kalpesh, Aug 20 '12 at 20:54

score 11 · Accepted Answer · answered Aug 20 '12 at 19:26

11

Your solution is right. That's the right place to enable it in the DB. If it's not working for you, try clearing the cache. If still not working, try select * from core_config_data where path = "dev/log/active"; and check if it is not disabled for a particular scope that's overriding your setting

answered Aug 20 '12 at 19:26

barbazul

608
6
8

2

And if it's still not working, check that the user running the shell script has write permission to var/log. – kojiro Mar 06 '14 at 00:47

Mukesh · Answer 2 · 2015-09-14T09:35:26.390

3

Use following query

INSERT INTO `yourmagentodbname`.`core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ( 'default', '0', 'dev/log/active', '1');

edited Sep 14 '15 at 09:35

answered May 23 '14 at 14:48

Mukesh

7,630
21
105
159

score 0 · Answer 3 · answered Dec 21 '16 at 16:48

Check folder permissions. You need to give permissions for the user that is running apache.

In my case just the sub directory "log" was not owned by the running apache user.

My apache user is bitnami:daemon...

So for me the solution was:

sudo chmod -R 777 var/
sudo chown -R bitnami:daemon var/

How to enable exception.log and system.log in Magento database?

3 Answers3

Linked