I can not get the crontab to work. This is what I have in crontab -e but it will not perform a maint job.
* * * * * su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.p$
I tried changing users in the above string and also "chown" the directories to every combination I can think of.
I can manually get the jobs to run with 15 of 17 jobs performed and get that red banner off timetrex by executing this:
sudo php /usr/share/timetrex/html/maint/cron.php
Any other command other than sudo creates an authorization failed.
Any ideas?
Timetrex version - 11.5.0
Ubuntu 18.04
php - 7.2
Postgres database
installed using deb package AFTER restoring the database from a windows machine, so it loaded as an upgrade.
Cron job errors
Re: Cron job errors
The command you pasted here is cut-off at the end (notice the $), can you please paste the full and complete command that you are using?
If that is the full command, then that is likely your problem as its cut-off and missing the last part.
If that is the full command, then that is likely your problem as its cut-off and missing the last part.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
-
- Posts: 20
- Joined: Mon Jan 23, 2017 10:32 am
Re: Cron job errors
Sorry about that, the cut and paste missed the end and I didn't catch it.
This is the full string in the crontab:
* * * * * su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.php"> /dev/null$
( I have also tried editing that string in multiple ways with no luck, I even set times for it)
The only success I have had is running this manually:
sudo php /usr/share/timetrex/html/maint/cron.php
I'm assuming there is some type of permission issue or peer to peer conflict?
This is the full string in the crontab:
* * * * * su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.php"> /dev/null$
( I have also tried editing that string in multiple ways with no luck, I even set times for it)
The only success I have had is running this manually:
sudo php /usr/share/timetrex/html/maint/cron.php
I'm assuming there is some type of permission issue or peer to peer conflict?
-
- Posts: 20
- Joined: Mon Jan 23, 2017 10:32 am
Re: Cron job errors
Sorry screwed that one up also, here it is:
* * * * * su www-data -c "/usr/share/timetrex/html/maint/cron.php"> /dev/null$
* * * * * su www-data -c "/usr/share/timetrex/html/maint/cron.php"> /dev/null$
Re: Cron job errors
There is still a "$" at the end, if that actually is in your crontab, then the command would fail as it shouldn't be there.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
-
- Posts: 20
- Joined: Mon Jan 23, 2017 10:32 am
Re: Cron job errors
Took the $ off and it still doesn't work.
Can you post an example to a string that is known to work?
Can you post an example to a string that is known to work?
-
- Posts: 20
- Joined: Mon Jan 23, 2017 10:32 am
Re: Cron job errors
Here is some more info. I can manually run the jobs but I get this output below.
user@timetrex:~$ sudo php /usr/share/timetrex/html/maint/cron.php
ERROR: Running as 'root' forbidden! To avoid permission conflicts, must run as the web-server user instead.
Example: su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.php"
NOTE: Jobs are scheduled to run at specific times each day, therefore it is normal for only some jobs to be executed each time this file is run.
Jobs Executed: 17 of 17
Now I'll try what they suggested:
user@timetrex:~$ su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.php"
Password:
su: Authentication failure
user@timetrex:~$
user@timetrex:~$ sudo php /usr/share/timetrex/html/maint/cron.php
ERROR: Running as 'root' forbidden! To avoid permission conflicts, must run as the web-server user instead.
Example: su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.php"
NOTE: Jobs are scheduled to run at specific times each day, therefore it is normal for only some jobs to be executed each time this file is run.
Jobs Executed: 17 of 17
Now I'll try what they suggested:
user@timetrex:~$ su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.php"
Password:
su: Authentication failure
user@timetrex:~$
-
- Posts: 20
- Joined: Mon Jan 23, 2017 10:32 am
Re: Cron job errors
Below are some more attempts:
NO LUCK:
user@timetrex:~$ su www-data -c "/usr/share/timetrex/html/maint/cron.php"
Password:
su: Authentication failure
NO LUCK:
user@timetrex:~$ su root -c "/usr/share/timetrex/html/maint/cron.php"
Password:
/usr/share/timetrex/html/maint/cron.php: line 1: ?php: No such file or directory
/usr/share/timetrex/html/maint/cron.php: line 2: /bin: Is a directory
/usr/share/timetrex/html/maint/cron.php: line 3: Desktop: command not found
/usr/share/timetrex/html/maint/cron.php: line 4: syntax error near unexpected token `('
/usr/share/timetrex/html/maint/cron.php: line 4: ` * TimeTrex Software Inc. Copyright (C) 2003 - 2018 TimeTrex Software Inc.'
NO LUCK:
user@timetrex:~$ su user -c "/usr/share/timetrex/html/maint/cron.php"
Password:
bash: /usr/share/timetrex/html/maint/cron.php: Permission denied
BUT THIS WORKS, sort of:
user@timetrex:~$ sudo php /usr/share/timetrex/html/maint/cron.php
ERROR: Running as 'root' forbidden! To avoid permission conflicts, must run as the web-server user instead.
Example: su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.php"
NOTE: Jobs are scheduled to run at specific times each day, therefore it is normal for only some jobs to be executed each time this file is run.
Jobs Executed: 17 of 17
Is there anyone out there running timetrex on ubuntu 18 with working maint jobs running?
What permission should cron.php be set to?
NO LUCK:
user@timetrex:~$ su www-data -c "/usr/share/timetrex/html/maint/cron.php"
Password:
su: Authentication failure
NO LUCK:
user@timetrex:~$ su root -c "/usr/share/timetrex/html/maint/cron.php"
Password:
/usr/share/timetrex/html/maint/cron.php: line 1: ?php: No such file or directory
/usr/share/timetrex/html/maint/cron.php: line 2: /bin: Is a directory
/usr/share/timetrex/html/maint/cron.php: line 3: Desktop: command not found
/usr/share/timetrex/html/maint/cron.php: line 4: syntax error near unexpected token `('
/usr/share/timetrex/html/maint/cron.php: line 4: ` * TimeTrex Software Inc. Copyright (C) 2003 - 2018 TimeTrex Software Inc.'
NO LUCK:
user@timetrex:~$ su user -c "/usr/share/timetrex/html/maint/cron.php"
Password:
bash: /usr/share/timetrex/html/maint/cron.php: Permission denied
BUT THIS WORKS, sort of:
user@timetrex:~$ sudo php /usr/share/timetrex/html/maint/cron.php
ERROR: Running as 'root' forbidden! To avoid permission conflicts, must run as the web-server user instead.
Example: su www-data -c "/usr/bin/php /usr/share/timetrex/html/maint/cron.php"
NOTE: Jobs are scheduled to run at specific times each day, therefore it is normal for only some jobs to be executed each time this file is run.
Jobs Executed: 17 of 17
Is there anyone out there running timetrex on ubuntu 18 with working maint jobs running?
What permission should cron.php be set to?
Re: Cron job errors
If you remove all lines from your crontab regarding TimeTrex, then in the TimeTrex directory run:
That should automatically add the proper cron command for you.
Code: Select all
./install_cron.sh www-data
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
-
- Posts: 20
- Joined: Mon Jan 23, 2017 10:32 am
Re: Cron job errors
That is what I needed! Seems to be working now.
Thank you.
Thank you.