kompazz / gmail2mysql

Saves mails into mysql db
0 stars 0 forks source link

Script working but displaying error during execution #1

Open fttdgc opened 2 years ago

fttdgc commented 2 years ago

I installed the script and it's capturing the emails from gmail and bringing them to the db but it's also throwing up this error when I run it.

Traceback (most recent call last): File "gmail_to_mysql.py", line 200, in <module> main() File "gmail_to_mysql.py", line 189, in main box = gmail_login(settings, mailbox_name) File "gmail_to_mysql.py", line 19, in gmail_login imapper = e.connect(host, user, password, mailbox, ssl=True, read_only=True) File "/usr/local/lib/python3.8/site-packages/easyimap/easyimap.py", line 207, in connect return Imapper(host, user, password, mailbox, timeout, ssl, port, **kwargs) File "/usr/local/lib/python3.8/site-packages/easyimap/easyimap.py", line 145, in __init__ self._mailer = self._get_mailer(host, user, password, mailbox, timeout, ssl, port) File "/usr/local/lib/python3.8/site-packages/easyimap/easyimap.py", line 159, in _get_mailer raise Exception("Timeout.") Exception: Timeout.

kompazz commented 2 years ago

what's the console output preceding the exception?

fttdgc commented 2 years ago

To confirm, whenever there's a new message, it's still collecting and inserting it to the mysql database, it's just generating the error along with it.

`python3.8 gmail_to_mysql.py

Zalogowano do gmail Zalogowano do mysql Przetwarzam skrzynkę inbox. Maili do importu: 0 Traceback (most recent call last): File "gmail_to_mysql.py", line 200, in main() File "gmail_to_mysql.py", line 189, in main box = gmail_login(settings, mailbox_name) File "gmail_to_mysql.py", line 19, in gmail_login imapper = e.connect(host, user, password, mailbox, ssl=True, read_only=True) File "/usr/local/lib/python3.8/site-packages/easyimap/easyimap.py", line 207, in connect return Imapper(host, user, password, mailbox, timeout, ssl, port, **kwargs) File "/usr/local/lib/python3.8/site-packages/easyimap/easyimap.py", line 145, in init self._mailer = self._get_mailer(host, user, password, mailbox, timeout, ssl, port) File "/usr/local/lib/python3.8/site-packages/easyimap/easyimap.py", line 159, in _get_mail er raise Exception("Timeout.") Exception: Timeout. `

kompazz commented 2 years ago

So this relates to the outbox. The problem with this is outbox name varies depending on the language. Currently it supports Polish outbox name. Can you provide your gmail language and the outbox name for your language?

fttdgc commented 2 years ago

English. The emails go to the Sent folder.

kompazz commented 2 years ago

Just added language to configuration file. Please verify if it works for you.

fttdgc commented 2 years ago

It looks like even though 'Sent' is the display on English accounts, 'Sent Mail' is the IMAP folder name

https://developers.google.com/gmail/imap/imap-extensions

With that in mind making the change to 'Sent Mail,' the python error is gone, though, upon completion it gives a gmail login error at the end.

Zalogowano do gmail Zalogowano do mysql Przetwarzam skrzynkę inbox. Maili do importu: 0 Błędne dane logowania gmail

kompazz commented 2 years ago

Corrected the EN outbox name in settings.ini. Please check now