autom. Perl Backup geht nicht

**knows MySQLDumper** Joined: 15 May 2006 Posts: 6

So,
nachdem mir "DSB" gestern schon super geholfen hatte, hab ich jetzt aber doch noch ein problem.
Der Cron wir nicht ausgeführt bzw sendet keine E-Mail obwohl ich denke das ich alles richtig gemacht habe.

Hier ein paar Angaben:

Perl-Cronscript ausführen --> ok
Perl-Module testen -->ok
Perl testen --> ok
Backup PHP --> ok

Crondump-Einstellungen für das Perlscript

Dateiendung des Scripts: .cgi
Konfigurationsdatei: vorhanden: mysqldumper
Pfad der Perlskripte: /cgi-bin/
Textausgabe: ja
Komplette Ausgabe loggen: jan
Aktuelle Datenbank benutzen: ja
Datenbank und Tabellen-Präfix
für den Cronjob:
GZip-Kompression: aktiviert
E-Mail senden: ja
Backup anhängen: ja
Backup per FTP senden: nein

E-Mail Einstellungen:

E-Mail senden: ja
E-Mail-Adresse: xxx@xx.de
Absender der E-Mail:
Backup anhängen: ja
maximale Größe des Anhangs: 3MB
Mailprogramm:
sendmail usr/lib/sendmail

Angaben im Crontab auf Server:

Minute Stunde Tag im Monat Monat Wochentag Befehl
45 21 * * * perl /cgi-bin/crondump.pl config=mysqldumper.conf
45 8 * * * perl /cgi-bin/crondump.pl config=mysqldumper.conf

Was stimmt nicht oder fehlt?
Danke!

Posted: 2006-05-16, 09:40 (No subject)

Hast Du das Verschicken der Email auch unter "Cronscript" eingeschaltet oder nur im PHP-Teil?

Außerdem legt der Dumper eine Logdatei an udn protokolliert alle Aktionen.
Steht da denn etwas vom Versenden der Email oder eine Fehlermeldung?

**knows MySQLDumper** Joined: 15 May 2006 Posts: 6

e-Mail send ist auch im Cronscript aktiv!

unter Error Log wird gar nichts angezeigt.

unter perl log wird angezeigt(habe Button perl Cronscript ausführen gedrückt):
16.05.2006 08:18:34 : Executing Command after dump
16.05.2006 08:18:34 : Mail was sent to frank_winter@online.de.
16.05.2006 08:18:34 : Perl Cron-Dump `usr_web250_1_2006_05_16_08_18_crondump_perl.sql.gz` finished.
16.05.2006 08:18:33 : Start Perl Cron-Dump with file `usr_web250_1_2006_05_16_08_18_crondump_perl.sql.gz`
16.05.2006 08:18:32 : Executing Command before dump
16.05.2006 08:18:32 : starting perl crondump 1.21
15.05.2006 21:23:57 : Executing Command after dump
15.05.2006 21:23:57 : Mail was sent to frank_winter@online.de.
15.05.2006 21:23:57 : Perl Cron-Dump `usr_web250_1_2006_05_15_21_23_crondump_perl.sql.gz` finished.
15.05.2006 21:23:57 : Start Perl Cron-Dump with file `usr_web250_1_2006_05_15_21_23_crondump_perl.sql.gz`
15.05.2006 21:23:57 : Executing Command before dump
15.05.2006 21:23:57 : starting perl crondump 1.21

