Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I see this error on my crontab:

Dec  8 09:51:01 ikeyprod cron[29245]: Error: bad username; while reading /etc/crontab

I have verified that these commands can all be pushed manually via sudo.

-rw-r--r--   1 root     root     2.2K 2010-12-08 09:50 crontab

These commands aren't being run and I'm not sure why... I am seeing the above error though...

    # /etc/crontab: system-wide crontab
    # Unlike any other crontab you don't have to run the `crontab'
    # command to install the new version when you edit this file
    # and files in /etc/cron.d. These files also have username fields,
    # that none of the other crontabs do.

    SHELL=/bin/sh
    PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
    MAILTO="web@domain.com"

    # m h dom mon dow user  command
    17 *    * * *   root    cd / && run-parts --report /etc/cron.hourly
    25 6    * * *   root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
    47 6    * * 7   root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
    52 6    1 * *   root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )

    # ----- IKEY -----
    5  0    * * *   root    bash /sites/domain.com/scripts/backup.sh
    0  3    * * *   root    php /sites/domain.com/www/cron/clear-expired-carts.php
    0  1    * * 7   root    php /sites/domain.com/www/cron/generate-vehicle-sitemap.php
    3  3    * * *   root    php /sites/domain.com/www/cron/account/update-dealer-map.php

    # ----- IKEY INTERNAL -----
    15 1    * * 1-5 root    php /sites/internal.domain.com/www/cron/account/clock/accountability-report.php
    0  6    * * 1   root    php /sites/internal.domain.com/www/cron/account/clock/tardy-report.php
    0 22    * * *   root    php /sites/internal.domain.com/www/cron/account/clock/clock-out.php

    # > Orders
    #*  *    * * *   root    php /sites/internal.domain.com/www/cron/order/generate-invoice-pdf.php

# > eBay
30 1    * * *   root    php /sites/internal.domain.com/www/cron/ebay/get-feedback.php
*  *    * * *   root    php /sites/internal.domain.com/www/cron/ebay/archive/get-listing-data.php
10 *    * * *   root    php /sites/internal.domain.com/www/cron/ebay/archive/associate-product-with-listing.php
20 *    * * *   root    php /sites/internal.domain.com/www/cron/ebay/archive/update-listing-status.php

# > Fleetkeys
*  6    * * 2   root    php /sites/internal.domain.com/www/cron/fleetkeys/invoice/get-unpaid-invoices.php

# > Maintenance
0 3    * * 0 mysqlcheck -Aao –auto-repair -u root -p PASSWORD > /dev/null
share|improve this question

2 Answers 2

up vote 8 down vote accepted

Your crontab needs a username for the last line (mysqlcheck).

And: you might want to change that MySQL root password now.

share|improve this answer
    
Doh! Good call on the password... changed –  Webnet Dec 8 '10 at 15:14

The issue is the last line

0 3    * * 0 mysqlcheck -Aao –auto-repair -u root -p password > /dev/null

You are missing the username

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.