[GH-ISSUE #227] ViMb SQL connection to remote server #178

Closed
opened 2026-02-26 09:36:32 +03:00 by kerem · 4 comments
Owner

Originally created by @ghost on GitHub (Jun 11, 2017).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/227

Trying to connect to remote sql db as mail server cannot support, changed application.ini and getting

File
/usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
Line
103
Message
An exception occured in driver: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Code
0

Trace

#0 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(133): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(47): Doctrine\DBAL\DBALException::driverException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException))
#2 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'vimbadmin', 'Password',
Password', Array)
#3 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\DBAL\Connection->connect()
#4 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#5 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#6 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(582): Doctrine\DBAL\Connection->getDatabasePlatform()
#7 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(434): Doctrine\ORM\Mapping\ClassMetadataFactory->getTargetPlatform()
#8 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(139): Doctrine\ORM\Mapping\ClassMetadataFactory->completeIdGeneratorMapping(Object(Doctrine\ORM\Mapping\ClassMetadata))
#9 /usr/local/vimbadmin/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(332): Doctrine\ORM\Mapping\ClassMetadataFactory->doLoadMetadata(Object(Doctrine\ORM\Mapping\ClassMetadata), NULL, false, Array)
#10 /usr/local/vimbadmin/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(216): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata('Entities\Admin')
#11 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(265): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor('Entities\Admin')
#12 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php(67): Doctrine\ORM\EntityManager->getClassMetadata('Entities\Admin')
#13 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php(50): Doctrine\ORM\Repository\DefaultRepositoryFactory->createRepository(Object(Doctrine\ORM\EntityManager), 'Entities\Admin')
#14 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(665): Doctrine\ORM\Repository\DefaultRepositoryFactory->getRepository(Object(Doctrine\ORM\EntityManager), '\Entities\Admin')
#15 /usr/local/vimbadmin/application/controllers/AuthController.php(52): Doctrine\ORM\EntityManager->getRepository('\Entities\Admin')
#16 /usr/local/vimbadmin/vendor/opensolutions/oss-framework/src/OSS/Controller/Trait/Auth.php(99): AuthController->_preLogin()
#17 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): AuthController->loginAction()
#18 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('loginAction')
#19 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#20 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#21 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#22 /usr/local/vimbadmin/public/index.php(34): Zend_Application->run()
#23 {main}

Originally created by @ghost on GitHub (Jun 11, 2017). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/227 Trying to connect to remote sql db as mail server cannot support, changed application.ini and getting File /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php Line 103 Message An exception occured in driver: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Code 0 Trace #0 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(133): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException)) #1 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(47): Doctrine\DBAL\DBALException::driverException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException)) #2 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'vimbadmin', 'Password', Password', Array) #3 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\DBAL\Connection->connect() #4 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion() #5 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform() #6 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(582): Doctrine\DBAL\Connection->getDatabasePlatform() #7 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(434): Doctrine\ORM\Mapping\ClassMetadataFactory->getTargetPlatform() #8 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(139): Doctrine\ORM\Mapping\ClassMetadataFactory->completeIdGeneratorMapping(Object(Doctrine\ORM\Mapping\ClassMetadata)) #9 /usr/local/vimbadmin/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(332): Doctrine\ORM\Mapping\ClassMetadataFactory->doLoadMetadata(Object(Doctrine\ORM\Mapping\ClassMetadata), NULL, false, Array) #10 /usr/local/vimbadmin/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(216): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata('Entities\\Admin') #11 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(265): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor('Entities\\Admin') #12 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php(67): Doctrine\ORM\EntityManager->getClassMetadata('Entities\\Admin') #13 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php(50): Doctrine\ORM\Repository\DefaultRepositoryFactory->createRepository(Object(Doctrine\ORM\EntityManager), 'Entities\\Admin') #14 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(665): Doctrine\ORM\Repository\DefaultRepositoryFactory->getRepository(Object(Doctrine\ORM\EntityManager), '\\Entities\\Admin') #15 /usr/local/vimbadmin/application/controllers/AuthController.php(52): Doctrine\ORM\EntityManager->getRepository('\\Entities\\Admin') #16 /usr/local/vimbadmin/vendor/opensolutions/oss-framework/src/OSS/Controller/Trait/Auth.php(99): AuthController->_preLogin() #17 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): AuthController->loginAction() #18 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('loginAction') #19 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #20 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch() #21 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run() #22 /usr/local/vimbadmin/public/index.php(34): Zend_Application->run() #23 {main}
kerem closed this issue 2026-02-26 09:36:32 +03:00
Author
Owner

@barryo commented on GitHub (Jun 14, 2017):

Hi,

I'm afraid this is neither a ViMbAdmin bug or issue. Try Googling this and you may find many answers:

An exception occured in driver: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Otherwise, take it up on the ViMbAdmin mailing list with an excerpt of the doctrine settings from your application.ini.

<!-- gh-comment-id:308330188 --> @barryo commented on GitHub (Jun 14, 2017): Hi, I'm afraid this is neither a ViMbAdmin bug or issue. Try Googling this and you may find many answers: > An exception occured in driver: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Otherwise, take it up on the ViMbAdmin mailing list with an excerpt of the `doctrine` settings from your application.ini.
Author
Owner

@ghost commented on GitHub (Jun 14, 2017):

Try getting a clue, and doing some research instead of running your mouth
and you may find some anwsers. Fucking read the issue next time...

On Jun 13, 2017 23:15, "barryo" notifications@github.com wrote:

Closed #227 https://github.com/opensolutions/ViMbAdmin/issues/227.


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/opensolutions/ViMbAdmin/issues/227#event-1122655893,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AOkR8bGGgix0Pg2GT-IU1gv2slApCNvbks5sD3qYgaJpZM4N2Tbd
.

<!-- gh-comment-id:308388041 --> @ghost commented on GitHub (Jun 14, 2017): Try getting a clue, and doing some research instead of running your mouth and you may find some anwsers. Fucking read the issue next time... On Jun 13, 2017 23:15, "barryo" <notifications@github.com> wrote: > Closed #227 <https://github.com/opensolutions/ViMbAdmin/issues/227>. > > — > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub > <https://github.com/opensolutions/ViMbAdmin/issues/227#event-1122655893>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/AOkR8bGGgix0Pg2GT-IU1gv2slApCNvbks5sD3qYgaJpZM4N2Tbd> > . >
Author
Owner

@barryo commented on GitHub (Jun 14, 2017):

I read the issue, no research required, answer is the same.

<!-- gh-comment-id:308390854 --> @barryo commented on GitHub (Jun 14, 2017): I read the issue, no research required, answer is the same.
Author
Owner

@barryo commented on GitHub (Jun 14, 2017):

For the record:

https://www.vimbadmin.net/support.php

<!-- gh-comment-id:308392251 --> @barryo commented on GitHub (Jun 14, 2017): For the record: https://www.vimbadmin.net/support.php
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/ViMbAdmin-opensolutions#178
No description provided.