This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

gioymila12759
gioymila12759

The error reported is: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Please note that on the same server, using a standard 'empty' installation, the installation succeeds flawlessly. The installation was run on an empty file system with an empty database; the connection parameters are correct, triple checked.

Following is the relevant section of the install.log Please note how the PDO is trying to create a connection string that does not reflect the database parameters logged just a few lines above: the host should be sql.coordinamentobdt.it but the PDO is trying to connect to localhost, which will obviously fail ... [db_type] => mysql [db_host] => sql.coordinamentobdt.it [db_port] => [db_name] => coordina77310 [db_user] => coordina77310 [db_pass] => [admin_first_name] => Giorgio [admin_last_name] => Malagutti [admin_email] => @*.com [admin_login] => giorgio [admin_password] => *** [admin_confirm_password] => [backend_uri] => /amministrazione [encryption_code] => [file_mask] => 777 [folder_mask] => 777 [handler] => onInstallStep )

[2016/04/28 10:42:40] Install step: setupConfig [2016/04/28 08:42:40] Handler error (onInstallStep): SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [2016/04/28 08:42:40] Trace log:

0 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(47): PDO->__construct('mysql:host=loca...', 'root', '', Array)

1 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(20): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=loca...', Array, Array)

2 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(58): Illuminate\Database\Connectors\MySqlConnector->connect(Array)

3 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(47): Illuminate\Database\Connectors\ConnectionFactory->createSingleConnection(Array)

4 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(177): Illuminate\Database\Connectors\ConnectionFactory->make(Array, 'mysql')

5 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(65): Illuminate\Database\DatabaseManager->makeConnection('mysql')

6 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(3146): Illuminate\Database\DatabaseManager->connection(NULL)

7 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(3112): Illuminate\Database\Eloquent\Model::resolveConnection(NULL)

8 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/october/rain/src/Database/Model.php(389): Illuminate\Database\Eloquent\Model->getConnection()

9 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1828): October\Rain\Database\Model->newBaseQueryBuilder()

10 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1802): Illuminate\Database\Eloquent\Model->newQueryWithoutScopes()

11 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(3360): Illuminate\Database\Eloquent\Model->newQuery()

12 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/october/rain/src/Extension/ExtendableTrait.php(368): Illuminate\Database\Eloquent\Model->__call('where', Array)

13 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/october/rain/src/Database/Model.php(419): October\Rain\Database\Model->extendableCall('where', Array)

14 /home/mhd-01/www.coordinamentobdt.it/htdocs/modules/system/behaviors/SettingsModel.php(113): October\Rain\Database\Model->__call('where', Array)

15 /home/mhd-01/www.coordinamentobdt.it/htdocs/modules/system/behaviors/SettingsModel.php(113): Renatio\BackupManager\Models\Settings->where('item', 'renatio_backupm...')

16 /home/mhd-01/www.coordinamentobdt.it/htdocs/modules/system/behaviors/SettingsModel.php(78): System\Behaviors\SettingsModel->getSettingsRecord()

17 [internal function]: System\Behaviors\SettingsModel->instance()

18 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/october/rain/src/Extension/ExtendableTrait.php(354): call_user_func_array(Array, Array)

19 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/october/rain/src/Database/Model.php(419): October\Rain\Database\Model->extendableCall('instance', Array)

20 [internal function]: October\Rain\Database\Model->__call('instance', Array)

21 [internal function]: Renatio\BackupManager\Models\Settings->instance()

22 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(3376): call_user_func_array(Array, Array)

23 /home/mhd-01/www.coordinamentobdt.it/htdocs/plugins/renatio/backupmanager/Plugin.php(113): Illuminate\Database\Eloquent\Model::__callStatic('instance', Array)

24 /home/mhd-01/www.coordinamentobdt.it/htdocs/plugins/renatio/backupmanager/Plugin.php(113): Renatio\BackupManager\Models\Settings::instance()

25 /home/mhd-01/www.coordinamentobdt.it/htdocs/modules/system/ServiceProvider.php(199): Renatio\BackupManager\Plugin->registerSchedule(Object(Illuminate\Console\Scheduling\Schedule))

