Open-Report-Parser
Open-Report-Parser copied to clipboard
Published
20 hours ago •
userjack6880
userjack6880
[Question]: Postgres error when oauth2 is enabled + gmail
Hi,
I'm trying to connect to the imap server using oauth2 but i receive de following message, i'm using postgres 13.11:
Open Report Parser
Version 0 Alpha 5
-------------
Open Report Parser DEBUG ENABLED
-- Script Options --
Report Source: 0
(0: IMAP, 1: Message, 2: XML, 3: MBOX, 4: ZIP, 5: JSON)
Show Processed: 0
Delete Reports: 0
Delete Failed: 0
Replace Reports: 0
DMARC Only: 1
(0: DMARC\TLS, 1: DMARC Only, -1: TLS Only)
-- Database Options --
DB Type: postgres
DB Name: dmarc
DB User: dmarc
DB Host/Port: localhost:5432
DB TX Support: 1
Max XML Size: 50000
Max JSON Size: 50000
Compress XML: 0
Compress JSON: 0
-- IMAP Options --
IMAP Server: imap.gmail.com
IMAP Port: 993
TLS: 0
SSL: 1
TLS Verify: 0
IMAP User: [email protected]
IMAP Ignore Err: 0
IMAP Auth: oauth2
Oauth2 URI: https://accounts.google.com/o/oauth2/v2/auth
OAuth2 Client ID: xxxxxxx
DMARC Folders:
Reports: inbox
TLS Folders:
Reports: tls
----
--- DEBUG ---
using ssl without verify servercert.
-------------
--- DEBUG ---
connection to imap.gmail.com with Ssl => 1, User => [email protected], Ignoresizeerrors => 0
-------------
Started at Wed Mar 13 14:49:35 2024
Using Mail::IMAPClient version 3.43 on perl 5.026003
Connecting with IO::Socket::SSL PeerAddr imap.gmail.com PeerPort 993 Proto tcp Timeout 600 Debug 1 SSL_verify_mode 0
Connected to imap.gmail.com
Read: * OK Gimap ready for requests from xxx.xxx.xxx.xxx xxxxxxxxxx
--- DEBUG ---
using oauth2
-------------
DBD::Pg::st execute failed: ERROR: relation "oauth" does not exist
LINE 1: ...ken, UNIX_TIMESTAMP(expire) AS expire, valid FROM oauth WHER...
^ at lib/OAuth.pm line 63.
DBD::Pg::st fetchrow_hashref failed: no statement executing at lib/OAuth.pm line 64.
no token found, requesting
Wide character in subroutine entry at lib/OAuth.pm line 172.
Any suggestion?
