Help you back up your site data to Google Drive Get authorization Set up Google Drive Storage when setting up a backup plan task

Hi @aaPanel_Jose I get this when I click on the settings link When I click Check Google Drive I get this error message: Sorry, something went wrong： Traceback (most recent call last): File "class/panelPlugin.py", line 1560, in a plugin_main = __import__(get.name+'_main'); File "/usr/local/lib/python2.7/dist-packages/gevent/builtins.py", line 96, in __import__ result = _import(*args, **kwargs) File "plugin/gdrive/gdrive_main.py", line 18, in from google_auth_oauthlib.flow import InstalledAppFlow File "/usr/local/lib/python2.7/dist-packages/gevent/builtins.py", line 96, in __import__ result = _import(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/google_auth_oauthlib/__init__.py", line 21, in from .interactive import get_user_credentials File "/usr/local/lib/python2.7/dist-packages/gevent/builtins.py", line 96, in __import__ result = _import(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/google_auth_oauthlib/interactive.py", line 24, in import google_auth_oauthlib.flow File "/usr/local/lib/python2.7/dist-packages/gevent/builtins.py", line 96, in __import__ result = _import(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/google_auth_oauthlib/flow.py", line 67, in import google.auth.transport.requests File "/usr/local/lib/python2.7/dist-packages/gevent/builtins.py", line 96, in __import__ result = _import(*args, **kwargs) ImportError: No module named google.auth.transport.requests if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); }

Hello bro! Please resolve this issue

@laxadev and @kamranhanif496 Please try to add google auth manually via PIP. pip install --upgrade google-auth

kamranhanif496 please update your gdrive plugin @laxadev please try with madc0de

Thanks Guys! the issue is now resolved

kamranhanif496 Friends again issue started after update

kamranhanif496 please try to restart your panel

@aaPanel_Jose I have the same problem as @kamranhanif496 I tried to restart the panel but it doesn't help.

aaPanel_Jose Thanks bro Now my issue is resolved after restart

kamranhanif496 Hello dear! i start the backup but it not transfer my backup to google drive

Google Drive Backup Tools released on 06 Aug 2019

jazz1611

aaPanel_Kern
hello,
i just reinstall the plugin and no show error in while installing. but where can i find the install log of plugin? also i remove the cronjob and add new cronjob with same setting. it still doesn't delete the oldest backups.

aaPanel_Kern

jazz1611
The oldest data will not be deleted, which is also for data security.
log：cat /tmp/panelShell.pl

jazz1611

aaPanel_Kern
hello,
so keep last 6 copies is nonsense in this case. this mean you need add optional have to remove oldest backup or not.

there is log install of plugin

selecting download node...
Collecting pyOpenSSL
  Downloading pyOpenSSL-22.0.0-py2.py3-none-any.whl (55 kB)
Collecting cryptography>=35.0
  Downloading cryptography-37.0.4-cp36-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.2 MB)
Collecting cffi>=1.12
  Downloading cffi-1.15.1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (427 kB)
Collecting pycparser
  Using cached pycparser-2.21-py2.py3-none-any.whl (118 kB)
Installing collected packages: pycparser, cffi, cryptography, pyOpenSSL
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
aliyun-python-sdk-core 2.13.30 requires cryptography<3.3,>=2.9.2, but you have cryptography 37.0.4 which is incompatible.
Successfully installed cffi-1.15.1 cryptography-37.0.4 pyOpenSSL-22.0.0 pycparser-2.21
WARNING: You are using pip version 20.3.3; however, version 22.1.2 is available.
You should consider upgrading via the '/www/server/panel/pyenv/bin/python3.7 -m pip install --upgrade pip' command.
WARNING: You are using pip version 20.3.3; however, version 22.1.2 is available.
You should consider upgrading via the '/www/server/panel/pyenv/bin/python3.7 -m pip install --upgrade pip' command.
WARNING: You are using pip version 20.3.3; however, version 22.1.2 is available.
You should consider upgrading via the '/www/server/panel/pyenv/bin/python3.7 -m pip install --upgrade pip' command.
Found existing installation: google-auth-httplib2 0.0.4
Uninstalling google-auth-httplib2-0.0.4:
  Successfully uninstalled google-auth-httplib2-0.0.4
Looking in indexes: https://pypi.Python.org/simple
Collecting google-auth-httplib2==0.0.3
  Using cached google_auth_httplib2-0.0.3-py2.py3-none-any.whl (6.3 kB)
Collecting httplib2>=0.9.1
  Downloading httplib2-0.20.4-py3-none-any.whl (96 kB)
Collecting pyparsing!=3.0.0,!=3.0.1,!=3.0.2,!=3.0.3,<4,>=2.4.2
  Downloading pyparsing-3.0.9-py3-none-any.whl (98 kB)
Collecting google-auth
  Downloading google_auth-2.9.0-py2.py3-none-any.whl (167 kB)
Collecting cachetools<6.0,>=2.0.0
  Downloading cachetools-5.2.0-py3-none-any.whl (9.3 kB)
Collecting pyasn1-modules>=0.2.1
  Using cached pyasn1_modules-0.2.8-py2.py3-none-any.whl (155 kB)
Collecting pyasn1<0.5.0,>=0.4.6
  Using cached pyasn1-0.4.8-py2.py3-none-any.whl (77 kB)
Collecting rsa<5,>=3.1.4
  Downloading rsa-4.8-py3-none-any.whl (39 kB)
Collecting six>=1.9.0
  Using cached six-1.16.0-py2.py3-none-any.whl (11 kB)
Installing collected packages: pyasn1, six, rsa, pyparsing, pyasn1-modules, cachetools, httplib2, google-auth, google-auth-httplib2
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
google-cloud-storage 1.35.0 requires google-auth<2.0dev,>=1.11.0, but you have google-auth 2.9.0 which is incompatible.
google-api-core 1.24.1 requires google-auth<2.0dev,>=1.21.1, but you have google-auth 2.9.0 which is incompatible.
Successfully installed cachetools-5.2.0 google-auth-2.9.0 google-auth-httplib2-0.0.3 httplib2-0.20.4 pyasn1-0.4.8 pyasn1-modules-0.2.8 pyparsing-3.0.9 rsa-4.8 six-1.16.0
WARNING: You are using pip version 20.3.3; however, version 22.1.2 is available.
You should consider upgrading via the '/www/server/panel/pyenv/bin/python3.7 -m pip install --upgrade pip' command.
WARNING: You are using pip version 20.3.3; however, version 22.1.2 is available.
You should consider upgrading via the '/www/server/panel/pyenv/bin/python3.7 -m pip install --upgrade pip' command.
WARNING: You are using pip version 20.3.3; however, version 22.1.2 is available.
You should consider upgrading via the '/www/server/panel/pyenv/bin/python3.7 -m pip install --upgrade pip' command.
Found existing installation: httplib2 0.20.4
Uninstalling httplib2-0.20.4:
  Successfully uninstalled httplib2-0.20.4
Looking in indexes: https://pypi.Python.org/simple
Collecting httplib2==0.15.0
  Using cached httplib2-0.15.0-py3-none-any.whl (94 kB)
Installing collected packages: httplib2
Successfully installed httplib2-0.18.1
WARNING: You are using pip version 20.3.3; however, version 22.1.2 is available.
You should consider upgrading via the '/www/server/panel/pyenv/bin/python3.7 -m pip install --upgrade pip' command.
{"product": "Linux panel", "setup_path": "/www/server", "openlitespeed_path": "/usr/local", "language": "English", "title": "aaPanel Linux panel", "brand": "aaPanel", "root_path": "/www", "template": "default", "logs_path": "/www/wwwlogs", "home": "https://www.aapanel.com", "recycle_bin": true}
--2022-07-11 17:09:42--  https://node.aapanel.com/install/plugin/gdrive_en/gdrive_main.py
Resolving node.aapanel.com (node.aapanel.com)... 2606:4700:3031::6815:4fc4, 2606:4700:3034::ac43:ab07, 104.21.79.196, ...
Connecting to node.aapanel.com (node.aapanel.com)|2606:4700:3031::6815:4fc4|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 27414 (27K) [application/octet-stream]
Saving to: ‘/www/server/panel/script/backup_gdrive.py’

     0K .......... .......... ......                          100% 86.8M=0s

2022-07-11 17:09:42 (86.8 MB/s) - ‘/www/server/panel/script/backup_gdrive.py’ saved [27414/27414]

--2022-07-11 17:09:42--  https://node.aapanel.com/install/plugin/gdrive_en/index.html
Resolving node.aapanel.com (node.aapanel.com)... 2606:4700:3031::6815:4fc4, 2606:4700:3034::ac43:ab07, 172.67.171.7, ...
Connecting to node.aapanel.com (node.aapanel.com)|2606:4700:3031::6815:4fc4|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: ‘/www/server/panel/plugin/gdrive/index.html’

     0K .......... .                                           89.0M=0s

2022-07-11 17:09:43 (89.0 MB/s) - ‘/www/server/panel/plugin/gdrive/index.html’ saved [12048]

--2022-07-11 17:09:43--  https://node.aapanel.com/install/plugin/gdrive_en/info.json
Resolving node.aapanel.com (node.aapanel.com)... 2606:4700:3031::6815:4fc4, 2606:4700:3034::ac43:ab07, 104.21.79.196, ...
Connecting to node.aapanel.com (node.aapanel.com)|2606:4700:3031::6815:4fc4|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 339 [application/json]
Saving to: ‘/www/server/panel/plugin/gdrive/info.json’

     0K                                                       100%  151M=0s

2022-07-11 17:09:44 (151 MB/s) - ‘/www/server/panel/plugin/gdrive/info.json’ saved [339/339]

--2022-07-11 17:09:44--  https://node.aapanel.com/install/plugin/gdrive_en/icon.png
Resolving node.aapanel.com (node.aapanel.com)... 2606:4700:3034::ac43:ab07, 2606:4700:3031::6815:4fc4, 104.21.79.196, ...
Connecting to node.aapanel.com (node.aapanel.com)|2606:4700:3034::ac43:ab07|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3967 (3.9K) [image/png]
Saving to: ‘/www/server/panel/plugin/gdrive/icon.png’

     0K ...                                                   100% 63.9M=0s

2022-07-11 17:09:44 (63.9 MB/s) - ‘/www/server/panel/plugin/gdrive/icon.png’ saved [3967/3967]

--2022-07-11 17:09:44--  https://node.aapanel.com/install/plugin/gdrive/credentials.json
Resolving node.aapanel.com (node.aapanel.com)... 2606:4700:3031::6815:4fc4, 2606:4700:3034::ac43:ab07, 172.67.171.7, ...
Connecting to node.aapanel.com (node.aapanel.com)|2606:4700:3031::6815:4fc4|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 419 [application/json]
Saving to: ‘/www/server/panel/plugin/gdrive/credentials.json’

     0K                                                       100%  212M=0s

2022-07-11 17:09:45 (212 MB/s) - ‘/www/server/panel/plugin/gdrive/credentials.json’ saved [419/419]

ln: failed to create symbolic link ‘/root/credentials.json’: File exists

aaPanel_Kern

jazz1611
You can manually delete the ones that have not been deleted successfully before. On the right side, you can see the record that the file was deleted

jazz1611

aaPanel_Kern
are you misunderstood about "keep latest 6 copies"? it mean only keep latest of 6 backup and delete of remain the oldest backup (this feature is other panels are working like this). so if i set keep last 0 copies then no keep backup or don't remove old backup?

aaPanel_Kern

jazz1611
This is for data security, only one copy of the old data is deleted. Panel settings keep at least one copy of the data.

jazz1611

aaPanel_Kern
what we need is to keep the backups according to the settings and delete all the oldest backups. if not we have to manually delete it, you need to change the way the plugin works
it works just as you say when keep backing up locally, which remote backup no need keep oldest the backup. or you can ask other member about this case.

aaPanel_Kern

jazz1611
thanks for your suggestion. This method of deleting only one copy of data is for the safety of your data. The data deleted remotely by cron cannot be recovered, and the recovery cannot be seen on the "Trash" interface.
It was not deleted before because of a program failure. You can delete the data that has not been deleted before, and it will be deleted normally when you re-execute the task next time.

jazz1611

aaPanel_Kern
hello, the plugin have bug, in cron job say it deleted but in gdrive it still not deleted. no any error in crontab log. please fix this bug soon.

aaPanel_Kern

jazz1611
This may be a network problem. You can see that the deletion was successful at 2:35 and 3:35.

jazz1611

aaPanel_Kern
then why it not remove remains of oldest backup? if network problem need have error log. please fix instead just guess it. i'm making the plugin more complete instead of you ignoring it

aaPanel_Kern

jazz1611
So what do you think is the problem that prevents it from being deleted?
Why not delete the oldest part I already told you: delete only one piece of data, not all old data is for data security

jazz1611

@aaPanel_Kern
hello, today we got same error in per request backup

|-Start backup[2023-01-06 22:30:28]
==========================================================================================
|-Backup database:webm_xxxxxx
|-Database size: 544.00 KB
|-Database character set: utf8
|-Partition / available disk space is: 181.83 GB, available Inode is: 14292211
|-Start exporting database: 2023-01-06 22:30:28
|-Compression completed, took 0.27 seconds, compressed package size: 7.39 KB
|-Uploading to Google Drive, please wait ...
==========================================================================================
|-Error：File upload error: ('invalid_grant: Bad Request', {'error': 'invalid_grant', 'error_description': 'Bad Request'})

aaPanel_Kern

jazz1611
Hello, is the problem solved? I checked my vps and there is no such problem,
Try to execute the command to view the connection:curl -v https://www.googleapis.com/auth/drive.file

aaP_Chan

Hai, can I replace My GDrive authorization for new GDrive?

Thank's

aaPanel_Kern

Hello, it cannot be replaced. Need to reinstall and set up

aaP_Chan

bfrank

So this only works for MySQL databases still, right? Any plans for Postgres backup support to GDrive! This would be great.

aaPanel_Kern

Hello, thank you for your feedback, it has been recorded

« Previous Page