26 [internal function]: System\ServiceProvider->System{closure}(Object(Illuminate\Console\Scheduling\Schedule))

27 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(218): call_user_func_array(Object(Closure), Array)

28 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/october/rain/src/Foundation/Console/Kernel.php(44): Illuminate\Events\Dispatcher->fire('console.schedul...', Array)

29 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(78): October\Rain\Foundation\Console\Kernel->schedule(Object(Illuminate\Console\Scheduling\Schedule))

30 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(63): Illuminate\Foundation\Console\Kernel->defineConsoleSchedule()

31 [internal function]: Illuminate\Foundation\Console\Kernel->Illuminate\Foundation\Console{closure}(Object(October\Rain\Foundation\Application))

32 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(862): call_user_func(Object(Closure), Object(October\Rain\Foundation\Application))

33 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(690): Illuminate\Foundation\Application->fireAppCallbacks(Array)

34 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(15): Illuminate\Foundation\Application->boot()

35 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(183): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap(Object(October\Rain\Foundation\Application))

36 /home/mhd-01/www.coordinamentobdt.it/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(195): Illuminate\Foundation\Application->bootstrapWith(Array)

37 /home/mhd-01/www.coordinamentobdt.it/htdocs/install_files/php/Installer.php(674): Illuminate\Foundation\Console\Kernel->bootstrap()

38 /home/mhd-01/www.coordinamentobdt.it/htdocs/install_files/php/Installer.php(405): Installer->bootFramework()

39 /home/mhd-01/www.coordinamentobdt.it/htdocs/install_files/php/Installer.php(375): Installer->buildConfigFile()

40 /home/mhd-01/www.coordinamentobdt.it/htdocs/install_files/php/Installer.php(48): Installer->onInstallStep()

41 /home/mhd-01/www.coordinamentobdt.it/htdocs/install_files/php/boot.php(74): Installer->__construct()

42 /home/mhd-01/www.coordinamentobdt.it/htdocs/install.php(1): include('/home/mhd-01/ww...')

43 {main}

...

gioymila12759
gioymila12759

Note also that the parameters in the file config/database.php are wrong when the exception is thrown and fixing them manually and retrying will cause a second error of missing table in the database. At that point the database would still be completely empty.

gioymila12759
gioymila12759

I really need to install from a project id, I am porting to a new server an existing project. Being that it does not appear to work, can I try to create an empty installation, then change the project ID in the installation and apply the updates? Would that work? Where is that information stored on the server? Any better idea?

sati10011116305
sati10011116305

hello i have this problem but i have installing this cms , show erorr " live connection " this cms installing on port 80 but in my system port 80 is busy.and i have xampp active . and phpmyadmin active on port 8081 . i dont know what to do ? can you help me??? thankyou

gioymila12759
gioymila12759

Hi, What I did was prepare a simple, plain installation without specifying the project ID. Then I assigned it later once the cms had been installed. If you can't even install an empty project, I suggest you look for topics concerning communication ports. Hope this helps,

Giorgio

sati10011116305
sati10011116305

ok , i have one question onother : can i changing this port ? this main : in octobr cms install porting swich to 8081 or change to 8081 that sing with my localhost .but how?

or disable the port that busy by system .but how?

gioymila12759
gioymila12759

It is a prerequisite od the installation to have the port 80 available, so I assume you must look for the process that keeps that port busy and close it. Read here: http://stackoverflow.com/questions/1960750/how-to-find-which-program-is-using-port-80-in-windows

sati10011116305
sati10011116305

ok thankyou i find that and close it and i swiched the port 8081 localhost to 80 and try retry installing this cms but show that error " live connection ". in ducumention say " The installer will test a connection to the installation server using port 80. Check that your webserver can create outgoing connections on port 80 via PHP. Contact your hosting provider or this is often found in the server firewall settings " my firewall is off . i whant install this but show error . no way for this . can i do ???

1-8 of 8

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.