Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
ipbfuck Posted May 10, 2016 Posted May 10, 2016 Hi, i've try to enable cron in my new webhosting: ips: cpanel: */applications/core/interface/task/task.php permissions to 777 log: Tue, 10 May 2016 19:14:01 +0000 (Severity: 2) - Command line IPS\Db\Exception: No such file or directory (2002) #0 /***/***/public_***/system/Data/Store/Database.php(111): IPS\_Db::i() #1 /***/***/public_***/system/Data/Store/Database.php(152): IPS\Data\Store\_Database->get('settings') #2 /***/***/public_***/system/Data/AbstractData.php(121): IPS\Data\Store\_Database->exists('settings') #3 /***/***/public_***/system/Data/Store.php(188): IPS\Data\_AbstractData->__isset('settings') #4 /***/***/public_***/system/Settings/Settings.php(133): IPS\Data\_Store->__isset('settings') #5 /***/***/public_***/system/Settings/Settings.php(88): IPS\_Settings->loadFromDb() #6 /***/***/public_***/applications/core/interface/task/task.php(29): IPS\_Settings->__get('task_use_cron') #7 {main} ------------------------------------------------------------------------ as result: my suite seems to b "frozen". article view count no increment, all like in standby. if i switch again to: Run Automatically with Traffic (Default) all go back to work again. Someone can help me with this? thanks in advance, S.N.
Nathan Explosion Posted May 10, 2016 Posted May 10, 2016 Unless I'm reading that wrong, you haven't actually set the cron to run at an interval - you've 'wildcarded' everything (minutes/hours/days etc) You need to set one of them to a value to have it run - so set minutes to 1 (as that is what it tells you to do in the instructions - every minute)
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 this is the way autoconfig with my cpanel: (one time every minute) but, indeed, if if i set to "one time every 5minutes, i see this: (with slash) and every 30minutes, instead, i see with comma: so, i need to set as default (every to *), with slash, or with comma? ps: thanks for reply, now i try
tnn Posted May 10, 2016 Posted May 10, 2016 29 minutes ago, laltroweb.it said: Hi, i've try to enable cron in my new webhosting: ips: cpanel: */applications/core/interface/task/task.php permissions to 777 log: Tue, 10 May 2016 19:14:01 +0000 (Severity: 2) - Command line IPS\Db\Exception: No such file or directory (2002) #0 /***/***/public_***/system/Data/Store/Database.php(111): IPS\_Db::i() #1 /***/***/public_***/system/Data/Store/Database.php(152): IPS\Data\Store\_Database->get('settings') #2 /***/***/public_***/system/Data/AbstractData.php(121): IPS\Data\Store\_Database->exists('settings') #3 /***/***/public_***/system/Data/Store.php(188): IPS\Data\_AbstractData->__isset('settings') #4 /***/***/public_***/system/Settings/Settings.php(133): IPS\Data\_Store->__isset('settings') #5 /***/***/public_***/system/Settings/Settings.php(88): IPS\_Settings->loadFromDb() #6 /***/***/public_***/applications/core/interface/task/task.php(29): IPS\_Settings->__get('task_use_cron') #7 {main} ------------------------------------------------------------------------ as result: my suite seems to b "frozen". article view count no increment, all like in standby. if i switch again to: Run Automatically with Traffic (Default) all go back to work again. Someone can help me with this? thanks in advance, S.N. For every minute it should be * * * * * but not sure what the problem is. I'm thinking the path or command have an issue.
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 im also think can be somethink related to: /usr/local/php560-cgi/bin/php maybe ipb see this for some reason, but is not valid (maybe my hosting pass a bad value, i don't know) :/
tnn Posted May 10, 2016 Posted May 10, 2016 Just now, laltroweb.it said: im also think can be somethink related to: /usr/local/php560-cgi/bin/php maybe ipb see this for some reason, but is not valid (maybe my hosting pass a bad value, i don't know) :/ I think your host support can check the path for you, worth a try and will eliminate one suspect. 2 minutes ago, laltroweb.it said: im also think can be somethink related to: /usr/local/php560-cgi/bin/php maybe ipb see this for some reason, but is not valid (maybe my hosting pass a bad value, i don't know) :/ Meanwhile you can try /usr/local/bin/php
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 i've try, bad result in log: Tue, 10 May 2016 19:58:01 +0000 (Severity: 2) - Command line IPS\Db\Exception: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (2002) #0 /***/***/public_***/system/Data/Store/Database.php(89): IPS\_Db::i() #1 /***/***/public_***/system/Data/Store/Database.php(105): IPS\Data\Store\_Database->loadIntoMemory(Array) #2 /***/***/public_***/system/Data/Store/Database.php(152): IPS\Data\Store\_Database->get('cacheKeys') #3 /***/***/public_***/system/Data/AbstractData.php(121): IPS\Data\Store\_Database->exists('cacheKeys') #4 /***/***/public_***/system/Data/Store.php(188): IPS\Data\_AbstractData->__isset('cacheKeys') #5 /***/***/public_***/system/Data/Store.php(179): IPS\Data\_Store->__isset('cacheKeys') #6 /***/***/public_***/system/Settings/Settings.php(133): IPS\Data\_Store->__isset('settings') #7 /***/***/public_***/system/Settings/Settings.php(88): IPS\_Settings->loadFromDb() #8 /***/***/public_***/applications/core/interface/task/task.php(29): IPS\_Settings->__get('task_use_cron') #9 {main} i'll try to open a ticket with host thanks for replies
tnn Posted May 10, 2016 Posted May 10, 2016 Just now, laltroweb.it said: i've try, bad result in log: Tue, 10 May 2016 19:58:01 +0000 (Severity: 2) - Command line IPS\Db\Exception: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (2002) #0 /***/***/public_***//system/Data/Store/Database.php(89): IPS\_Db::i() #1 /***/***/public_***//system/Data/Store/Database.php(105): IPS\Data\Store\_Database->loadIntoMemory(Array) #2 /***/***/public_***//system/Data/Store/Database.php(152): IPS\Data\Store\_Database->get('cacheKeys') #3 /***/***/public_***//system/Data/AbstractData.php(121): IPS\Data\Store\_Database->exists('cacheKeys') #4 /***/***/public_***//system/Data/Store.php(188): IPS\Data\_AbstractData->__isset('cacheKeys') #5 /***/***/public_***//system/Data/Store.php(179): IPS\Data\_Store->__isset('cacheKeys') #6 /***/***/public_***//system/Settings/Settings.php(133): IPS\Data\_Store->__isset('settings') #7 /***/***/public_***//system/Settings/Settings.php(88): IPS\_Settings->loadFromDb() #8 /***/***/public_***//applications/core/interface/task/task.php(29): IPS\_Settings->__get('task_use_cron') #9 {main} i'll try to open a ticket with host thanks for replies Oops, you have a ***// instead of ***/
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 just a small mistake during replace in notepad++, sorry, i've replaced immediately, but not sufficiently
Daniel F Posted May 10, 2016 Posted May 10, 2016 Make sure that your php cli interpreter can connect to mysql!
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 this seems to be a good question but, sorry, i need to reply with another question: What? no, really, i don't know... is there something i can check/test?
Daniel F Posted May 10, 2016 Posted May 10, 2016 ask your webhost Tell them that you're getting following error Quote Tue, 10 May 2016 19:58:01 +0000 (Severity: 2) - Command line IPS\Db\Exception: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (2002)
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 Ok, thanks but ipb report me to connect with: /usr/local/php560-cgi/bin/php ... anyway, now i try (and if i hanve news i report here). regards...
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 ... maybe can be useful: source (just provisory)... ***.php?phpinfo i have custom php.ini, then, if something need to be enable, i can try...
Aiwa Posted May 10, 2016 Posted May 10, 2016 http://stackoverflow.com/questions/1676688/php-mysql-connection-not-working-2002-no-such-file-or-directory
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 i've read, but i've already bot var to: var/lib/mysql/mysql.sock mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock +++ mysqli.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock anyway, thanks to this link i've seen also other info and put in php.ini: mysql.default_host = 127.0.0.1 mysqli.default_host = 127.0.0.1 mysql.default_port = 3306 mysqli.default_port = 3306 now present in phpinfo, but error persist. maybe is required also user and password? :|
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 Reply by my host: i use cgi-bin config, with 5.6, then path is valid and i need to use this full path! from test by host support, no response from this command: /usr/local/php560-cgi/bin/php -d memory_limit=-1 -d max_execution_time=0 /***/***/public_***/applications/core/interface/task/task.php *** then, all seems to be ok from hosting. in system log i can see this (no more connection database issue - now we have no such file or directory...): Tue, 10 May 2016 21:29:01 +0000 (Severity: 2) - Command line IPS\Db\Exception: No such file or directory (2002) #0 /***/***/public_***/system/Data/Store/Database.php(111): IPS\_Db::i() #1 /***/***/public_***/system/Data/Store/Database.php(152): IPS\Data\Store\_Database->get('settings') #2 /***/***/public_***/system/Data/AbstractData.php(121): IPS\Data\Store\_Database->exists('settings') #3 /***/***/public_***/system/Data/Store.php(188): IPS\Data\_AbstractData->__isset('settings') #4 /***/***/public_***/system/Settings/Settings.php(133): IPS\Data\_Store->__isset('settings') #5 /***/***/public_***/system/Settings/Settings.php(88): IPS\_Settings->loadFromDb() #6 /***/***/public_***/applications/core/interface/task/task.php(29): IPS\_Settings->__get('task_use_cron') #7 {main} ------------------------------------------------------------------------ and my suite is again frozen :/
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 Finally, i won - After many search, many test with hosting support, many time lost on this for try to understood why problem with path or connection etc... i've found answer! change in local php.ini can't real set 127.0.0.1 instead of localhost, and for some strange reason - something - localhost is already used and cannot be used for other resources. then, my question is, if i cannot change, how i can make "free" localhost? then, i've edit conf_global.php: from: 'sql_host' => 'localhost', to: 'sql_host' => '127.0.0.1', and try again cron and, finally, all work as expected anyway, i've used /usr/local/bin/php instead of full path. thanks to all for support and time. i hope, in future, this can help other user. regards
tnn Posted May 10, 2016 Posted May 10, 2016 2 hours ago, laltroweb.it said: Reply by my host: i use cgi-bin config, with 5.6, then path is valid and i need to use this full path! from test by host support, no response from this command: /usr/local/php560-cgi/bin/php -d memory_limit=-1 -d max_execution_time=0 /***/***/public_***/applications/core/interface/task/task.php *** then, all seems to be ok from hosting. in system log i can see this (no more connection database issue - now we have no such file or directory...): Tue, 10 May 2016 21:29:01 +0000 (Severity: 2) - Command line IPS\Db\Exception: No such file or directory (2002) #0 /***/***/public_***/system/Data/Store/Database.php(111): IPS\_Db::i() #1 /***/***/public_***/system/Data/Store/Database.php(152): IPS\Data\Store\_Database->get('settings') #2 /***/***/public_***/system/Data/AbstractData.php(121): IPS\Data\Store\_Database->exists('settings') #3 /***/***/public_***/system/Data/Store.php(188): IPS\Data\_AbstractData->__isset('settings') #4 /***/***/public_***/system/Settings/Settings.php(133): IPS\Data\_Store->__isset('settings') #5 /***/***/public_***/system/Settings/Settings.php(88): IPS\_Settings->loadFromDb() #6 /***/***/public_***/applications/core/interface/task/task.php(29): IPS\_Settings->__get('task_use_cron') #7 {main} ------------------------------------------------------------------------ and my suite is again frozen :/ Ok, to be sure, where it has ***/ , for my cron it has the actual path names, I don't have ***/ . Should it be the actual letters (asking because I don't know) Also, did you show your host support the info @Daniel F mentioned? I think that is important. Never mind! Glad you are good to go!
ipbfuck Posted May 10, 2016 Author Posted May 10, 2016 i've simply "censored" my web path with *** regards, and thank'u
tnn Posted May 10, 2016 Posted May 10, 2016 4 minutes ago, laltroweb.it said: i've simply "censored" my web path with *** regards, and thank'u Ahh, understand.
Philip Gaines Posted June 18, 2016 Posted June 18, 2016 I seam to be having a big problem with all this upgrade. I've had this now for the last 8 days and its not moved one bit in that time. i was getting this error all the time:- PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /home/mulphy/public_html/system/Patterns/ActiveRecord.php on line 285 I was told by support that i need the host to sort out the Mod_Security which go daddy have told me no not at all. So today i set up cron which i've never used before so i more or less stumbled my way around it and now i'm getting this message:- Here's how i set up cron:- Admin CP:- So i copied the text and then opened cron jobs in go daddy's channel and added the task.. Then cron it says i need to add the following to stop the reports as go daddy have told me my e-mail may get flooded with them, they suggested i add at the end:- >/dev/null 2>&1 Current Cron Jobs MinuteHourDayMonthWeekdayCommandActions * * * * */usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/mulphy/public_html/applications/core/interface/task/task.php cbd4b4c788fc62d4f600e28eb82c45ad >/dev/null 2>&1 I would be grateful for any help or direction on the as I'm not lost and don't know what else i can do.. Thanks
Philip Gaines Posted June 19, 2016 Posted June 19, 2016 Here my "conf_global.php" file:- I'm not sure is this is right or not... ?php $INFO['sql_driver'] = 'mysql'; $INFO['sql_host'] = 'localhost'; $INFO['sql_database'] = 'mysitel_ipb'; $INFO['sql_user'] = 'mysite_ips'; $INFO['sql_pass'] = '0p.4#7(I7JhW'; $INFO['sql_tbl_prefix'] = 'ibf_'; $INFO['sql_debug'] = '1'; $INFO['sql_charset'] = 'utf8mb4'; $INFO['sql_utf8mb4'] = true; $INFO['board_start'] = '1194731929'; $INFO['installed'] = '1'; $INFO['php_ext'] = 'php'; $INFO['safe_mode'] = '0'; $INFO['board_url'] = 'http://www.mysite.com'; $INFO['banned_group'] = '5'; $INFO['admin_group'] = '4'; $INFO['guest_group'] = '2'; $INFO['member_group'] = '3'; $INFO['auth_group'] = '1'; $INFO['mysql_tbl_type'] = 'MyISAM'; $INFO['use_friendly_urls'] = '1'; ?>
Philip Gaines Posted June 20, 2016 Posted June 20, 2016 All i seam to be getting is errors in the "error log" in public.html I have now removed the " >/dev/null 2>&1" but it seams to have made no deference at all.... Should i change the localhost in "conf_global.php" file...? ?php $INFO['sql_driver'] = 'mysql';$INFO['sql_host'] = 'localhost'; $INFO['sql_database'] = 'mysitel_ipb'; $INFO['sql_user'] = 'mysite_ips'; $INFO['sql_pass'] = '0p.4#7(I7JhW'; $INFO['sql_tbl_prefix'] = 'ibf_'; $INFO['sql_debug'] = '1'; $INFO['sql_charset'] = 'utf8mb4'; $INFO['sql_utf8mb4'] = true; $INFO['board_start'] = '1194731929'; $INFO['installed'] = '1'; $INFO['php_ext'] = 'php'; $INFO['safe_mode'] = '0'; $INFO['board_url'] = 'http://www.mysite.com'; $INFO['banned_group'] = '5'; $INFO['admin_group'] = '4'; $INFO['guest_group'] = '2'; $INFO['member_group'] = '3'; $INFO['auth_group'] = '1'; $INFO['mysql_tbl_type'] = 'MyISAM'; $INFO['use_friendly_urls'] = '1'; ?>
Aiwa Posted June 20, 2016 Posted June 20, 2016 Make sure the task.php file has 777 permissions. In addition, you have a code error somewhere in a template. Those are your error logs. You need to look in your CRON logs to see if it's running correctly.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.