We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Unexplained errors | Forum

fouad
fouad Mar 13 '15

Hi Ross,


This is an error/s that I found in the error log and seems to have occurred at or straight after installation.


[Mon Mar 9 18:00:38 2015] [ow_core_log] [Exception] Message: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) File: /home/itserecom/public_html/pro/ow_core/database.php Line:223 Trace: [#0 /home/itserecom/public_html/pro/ow_core/database.php(253): OW_Database->__construct(Array) | #1 /home/itserecom/public_html/pro/ow_core/ow.php(230): OW_Database::getInstance(Array) | #2 /home/itserecom/public_html/pro/ow_core/base_dao.php(47): OW::getDbo() | #3 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/config_dao.php(66): OW_BaseDao->__construct() | #4 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/config_dao.php(55): BOL_ConfigDao->__construct() | #5 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/config_service.php(63): BOL_ConfigDao::getInstance() | #6 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/config_service.php(52): BOL_ConfigService->__construct() | #7 /home/itserecom/public_html/pro/ow_core/config.php(48): BOL_ConfigService::getInstance() | #8 /home/itserecom/public_html/pro/ow_core/config.php(68): OW_Config->__construct() | #9 /home/itserecom/public_html/pro/ow_core/ow.php(167): OW_Config::getInstance() | #10 /home/itserecom/public_html/pro/ow_core/ow.php(100): OW::getConfig() | #11 /home/itserecom/public_html/pro/ow_core/ow.php(145): OW::detectContext() | #12 /home/itserecom/public_html/pro/index.php(44): OW::getApplication() | #13 {main}]
[Mon Mar 9 18:31:10 2015] [ow_core_log] [Exception] Message: Package pointer `ADMIN_WPCTRL` is not registered! File: /home/itserecom/public_html/pro/ow_core/autoload.php Line:130 Trace: [#0 /home/itserecom/public_html/pro/ow_core/default_route.php(158): OW_Autoload->getClassPath('ADMIN_WPCTRL_Js') | #1 /home/itserecom/public_html/pro/ow_core/router.php(338): OW_DefaultRoute->getDispatchAttrs('wp-admin/js/med...') | #2 /home/itserecom/public_html/pro/ow_core/application.php(253): OW_Router->route() | #3 /home/itserecom/public_html/pro/index.php(62): OW_Application->route() | #4 {main}]


It/they seem to be referring to many things which I find confusing. Could you look into what seems to be causing this and advise how to resolve. 


Thanks.


fouad
fouad Mar 15 '15
Anyone cares to comment on the above?
tammy harris
tammy harris Mar 15 '15
is the site running did it install 
if not check these

chech db name and pass in cpanel make shore the user has full permisions for that db
n ow_includes/config
make shore the databass details are right


 
ross Team
ross Mar 16 '15
Fouad, it has nothing to do with the software, check the search results in google:

https://www.google.com/?gws_rd=ssl#q=Message:+SQLSTATE%5BHY000%5D+%5B2002%5D+Can%27t+connect+to+local+MySQL+server+through+socket+%27%2Ftmp%2Fmysql.sock

or contact your hosting provider to resolve the issue. 

fouad
fouad Mar 16 '15
Ross,


I have changed the config file entry from "define('OW_DB_HOST', 'localhost')" to "define('OW_DB_HOST', '127.0.0.1')". 


Thanks for your help.

ross Team
ross Mar 16 '15
Has this resolved the issue you were having?
fouad
fouad Mar 19 '15
Yes Ross it seems to have resolved the issue.


Thanks.

fouad
fouad Mar 19 '15
Update.


I have found a new error this time relating directly to the change of the alias which means that the error can't be resolved using this method.


here is the error:

[Tue Mar 17 23:44:09 2015] [ow_core_log] [Notice] Message: Undefined index: REQUEST_URI File: /home/itserecom/public_html/pro/ow_core/ow.php Line:108[Tue Mar 17 23:54:37 2015] [ow_core_log] [Exception] Message: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away File: /home/itserecom/public_html/pro/ow_core/database.php Line:707 Trace: [#0 /home/itserecom/public_html/pro/ow_core/database.php(707): PDOStatement->execute() | #1 /home/itserecom/public_html/pro/ow_core/database.php(435): OW_Database->execute('DELETE FROM ow_...', NULL) | #2 /home/itserecom/public_html/pro/ow_core/database.php(448): OW_Database->query('DELETE FROM ow_...', NULL) | #3 /home/itserecom/public_html/pro/ow_core/base_dao.php(189): OW_Database->delete('DELETE FROM ow_...') | #4 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/email_verify_dao.php(146): OW_BaseDao->deleteByExample(Object(OW_Example)) | #5 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/email_verify_service.php(146): BOL_EmailVerifyDao->deleteByCreatedStamp(1426193677) | #6 /home/itserecom/public_html/pro/ow_system_plugins/base/cron.php(58): BOL_EmailVerifyService->deleteByCreatedStamp(1426193677) | #7 /home/itserecom/public_html/pro/ow_cron/run.php(128): BASE_Cron->run() | #8 {main}][Tue Mar 17 20:58:56 2015] [ow_core_log] [Exception] Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (4) File: /home/itserecom/public_html/pro/ow_core/database.php Line:223 Trace: [#0 /home/itserecom/public_html/pro/ow_core/database.php(253): OW_Database->__construct(Array) | #1 /home/itserecom/public_html/pro/ow_core/ow.php(230): OW_Database::getInstance(Array) | #2 /home/itserecom/public_html/pro/ow_core/base_dao.php(47): OW::getDbo() | #3 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/config_dao.php(66): OW_BaseDao->__construct() | #4 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/config_dao.php(55): BOL_ConfigDao->__construct() | #5 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/config_service.php(63): BOL_ConfigDao::getInstance() | #6 /home/itserecom/public_html/pro/ow_system_plugins/base/bol/config_service.php(52): BOL_ConfigService->__construct() | #7 /home/itserecom/public_html/pro/ow_core/config.php(48): BOL_ConfigService::getInstance() | #8 /home/itserecom/public_html/pro/ow_core/config.php(68): OW_Config->__construct() | #9 /home/itserecom/public_html/pro/ow_core/ow.php(167): OW_Config::getInstance() | #10 /home/itserecom/public_html/pro/ow_cron/run.php(48): OW::getConfig() | #11 {main}]



I will be reverting back to using the localhost alias until you come up with another idea of how to fix this.

ross Team
ross Mar 19 '15
Yes, you need to revert to "localhost" instead of 127.0.0.1

Also you database always get disconnected during  a simple query. 

Seems like it is constant issue, I would recommend to contact your hosting provider support team and request some explanations on that because your mysql server goes away during a simple query, it is not right.