unter perl complete-log steht:
closing script 16.05.2006 08:18, byetotal time used: 2 sec.
#EOS
Crondump finished.
Mail was sent to frank_winter@online.de.
sending mail ...
Backup of Database `usr_web250_1` complete.
.
239 inserted records (backupfile now 156824 Bytes)
. * . dumping table `zones_to_geo_zones`
847 inserted records (backupfile now 154910 Bytes)
. * . dumping table `zones`
8 inserted records (backupfile now 143788 Bytes)
. * . dumping table `whos_online`
4 inserted records (backupfile now 142911 Bytes)
. * . dumping table `tax_rates`
2 inserted records (backupfile now 142325 Bytes)
. * . dumping table `tax_class`
34 inserted records (backupfile now 141796 Bytes)
. * . dumping table `specials`
7 inserted records (backupfile now 140717 Bytes)
. * . dumping table `shipping_status`
12 inserted records (backupfile now 140221 Bytes)
. * . dumping table `sessions`
0 inserted records (backupfile now 138642 Bytes)
. * . dumping table `reviews_description`
0 inserted records (backupfile now 138314 Bytes)
. * . dumping table `reviews`
9 inserted records (backupfile now 137934 Bytes)
. * . dumping table `products_xsell_grp_name`
53 inserted records (backupfile now 137405 Bytes)
. * . dumping table `products_xsell`
0 inserted records (backupfile now 136551 Bytes)
. * . dumping table `products_vpe`
301 inserted records (backupfile now 136244 Bytes)
. * . dumping table `products_to_categories`
21 inserted records (backupfile now 134946 Bytes)
. * . dumping table `products_options_values_to_products_options`
21 inserted records (backupfile now 134406 Bytes)
. * . dumping table `products_options_values`
4 inserted records (backupfile now 133822 Bytes)
. * . dumping table `products_options`
0 inserted records (backupfile now 133366 Bytes)
. * . dumping table `products_notifications`
58 inserted records (backupfile now 133020 Bytes)
. * . dumping table `products_images`
0 inserted records (backupfile now 132098 Bytes)
. * . dumping table `products_graduated_prices`
246 inserted records (backupfile now 131756 Bytes)
. . . * . dumping table `products_description`
0 inserted records (backupfile now 109271 Bytes)
. * . dumping table `products_content`
0 inserted records (backupfile now 108877 Bytes)
. * . dumping table `products_attributes_download`
162 inserted records (backupfile now 108515 Bytes)
. * . dumping table `products_attributes`
246 inserted records (backupfile now 106341 Bytes)
. . . * . dumping table `products`
391 inserted records (backupfile now 97480 Bytes)
. * . dumping table `personal_offers_by_customers_status_6`
465 inserted records (backupfile now 94804 Bytes)
. * . dumping table `personal_offers_by_customers_status_5`
465 inserted records (backupfile now 91925 Bytes)
. * . dumping table `personal_offers_by_customers_status_4`
481 inserted records (backupfile now 89047 Bytes)
. * . dumping table `personal_offers_by_customers_status_3`
481 inserted records (backupfile now 85915 Bytes)
. * . dumping table `personal_offers_by_customers_status_2`
481 inserted records (backupfile now 82777 Bytes)
. * . dumping table `personal_offers_by_customers_status_1`
0 inserted records (backupfile now 79639 Bytes)
. * . dumping table `personal_offers_by_customers_status_0`
0 inserted records (backupfile now 79254 Bytes)
. * . dumping table `payment_qenta`
27 inserted records (backupfile now 78880 Bytes)
. * . dumping table `payment_moneybookers_currencies`
197 inserted records (backupfile now 78146 Bytes)
. * . dumping table `payment_moneybookers_countries`
0 inserted records (backupfile now 76564 Bytes)
. * . dumping table `payment_moneybookers`
37 inserted records (backupfile now 76161 Bytes)
. * . dumping table `orders_total`
51 inserted records (backupfile now 74912 Bytes)
. * . dumping table `orders_status_history`
3 inserted records (backupfile now 73280 Bytes)
. * . dumping table `orders_status`
0 inserted records (backupfile now 72837 Bytes)
. * . dumping table `orders_recalculate`
0 inserted records (backupfile now 72461 Bytes)
. * . dumping table `orders_products_download`
0 inserted records (backupfile now 72084 Bytes)
. * . dumping table `orders_products_attributes`
25 inserted records (backupfile now 71679 Bytes)
. * . dumping table `orders_products`
9 inserted records (backupfile now 70248 Bytes)
. * . dumping table `orders`
0 inserted records (backupfile now 67507 Bytes)
. * . dumping table `newsletters_history`
0 inserted records (backupfile now 67180 Bytes)
. * . dumping table `newsletters`
7 inserted records (backupfile now 66788 Bytes)
. * . dumping table `newsletter_recipients`
1 inserted records (backupfile now 65838 Bytes)
. * . dumping table `module_newsletter_temp_2`
4 inserted records (backupfile now 65226 Bytes)
. * . dumping table `module_newsletter_temp_1`
0 inserted records (backupfile now 64560 Bytes)
. * . dumping table `module_newsletter`
0 inserted records (backupfile now 64201 Bytes)
. * . dumping table `media_content`
11 inserted records (backupfile now 63876 Bytes)
. * . dumping table `manufacturers_info`
11 inserted records (backupfile now 63305 Bytes)
. * . dumping table `manufacturers`
1 inserted records (backupfile now 62611 Bytes)
. * . dumping table `languages`
3 inserted records (backupfile now 62087 Bytes)
. * . dumping table `geo_zones`
1 inserted records (backupfile now 61548 Bytes)
. * . dumping table `database_version`
9 inserted records (backupfile now 61225 Bytes)
. * . dumping table `customers_status_history`
7 inserted records (backupfile now 60598 Bytes)
. * . dumping table `customers_status`
0 inserted records (backupfile now 59646 Bytes)
. * . dumping table `customers_memo`
827 inserted records (backupfile now 59296 Bytes)
. . . * . dumping table `customers_ip`
14 inserted records (backupfile now 46227 Bytes)
. * . dumping table `customers_info`
2 inserted records (backupfile now 45374 Bytes)
. * . dumping table `customers_basket_attributes`
8 inserted records (backupfile now 44903 Bytes)
. * . dumping table `customers_basket`
14 inserted records (backupfile now 44307 Bytes)
. * . dumping table `customers`
1 inserted records (backupfile now 42155 Bytes)
. * . dumping table `currencies`
0 inserted records (backupfile now 41585 Bytes)
. * . dumping table `coupons_description`
11 inserted records (backupfile now 41249 Bytes)
. * . dumping table `coupons`
7 inserted records (backupfile now 40277 Bytes)
. * . dumping table `coupon_redeem_track`
0 inserted records (backupfile now 39662 Bytes)
. * . dumping table `coupon_gv_queue`
5 inserted records (backupfile now 39237 Bytes)
. * . dumping table `coupon_gv_customer`
11 inserted records (backupfile now 38825 Bytes)
. * . dumping table `coupon_email_track`
239 inserted records (backupfile now 38039 Bytes)
. * . dumping table `countries`
0 inserted records (backupfile now 33727 Bytes)
. * . dumping table `counter_history`
0 inserted records (backupfile now 33438 Bytes)
. * . dumping table `counter`
15 inserted records (backupfile now 33163 Bytes)
. * . dumping table `content_manager`
21 inserted records (backupfile now 24612 Bytes)
. * . dumping table `configuration_group`
325 inserted records (backupfile now 23632 Bytes)
. . * . dumping table `configuration`
2 inserted records (backupfile now 15287 Bytes)
. * . dumping table `cm_file_flags`
34 inserted records (backupfile now 14904 Bytes)
. * . dumping table `categories_description`
34 inserted records (backupfile now 11021 Bytes)
. * . dumping table `categories`
0 inserted records (backupfile now 9587 Bytes)
. * . dumping table `card_blacklist`
0 inserted records (backupfile now 9238 Bytes)
. * . dumping table `cao_log`
112 inserted records (backupfile now 8869 Bytes)
. * . dumping table `campaigns_ip`
4 inserted records (backupfile now 7425 Bytes)
. * . dumping table `campaigns`
60 inserted records (backupfile now 6839 Bytes)
. * . dumping table `banners_history`
1 inserted records (backupfile now 5582 Bytes)
. * . dumping table `banners`
0 inserted records (backupfile now 4774 Bytes)
. * . dumping table `banktransfer`
2 inserted records (backupfile now 4411 Bytes)
. * . dumping table `admin_access`
5 inserted records (backupfile now 3165 Bytes)
. * . dumping table `address_format`
14 inserted records (backupfile now 2652 Bytes)
. * . dumping table `address_book` .
Start Perl Cron-Dump with file `usr_web250_1_2006_05_16_08_18_crondump_perl.sql.gz`
found 90 tables with 7210 records.

90 tables were optimized
Backup Parameter: complete inserts

ok
MySQL-Version 4.1.10a-Max
start Backup 16.05.2006 08:18
connect to database`usr_web250_1` no file to delete.
Autodelete by Count (3) => found 3 Backups
Autodelete: search for more backups than 3 ... ok, logging on
Starting Crondump ... Mail Library loaded ...
FTP Library loaded ...
Compression Library loaded ...
Config 'mysqldumper.conf' was loaded.

im ordner mysqldump/work/backups wurde keine autom. backup datei angelegt
Also keine Fehlermeldung, aber auch nichts von e-mail versandt

Posted: 2006-05-16, 11:52 (No subject)

**knows MySQLDumper** Joined: 15 May 2006 Posts: 6

Vielen dank!
Werd das mal prüfen

macht weiter so!
clap

**knows MySQLDumper** Joined: 15 May 2006 Posts: 6

Posted: 2006-05-19, 11:36 (No subject)