SQLSTATE[HY000] [2002] No such file or directory

[wayneashleyberry]

Just installed clockwork 1.* in a fresh Laravel 4.2 project, as soon as I added the service provider config i get this error :(

PDOException thrown with message "SQLSTATE[HY000] [2002] No such file or directory"

Stacktrace:
#26 PDOException in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:47
#25 PDO:__construct in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:47
#24 Illuminate\Database\Connectors\Connector:createConnection in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php:20
#23 Illuminate\Database\Connectors\MySqlConnector:connect in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:59
#22 Illuminate\Database\Connectors\ConnectionFactory:createSingleConnection in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:47
#21 Illuminate\Database\Connectors\ConnectionFactory:make in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:127
#20 Illuminate\Database\DatabaseManager:makeConnection in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:63
#19 Illuminate\Database\DatabaseManager:connection in /Users/wayne/source/primedia-cms/source/vendor/itsgoingd/clockwork/Clockwork/Support/Laravel/ClockworkServiceProvider.php:63
#18 Clockwork\Support\Laravel\ClockworkServiceProvider:Clockwork\Support\Laravel\{closure} in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Container/Container.php:498
#17 Illuminate\Container\Container:build in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Container/Container.php:425
#16 Illuminate\Container\Container:make in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:463
#15 Illuminate\Foundation\Application:make in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Container/Container.php:809
#14 Illuminate\Container\Container:offsetGet in /Users/wayne/source/primedia-cms/source/vendor/itsgoingd/clockwork/Clockwork/Support/Laravel/ClockworkServiceProvider.php:99
#13 Clockwork\Support\Laravel\ClockworkServiceProvider:Clockwork\Support\Laravel\{closure} in <#unknown>:0
#12 call_user_func_array in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php:199
#11 Illuminate\Events\Dispatcher:fire in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php:154
#10 Illuminate\Events\Dispatcher:until in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Routing/Router.php:1244
#9 Illuminate\Routing\Router:callFilter in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Routing/Router.php:972
#8 Illuminate\Routing\Router:dispatch in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:738
#7 Illuminate\Foundation\Application:dispatch in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:708
#6 Illuminate\Foundation\Application:handle in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Session/Middleware.php:72
#5 Illuminate\Session\Middleware:handle in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php:47
#4 Illuminate\Cookie\Queue:handle in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php:51
#3 Illuminate\Cookie\Guard:handle in /Users/wayne/source/primedia-cms/source/vendor/stack/builder/src/Stack/StackedHttpKernel.php:23
#2 Stack\StackedHttpKernel:handle in /Users/wayne/source/primedia-cms/source/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:606
#1 Illuminate\Foundation\Application:run in /Users/wayne/source/primedia-cms/source/public/index.php:49
#0 require_once in /Users/wayne/source/primedia-cms/source/server.php:19

[wayneashleyberry]

Update

I'm not using any database in my application, but when I change the default setting in app/config/database.php to sqlite then this error goes away. It was set to mysql which is what Laravel ships with...

[itsgoingd]

Hey, clockwork tries to collect sql queries by default, if your app doesn't use database you can disable this behaviour by setting default database to null in your database.php or add databaseQueries to filter in the clockwork config file.

[wayneashleyberry]

@itsgoingd thanks, that definitely helped.

Don't you think it's still a strange behavior? Why would it error when I'm not making any queries at all...

[itsgoingd]

Yeah, I'm not very happy with the current implementation myself. This was done due to a limitation in Laravel 4.0 (the latest version when Clockwork was initially released), which didn't have an api to tell if a database connection was actually being used (was added later) and it was never changed. This will be definitively improved in the next major Clockwork release.

[wayneashleyberry]

awesome, thanks. i'll mark this as closed for now :)