I tried to set it both in config/main.php and config/console.php. Currently I have my console.php file located in the same directory as index.php. This looks like this:
// change the following paths if necessary
Then in config/main.php I have the db connection as shown in my previous post. I also created a copy of config/main.php called config/console.php and changed the line above to point to config/console.php but that did not work.
I read somewhere that the console application is by default looking at the settings in config/console.php, but I guess that since the config dirname is defined otherwise in my file, then it is using that path instead. Any ideas of what I have missed here?
Note that there are two console.php in this case. One config file and one where the actual console app starts.