Команда для крона
20,50 * * * * bash /var/www/y-car.ru/files/sBash.sh >/dev/null 2>&1
Bash скрипт сам
#!/bin/bash -x
export LANG=ru_RU.UTF-8
wget -P /var/www/y-car.ru/files
ftp://sb_user:syst213@auctionsdata.aleado.com/jp/oneprice/auct_lots_xml_jp_full.sql.bz2bunzip2 /var/www/y-car.ru/files/auct_lots_xml_jp_full.sql.bz2
mysql -D YCar -u SosedMarket -p111111 -e "DROP TABLE auct_lots_xml_jp_full"
mysql -u SosedMarket -p111111 YCar < auct_lots_xml_jp_full.sql
rm /var/www/y-car.ru/files/auct_lots_xml_jp_full.sql
mysql -u SosedMarket -p111111 YCar < auct_lots_xml_jp_full.sql - Конкретно не работает это строчка походу, потому что всё остальное происходит а вот таблица не добавляется.... Что делать не знаю...
Крон запускаю
sudo crontab -e
От имени рута... Уж не знаю что делать то. Помогите плиз.
Пользователь добавил сообщение 05 Сентября 2016, 04:34:33:
сделал греб крона
sosed@SosedMarket:~$ grep CRON /var/log/syslog
Sep 5 06:39:01 SosedMarket CRON[28516]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 06:39:05 SosedMarket CRON[28515]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 06:50:01 SosedMarket CRON[28574]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 06:51:16 SosedMarket CRON[28573]: (root) MAIL (mailed 60230 bytes of output but got status 0x0001 from MTA#012)
Sep 5 07:09:01 SosedMarket CRON[28586]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 07:09:05 SosedMarket CRON[28585]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 07:17:01 SosedMarket CRON[28643]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Sep 5 07:20:01 SosedMarket CRON[28647]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 07:21:17 SosedMarket CRON[28646]: (root) MAIL (mailed 60156 bytes of output but got status 0x0001 from MTA#012)
Sep 5 07:39:01 SosedMarket CRON[28657]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 07:39:04 SosedMarket CRON[28656]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 07:50:01 SosedMarket CRON[28715]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 07:51:19 SosedMarket CRON[28714]: (root) MAIL (mailed 60458 bytes of output but got status 0x0001 from MTA#012)
Sep 5 08:09:01 SosedMarket CRON[28729]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 08:09:05 SosedMarket CRON[28728]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 08:17:01 SosedMarket CRON[28795]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Sep 5 08:20:01 SosedMarket CRON[28802]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 08:20:57 SosedMarket CRON[28801]: (root) MAIL (mailed 41747 bytes of output but got status 0x0001 from MTA#012)
Sep 5 08:39:01 SosedMarket CRON[28830]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 08:39:05 SosedMarket CRON[28829]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 08:50:01 SosedMarket CRON[28887]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 08:50:57 SosedMarket CRON[28886]: (root) MAIL (mailed 41978 bytes of output but got status 0x0001 from MTA#012)
Sep 5 09:09:01 SosedMarket CRON[28904]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 09:09:07 SosedMarket CRON[28903]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 09:17:01 SosedMarket CRON[28998]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Sep 5 09:20:01 SosedMarket CRON[29001]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 09:20:58 SosedMarket CRON[29000]: (root) MAIL (mailed 42515 bytes of output but got status 0x0001 from MTA#012)
Sep 5 09:39:01 SosedMarket CRON[29023]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 09:39:05 SosedMarket CRON[29022]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 09:50:01 SosedMarket CRON[29083]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 09:50:58 SosedMarket CRON[29082]: (root) MAIL (mailed 43748 bytes of output but got status 0x0001 from MTA#012)
Sep 5 10:09:01 SosedMarket CRON[29102]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 10:09:05 SosedMarket CRON[29101]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 10:17:01 SosedMarket CRON[29357]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Sep 5 10:20:01 SosedMarket CRON[29509]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 10:20:59 SosedMarket CRON[29508]: (root) MAIL (mailed 43901 bytes of output but got status 0x0001 from MTA#012)
Sep 5 10:39:01 SosedMarket CRON[29652]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 10:39:04 SosedMarket CRON[29651]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 10:50:01 SosedMarket CRON[29722]: (root) CMD (/var/www/y-car.ru/files/sBash.sh)
Sep 5 10:51:00 SosedMarket CRON[29721]: (root) MAIL (mailed 44671 bytes of output but got status 0x0001 from MTA#012)
Sep 5 11:09:01 SosedMarket CRON[29903]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
Sep 5 11:09:05 SosedMarket CRON[29902]: (root) MAIL (mailed 210 bytes of output but got status 0x0001 from MTA#012)
Sep 5 11:16:26 SosedMarket cron[2432]: (CRON) INFO (pidfile fd = 3)
Sep 5 11:16:26 SosedMarket cron[2432]: (CRON) INFO (Running @reboot jobs)
Sep 5 11:17:01 SosedMarket CRON[2690]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Sep 5 11:20:01 SosedMarket CRON[2836]: (root) CMD (bash /var/www/y-car.ru/files/sBash.sh >/dev/null 2>&1 )
______________________
1.4. Листинги и содержимое текстовых файлов следует добавлять в сообщение с помощью тегов [spoiler]...[/spoiler] или [code]...[/code], либо прикреплять к сообщению в виде отдельного файла.
~Punko
ТС не появлялся на Форуме более полугода по состоянию на 14/07/2019 (последняя явка: 05/09/2016). Модератором раздела принято решение закрыть тему.
--zg_nico