Erro na execução de script php pelo cron
1. Erro na execução de script php pelo cron
mauriciosevero
(usa Ubuntu)
Enviado em 03/06/2016 - 18:20h
Boa tarde:Estou com dificuldade para rodar o script php de backup do teampass, já tentei agendar de várias formas o cron ele executa mas não me retorna o arquivo de backup para que eu possa guardar em fita, segue a linha de configuração do cron e o script:
OBS.: quando rodo o script via linha de comando funciona tranquilo
* * * * * /opt/TeamPass-2.1.19/backups/script.backup.php &> /dev/null
___________________________________________________________
#!/usr/bin/env php
<?php
/**
* @file views.queries.php
* @author Nils Laumaillé
* @version 2.1.19
* @copyright (c) 2009-2013 Nils Laumaillé
* @licensing GNU AFFERO GPL 3.0
* @link http://www.teampass.net
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*/
include '../includes/settings.php';
header("Content-type: text/html; charset=utf-8");
// connect to DB
require_once '../sources/SplClassLoader.php';
$db = new SplClassLoader('Database\Core', '../includes/libraries');
$db->register();
$db = new Database\Core\DbCore($server, $user, $pass, $database, $pre);
$db->connect();
//Load AES
$aes = new SplClassLoader('Encryption\Crypt', '../includes/libraries');
$aes->register();
//get backups infos
$rows = $db->fetchAllArray("SELECT * FROM ".$pre."misc WHERE type = 'settings'");
foreach ($rows as $reccord) {
$settings[$reccord['intitule']] = $reccord['valeur'];
}
if (!empty($settings['bck_script_filename']) && !empty($settings['bck_script_path'])) {
//get all of the tables
$tables = array();
$result = mysql_query('SHOW TABLES');
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
$return = "";
//cycle through each table and format the data
foreach ($tables as $table) {
$result = mysql_query('SELECT * FROM '.$table);
$num_fields = mysql_num_fields($result);
$return.= 'DROP TABLE '.$table.';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
$return.= "\n\n".$row2[1].";\n\n";
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysql_fetch_row($result)) {
$return.= 'INSERT INTO '.$table.' VALUES(';
for ($j=0; $j<$num_fields; $j++) {
$row[$j] = addslashes($row[$j]);
$row[$j] = preg_replace('/\n/', '/\\n/', $row[$j]);
if (isset($row[$j])) {
$return.= '"'.$row[$j].'"' ;
} else {
$return.= '""';
}
if ($j<($num_fields-1)) {
$return.= ',';
}
}
$return.= ");\n";
}
}
$return.="\n\n\n";
}
if (!empty($settings['bck_script_key'])) {
$return = Encryption\Crypt\aesctr::encrypt($return, $settings['bck_script_key'], 256);
}
//save the file
$handle = fopen($settings['bck_script_path'].'/'.$settings['bck_script_filename'].'-'.time().'.sql', 'w+');
fwrite($handle, $return);
fclose($handle);
}