From 685dadceeed094a24c08a814b45bb7ef17c6e623 Mon Sep 17 00:00:00 2001
From: Devops <sys@15gifts.com>
Date: Wed, 5 Jul 2017 13:03:54 +0100
Subject: [PATCH] bin/ovh-api

---
 bin/ovh-api | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

diff --git a/bin/ovh-api b/bin/ovh-api
index eb8bc995..a3e64e9f 100755
--- a/bin/ovh-api
+++ b/bin/ovh-api
@@ -166,7 +166,8 @@ sub query {
   die "$NAME: Connection failed" unless ref $response eq 'OvhApi::Answer';
 	if ($response->isFailure()) {
 	  die "$NAME: ERR: Connection failed" if $response->error() =~ /Internal Server Error/;
-	  die "$NAME: ERR: ".$response->error()."\n";
+	  warn "$NAME: ERR: ".$response->error()."\n";
+    return;
   }
 
 	my $content = $response->content;
@@ -188,6 +189,7 @@ sub query {
 
     die "$NAME: Query failed" unless ref $response eq 'OvhApi::Answer';
 	  die "$NAME: ERR: Query failed" if $response->error() =~ /Internal Server Error/;
+    next if $response->error() eq 'This Service is expired';
     die "$NAME: ERR: ".$response->error()."\n" if $response->isFailure();
 
 
@@ -295,6 +297,8 @@ my @tbs = (
     my $name =$preff.$tb->{name};
 
     print "\n-- > $name\n";
+    my @query = query($tb->{path});
+    #next unless @query;
 
     print "CREATE TABLE IF NOT EXISTS $name ("
       .join(",",map {"$_->{sql}"} @{$tb->{fields}})
@@ -307,7 +311,7 @@ my @tbs = (
     #
     # Rows 
     #
-    for ((query($tb->{path}))) {
+    for (@query) {
       my %row = %$_;
 
       my @vals;
-- 
2.47.3