FUDforum: How To » I cant connect to my forum neither to ftp

Home » FUDforum » How To » I cant connect to my forum neither to ftp (...after setting a job newsgroup)

Show: Today's Messages :: Polls :: Message Navigator

I cant connect to my forum neither to ftp [message #165672]

Thu, 04 August 2011 02:05

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

Today i installed the fud forum but when i created a minute (*/2) job schedule with one newsgroup, i cant connect to forum neither to ftp.
How can i resolve this problem ?

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165673 is a reply to message #165672]

Thu, 04 August 2011 03:52

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

The job is for "Minute */2" (i mean for eatch 2 minutes)
Is this correct ?

[Updated on: Thu, 04 August 2011 03:53]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165674 is a reply to message #165673]

Thu, 04 August 2011 04:26

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

I send a ticket to my web host and now i can connect, but the cronjob newsgroup dont run !

see the errors that i receive :

Latest SQL Errors
Time	Error Description
Thu Aug 4 4:19:39 GMT 2011	(/home/zinobios/FUDforum/include/theme/default/db.inc:75
/home/zinobios/FUDforum/include/job.inc:103
/home/zinobios/FUDforum/scripts/cron.php:78
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = 1' at line 1
Query: UPDATE fud30_jobs SET locked = 1312431579, nextrun = WHERE id = 1
Database version: 5.0.77
[Referring Page] http://zinobios.webfactional.com/adm/admjobs.php?log=1&S=e77bcdc2356afc61cd6994afc90561e5&SQ=7f62fd9fbd99f6467dae5415e52d6e7c&rand=416613021
Thu Aug 4 4:16:56 GMT 2011	(/home/zinobios/FUDforum/include/theme/default/db.inc:75
/home/zinobios/FUDforum/include/job.inc:103
/home/zinobios/FUDforum/scripts/cron.php:78
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = 1' at line 1
Query: UPDATE fud30_jobs SET locked = 1312431416, nextrun = WHERE id = 1
Database version: 5.0.77
[Referring Page] http://zinobios.webfactional.com/adm/admjobs.php

  Total: 2 error(s). [ clear log ]
Latest Newsgroup Errors
Time	Error Description
Wed Aug 3 21:11:16 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312405880_b8ed67064dc5fed1d50e7d6273e595fb
Wed Aug 3 21:11:16 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312405879_3ad3f3f5ef89a78be1d8e1a18664d2b5
Wed Aug 3 21:11:16 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312405879_f740d267c02552311b78c215e478d24a
Wed Aug 3 21:11:16 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312405879_4b5ab521df3d58f8eab059d51415a569
Wed Aug 3 20:47:12 GMT 2011	Blank subject @ /home/zinobios/FUDforum/errors/.nntp/1312404435_49d8e5f31b6b4966b57c3b711c8d3e0b

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165679 is a reply to message #165674]

Thu, 04 August 2011 06:25

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

To be honest, it was tested with x,y,x... syntax, but never with x/y.
I'll get back to this later.

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165680 is a reply to message #165679]

Thu, 04 August 2011 06:44

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

At the Scheduled jobs , when i click "Run now" the job run correct.
But the Scheduled job dont run by self ** !
I changed the Minute field to : "0,5,10,15,20,25,30,35,40,45,50,5" but the last number is corrupted (55)*. The Scheduled job dont run by self again!

* I want to set the scheduled job run every 3 minutes.This is not possible !

**Why dont run by self ?

[Updated on: Thu, 04 August 2011 06:49]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165681 is a reply to message #165680]

Thu, 04 August 2011 09:17

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

It is stored in a VARCHAR(32) and truncated. I'll increase the length before the next release.

Jobs won't run by itself. You need to schedule a cron job or sign up for a scheduling service like setcronjob.com or cronless.com. You can also write a patch/plugin to trigger cron as users visit the site, but that isn't currently implemented. Something you can maybe help us with? Rolling Eyes

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165682 is a reply to message #165681]

Thu, 04 August 2011 13:55

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

At the start of nntp.php there is :

#!/usr/bin/php -q

At my cace the PHP CLI Executable is: /usr/local/bin/php (i ran the "which php" shell command to find this)

Need to change the above code with this at the nntp.php ?

 #!/usr/local/bin/php -q

Wait for your answer.

See at the http://cvs.prohost.org/index.php/Job_Administration_System
It say that :

Minute

Minute(s) when the job should run. Multiple values should be comma separated.

For example:

    enter * to run on every minute.
    enter */2 to run it every 2 minutes.
    enter 0,15,30,45 to run it on minutes 0, 15, 30 and 45.

and it say that :

The Job Manager admin control panel can be used to schedule or run ad hoc tasks like backups, import messages from a mailing list, USENET groups or XML Feeds.

[Updated on: Thu, 04 August 2011 14:28]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165683 is a reply to message #165682]

Thu, 04 August 2011 15:12

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Then you will probably have to change it to /usr/local/bin/php.

I've added the */2 example today while I was writing a patch to support it. It will, however, only be available in the next release.

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165684 is a reply to message #165683]

Thu, 04 August 2011 15:21

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

The http://cvs.prohost.org/index.php/Job_Administration_System is wrong ?

1)The Job Manager dont work for schedule tasks ?
2)The example dont work for */2 ?

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165685 is a reply to message #165684]

Thu, 04 August 2011 15:44

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

1) Yes, it does schedule jobs, but only if you have cron set-up. It is confusing, I know, but it is optional and you can still schedule/run your jobs manually without it.

2) Yes, it's wrong! I'm a bad and cruel person, ain't I?

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165686 is a reply to message #165685]

Thu, 04 August 2011 15:57

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

I am sorry ! (and sorry for my english !)

Please, can you say me how can i scedule a a nntp job manually ?
The example: ( at http://cvs.prohost.org/index.php/NNTP_Manager )

*/2 * * * * /home/forum/forum/scripts/nntp.php 1

is correct ?
The */2 works ? Or i will have problem ?
What must i write with ssh ? Please write me an example.

[Updated on: Thu, 04 August 2011 15:57]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165687 is a reply to message #165686]

Thu, 04 August 2011 16:21

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Yes, it's correct.
And yes, the */2 will work in cron.
You can ask you hosting provider to help you to set-up the job.

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165688 is a reply to message #165687]

Thu, 04 August 2011 16:30

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

At the Job Administration, the nntp_1 Scheduled job must be enable or disable, so i can run the external crontab ?

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165691 is a reply to message #165688]

Thu, 04 August 2011 18:26

zino
Messages: 24
Registered: August 2011
Location: Greece

Karma: 0

Junior Member

I wrote at the crontab this line :

*/3 * * * * /usr/local/bin/php  /home/zinobios/FUDforum/scripts/nntp.php 1

and works fine !

Please read my other post about the subjects with greek letters...

[Updated on: Thu, 04 August 2011 18:32]

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #165695 is a reply to message #165691]

Thu, 04 August 2011 19:51

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Well done!

Report message to a moderator

Re: I cant connect to my forum neither to ftp [message #166219 is a reply to message #165695]

Fri, 14 October 2011 03:22

shenglu

Messages: 1
Registered: October 2011

Karma: 0

Junior Member

You need to arrange a cron job, or as setcronjob.com or cronless.com dispatch services. When a user accesses the site, you can write a patch / plug-in cron trigger.

Report message to a moderator

Previous Topic:	Scrunched menu
Next Topic:	Reorder User Control Icons

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 18 03:21:57 GMT 2024

Total time taken to generate the page: 0.02444 seconds