Backup à 0 octet
Backup à 0 octet
W10
installation en local avec bitnami
Version 7300 du 2020-04-08
Paramètre base de données
Hôte = 127.0.0.1
Port = 5432
Utilisateur = bn_noalyss
client_encoding = UTF8
lc_collate = French_France.1252
listen_addresses = 127.0.0.1
server_encoding = UTF8
work_mem = 4096
shared_buffers = 16384
server_version = 11.7
hba_file =
config_file =
data_directory =
effective_cache_size = 524288
Bonjour
Effectuant une sauvegarde de dossier pour transférer sur un autre ordi, la fichier .bin est vide...
Le dossier fait 17,25MB
installation en local avec bitnami
Version 7300 du 2020-04-08
Paramètre base de données
Hôte = 127.0.0.1
Port = 5432
Utilisateur = bn_noalyss
client_encoding = UTF8
lc_collate = French_France.1252
listen_addresses = 127.0.0.1
server_encoding = UTF8
work_mem = 4096
shared_buffers = 16384
server_version = 11.7
hba_file =
config_file =
data_directory =
effective_cache_size = 524288
Bonjour
Effectuant une sauvegarde de dossier pour transférer sur un autre ordi, la fichier .bin est vide...
Le dossier fait 17,25MB
Re: Backup à 0 octet
UN petit Up, je suis coincé...
Re: Backup à 0 octet
Aucun soucis, pour voir le problème il suffit de regarder dans les logs apache ou postgresql, sinon on peut le faire à la main sans passer par l'interface
Ou grâce à pg_admin3 ou dbeaver.org
Bonne soirée
D
Code : Tout sélectionner
pg_dump -Fc -Z9 --no-owner nom_base_donne > backup.bin
Bonne soirée
D
Re: Backup à 0 octet
je vois pas où est l'erreur...
127.0.0.1 - - [17/Apr/2020:09:39:27 +0200] "GET /noalyss/index.php HTTP/1.1" 200 940
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/index.css HTTP/1.1" 200 1184
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/js/scripts.js HTTP/1.1" 200 21558
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/image/logo7300.png HTTP/1.1" 200 33648
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/image/bg-submit2.gif HTTP/1.1" 200 1213
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/favicon.ico HTTP/1.1" 200 3902
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/image/bg-submit3.gif HTTP/1.1" 200 982
127.0.0.1 - - [17/Apr/2020:09:39:29 +0200] "POST /noalyss/login.php HTTP/1.1" 200 95
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/user_login.php?v=1587109171.047 HTTP/1.1" 200 4147
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/lang/calendar-en.js HTTP/1.1" 200 1596
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/style-print.css?version=7300 HTTP/1.1" 200 963
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/style-classic7.css?version=7300 HTTP/1.1" 200 9734
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/smoke.js?version=7300 HTTP/1.1" 200 2380
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/calendar-blue.css HTTP/1.1" 200 1416
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/infobulle.js HTTP/1.1" 200 932
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/scripts.js?version=7300 HTTP/1.1" 200 21558
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/calendar-setup.js HTTP/1.1" 200 2902
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/calendar.js HTTP/1.1" 200 13357
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/anc_script.js?version=7300 HTTP/1.1" 200 4535
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/acc_ledger.js?version=7300 HTTP/1.1" 200 8622
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/ajax_fiche.js?version=7300 HTTP/1.1" 200 2642
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/accounting_item.js?version=7300 HTTP/1.1" 200 2210
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/scriptaculous.js?version=7300 HTTP/1.1" 200 1498
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/calc.js?version=7300 HTTP/1.1" 200 1110
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/compute_direct.js?version=7300 HTTP/1.1" 200 1126
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/compute.js?version=7300 HTTP/1.1" 200 1082
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/forecast.js?version=7300 HTTP/1.1" 200 517
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/card.js?version=7300 HTTP/1.1" 200 6493
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/gestion.js?version=7300 HTTP/1.1" 200 2805
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/todo_list.js?version=7300 HTTP/1.1" 200 2709
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/image/OpenSansRegular.woff HTTP/1.1" 200 67532
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/managetable.js?version=7300 HTTP/1.1" 200 3244
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/nicEdit.js?version=7300 HTTP/1.1" 200 9837
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/sorttable.js?version=7300 HTTP/1.1" 200 5856
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/prototype.js?version=7300 HTTP/1.1" 200 46025
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/sound.js HTTP/1.1" 200 974
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/builder.js HTTP/1.1" 200 1840
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/slider.js HTTP/1.1" 200 2677
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/dragdrop.js HTTP/1.1" 200 7564
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/controls.js HTTP/1.1" 200 9057
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/effects.js HTTP/1.1" 200 8726
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/image/fontello/fontello.woff?18582275 HTTP/1.1" 200 20020
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/image/SansationLight/SansationLight.woff HTTP/1.1" 200 14344
127.0.0.1 - - [17/Apr/2020:09:39:33 +0200] "GET /noalyss/do.php?gDossier=25 HTTP/1.1" 200 7464
127.0.0.1 - - [17/Apr/2020:09:39:34 +0200] "GET /noalyss/image/down.gif HTTP/1.1" 200 74
127.0.0.1 - - [17/Apr/2020:09:39:37 +0200] "GET /noalyss/user_login.php?v=1587109171.047 HTTP/1.1" 200 4147
127.0.0.1 - - [17/Apr/2020:09:39:40 +0200] "GET /noalyss/admin-noalyss.php HTTP/1.1" 200 3814
127.0.0.1 - - [17/Apr/2020:09:39:40 +0200] "GET /noalyss/js/admin.js?version=7300 HTTP/1.1" 200 1905
127.0.0.1 - - [17/Apr/2020:09:39:45 +0200] "GET /noalyss/admin-noalyss.php?action=dossier_mgt HTTP/1.1" 200 5121
127.0.0.1 - - [17/Apr/2020:09:39:50 +0200] "GET /noalyss/admin-noalyss.php?action=backup&sa=b&t=d&d=25 HTTP/1.1" 200 -
Compliqué de demander à mon comptable de faire une manip sous pg_admin4
127.0.0.1 - - [17/Apr/2020:09:39:27 +0200] "GET /noalyss/index.php HTTP/1.1" 200 940
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/index.css HTTP/1.1" 200 1184
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/js/scripts.js HTTP/1.1" 200 21558
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/image/logo7300.png HTTP/1.1" 200 33648
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/image/bg-submit2.gif HTTP/1.1" 200 1213
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/favicon.ico HTTP/1.1" 200 3902
127.0.0.1 - - [17/Apr/2020:09:39:28 +0200] "GET /noalyss/image/bg-submit3.gif HTTP/1.1" 200 982
127.0.0.1 - - [17/Apr/2020:09:39:29 +0200] "POST /noalyss/login.php HTTP/1.1" 200 95
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/user_login.php?v=1587109171.047 HTTP/1.1" 200 4147
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/lang/calendar-en.js HTTP/1.1" 200 1596
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/style-print.css?version=7300 HTTP/1.1" 200 963
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/style-classic7.css?version=7300 HTTP/1.1" 200 9734
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/smoke.js?version=7300 HTTP/1.1" 200 2380
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/calendar-blue.css HTTP/1.1" 200 1416
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/infobulle.js HTTP/1.1" 200 932
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/scripts.js?version=7300 HTTP/1.1" 200 21558
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/calendar-setup.js HTTP/1.1" 200 2902
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/calendar.js HTTP/1.1" 200 13357
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/anc_script.js?version=7300 HTTP/1.1" 200 4535
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/acc_ledger.js?version=7300 HTTP/1.1" 200 8622
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/ajax_fiche.js?version=7300 HTTP/1.1" 200 2642
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/accounting_item.js?version=7300 HTTP/1.1" 200 2210
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/scriptaculous.js?version=7300 HTTP/1.1" 200 1498
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/calc.js?version=7300 HTTP/1.1" 200 1110
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/compute_direct.js?version=7300 HTTP/1.1" 200 1126
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/compute.js?version=7300 HTTP/1.1" 200 1082
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/forecast.js?version=7300 HTTP/1.1" 200 517
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/card.js?version=7300 HTTP/1.1" 200 6493
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/gestion.js?version=7300 HTTP/1.1" 200 2805
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/todo_list.js?version=7300 HTTP/1.1" 200 2709
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/image/OpenSansRegular.woff HTTP/1.1" 200 67532
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/managetable.js?version=7300 HTTP/1.1" 200 3244
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/nicEdit.js?version=7300 HTTP/1.1" 200 9837
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/sorttable.js?version=7300 HTTP/1.1" 200 5856
127.0.0.1 - - [17/Apr/2020:09:39:31 +0200] "GET /noalyss/js/prototype.js?version=7300 HTTP/1.1" 200 46025
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/sound.js HTTP/1.1" 200 974
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/builder.js HTTP/1.1" 200 1840
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/slider.js HTTP/1.1" 200 2677
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/dragdrop.js HTTP/1.1" 200 7564
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/controls.js HTTP/1.1" 200 9057
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/js/effects.js HTTP/1.1" 200 8726
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/image/fontello/fontello.woff?18582275 HTTP/1.1" 200 20020
127.0.0.1 - - [17/Apr/2020:09:39:32 +0200] "GET /noalyss/image/SansationLight/SansationLight.woff HTTP/1.1" 200 14344
127.0.0.1 - - [17/Apr/2020:09:39:33 +0200] "GET /noalyss/do.php?gDossier=25 HTTP/1.1" 200 7464
127.0.0.1 - - [17/Apr/2020:09:39:34 +0200] "GET /noalyss/image/down.gif HTTP/1.1" 200 74
127.0.0.1 - - [17/Apr/2020:09:39:37 +0200] "GET /noalyss/user_login.php?v=1587109171.047 HTTP/1.1" 200 4147
127.0.0.1 - - [17/Apr/2020:09:39:40 +0200] "GET /noalyss/admin-noalyss.php HTTP/1.1" 200 3814
127.0.0.1 - - [17/Apr/2020:09:39:40 +0200] "GET /noalyss/js/admin.js?version=7300 HTTP/1.1" 200 1905
127.0.0.1 - - [17/Apr/2020:09:39:45 +0200] "GET /noalyss/admin-noalyss.php?action=dossier_mgt HTTP/1.1" 200 5121
127.0.0.1 - - [17/Apr/2020:09:39:50 +0200] "GET /noalyss/admin-noalyss.php?action=backup&sa=b&t=d&d=25 HTTP/1.1" 200 -
Compliqué de demander à mon comptable de faire une manip sous pg_admin4
Re: Backup à 0 octet
C'est le fichier access.log , il me faudrait l'autre : error.log et celui de postgresql aussi (avec la bonne date). Sinon tu te mets en mode debug et on voit où cela coince
Re: Backup à 0 octet
pour restaurer le backup on peut le faire par l'interface si le fichier ne dépasse pas les limites de ta config, en général 2MB
Re: Backup à 0 octet
Voila donc l error log de Apache
C,'est pb de droit je pense mais je ne sais pas le résoudre
Ensuite, j'ai essayé depuis pgAdmin-4 et je joins le fichier, bien vide aussi mais sans erreur...
C,'est pb de droit je pense mais je ne sais pas le résoudre
Ensuite, j'ai essayé depuis pgAdmin-4 et je joins le fichier, bien vide aussi mais sans erreur...
- Fichiers joints
-
- noalyss_sql.rtf
- (628 Octets) Téléchargé 149 fois
-
- errorlog.rtf
- (280.18 Kio) Téléchargé 160 fois
Re: Backup à 0 octet
Et un autre tout moche...
- Fichiers joints
-
- noalyss.sql.rtf
- (409 Kio) Téléchargé 152 fois
Re: Backup à 0 octet
Le fichier noalyss.sql.rtf de 409k est un fichier valide de backup, le problème que tu as est que tu travailles sous windows. Toujours une plaie les windows, à mon avis le problème se situe dans le fichier noalyss/include/config.inc.php , il n'arrive pas exécuter la commande pg_dump pour avoir le fichier bin.
Code : Tout sélectionner
C:\\Bitnami\\noalyss-7.2.0.0-2\\apps\\noalyss\\htdocs\\include\\backup.inc.php on line 97, referer: http://127.0.0.1:81/noalyss/admin-noalyss.php?action=modele_mgt
'C:\Bitnami' n'est pas reconnu en tant que commande interne
ou externe, un programme excutable ou un fichier de commandes.
Re: Backup à 0 octet
Oui Windaube je sais...
Je vais voir si je epux trouver une soluce comme tu le préconise dans le fichier config.inc
Merci
Je vais voir si je epux trouver une soluce comme tu le préconise dans le fichier config.inc
Merci