setting up roundcube

  • (2 Pages)
  • +
  • 1
  • 2

22 Replies - 586 Views - Last Post: 14 May 2020 - 09:16 AM

#1 Bobby_Bubbles   User is offline

  • D.I.C Regular

Reputation: 1
  • View blog
  • Posts: 381
  • Joined: 13-March 18

setting up roundcube

Posted 12 May 2020 - 05:29 PM

I was following these guides

https://habilisbest....raspberry-pi-as ... ail-server
https://habilisbest....round-cube-web- ... spberry-pi

to try and setup my own mailing server with my domains rather than pay godaddy 200$ a year.

I got all the way to the roundcube login so i slapped my credentials where the site said to do it with this

"INSERT INTO mailserver.virtual_users (id, domain_id, password , email) VALUES (1, 1, ENCRYPT('[SOME_PASSWORD]', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))), '[email protected][YOUR_SITE.com]'), (2, 2, ENCRYPT('[SOME_OTHER_PASSWORD]', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))), '[email protected][YOUR_OTHER_SITE.com]');"

obviously i substituted it with [email protected] along with a super easy password and saved it on my desktop.

i used that and i get connection to storage server failed.

looked up on some possible issues at this link

i already have the dovecot-mysql drivers installed.

https://talk.plesk.c...hreads/webmail- ... ed.338556/

i got no dovecot log in that directory and mail.log isnt saying anything. i did dovecot -F and it shows its running fine with PID.

so i checked status for postfix dovecot and they are running.

i checked into the permission and the mail folder on my mail server is set to www:data for user. no group. and set it to 750 recursive subdirectories

i checked for db connectiions and verified it that the user and pass is right and the database is indeed there.

checked conf.d in dovecot for 15-mailboxs and added inbox = yes under namspace inbox

i deleted the config files and let dovecot rebuild them and nothing.

What am i missing?

these are the error logs.

May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x10, ret=1: before SSL initialization
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: before SSL initialization
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2002, ret=-1: before SSL initialization
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: before SSL initialization
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS read client hello
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS write server hello
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS write certificate
May 12 15:30:23 raspberrypi dovecot: auth: Debug: Loading modules from directory: /usr/lib/dovecot/modules/auth
May 12 15:30:23 raspberrypi dovecot: auth: Debug: Module loaded: /usr/lib/dovecot/modules/auth/lib20_auth_var_expand_crypt.so
May 12 15:30:23 raspberrypi dovecot: auth: Debug: Module loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
May 12 15:30:23 raspberrypi dovecot: auth: Debug: Read auth token secret from /var/run/dovecot/auth-token-secret.dat
May 12 15:30:23 raspberrypi dovecot: auth: Debug: auth client connected (pid=6033)
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS write key exchange
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS write server done
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2002, ret=-1: SSLv3/TLS write server done
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2002, ret=-1: SSLv3/TLS write server done
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2002, ret=-1: SSLv3/TLS write server done
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2002, ret=-1: SSLv3/TLS write server done
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS write server done
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS read client key exchange
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS read change cipher spec
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS read finished
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS write session ticket
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS write change cipher spec
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2001, ret=1: SSLv3/TLS write finished
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x20, ret=1: SSL negotiation finished successfully
May 12 15:30:23 raspberrypi dovecot: imap-login: Debug: SSL: where=0x2002, ret=1: SSL negotiation finished successfully
May 12 15:30:23 raspberrypi dovecot: auth: Debug: client in: AUTH#0111#011PLAIN#011service=imap#011secured=tls#011session=6VLSTXSl4qTAqAEB#011lip=192.168.1.223#011rip=192.168.1.1#011lport=993#011rport=42210#011local_name=mail.coinpays.ca#011ssl_cipher=ECDHE-RSA-AES128-GCM-SHA256#011ssl_cipher_bits=128#011ssl_pfs=KxECDHE#011ssl_protocol=TLSv1.2#011resp=AHNhbGVzQGNvaW5wYXlzLmNhAHNhbGVzcGFzcw== (previous base64 data may contain sensitive data)
May 12 15:30:23 raspberrypi dovecot: auth-worker(6035): Debug: Loading modules from directory: /usr/lib/dovecot/modules/auth
May 12 15:30:23 raspberrypi dovecot: auth-worker(6035): Debug: Module loaded: /usr/lib/dovecot/modules/auth/lib20_auth_var_expand_crypt.so
May 12 15:30:23 raspberrypi dovecot: auth-worker(6035): Debug: Module loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
May 12 15:30:23 raspberrypi dovecot: auth-worker(6035): Debug: sql([email protected],192.168.1.1,<6VLSTXSl4qTAqAEB>): query: SELECT email as user, password FROM virtual_users WHERE email='[email protected]';
May 12 15:30:24 raspberrypi dovecot: auth: Debug: client passdb out: OK#0111#[email protected]#011
May 12 15:30:24 raspberrypi dovecot: auth: Debug: master in: REQUEST#0114196925441#0116033#0111#011543d339843b96f6d28947add44cd5d9c#011session_pid=6036#011request_auth_token
May 12 15:30:24 raspberrypi dovecot: auth: Debug: master userdb out: USER#0114196925441#[email protected]#011uid=5000#011gid=5000#011home=/var/email/vhosts/coinpays.ca/sales#011auth_token=6a66b73dbce899fbe5c305210b819ac4dde36087
May 12 15:30:24 raspberrypi dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=192.168.1.1, lip=192.168.1.223, mpid=6036, TLS, session=<6VLSTXSl4qTAqAEB>
May 12 15:30:24 raspberrypi dovecot: imap([email protected])<6036><6VLSTXSl4qTAqAEB>: Debug: Effective uid=5000, gid=5000, home=/var/email/vhosts/coinpays.ca/sales
May 12 15:30:24 raspberrypi dovecot: imap([email protected])<6036><6VLSTXSl4qTAqAEB>: Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=mbox:~/mail:INBOX=/var/mail/[email protected]
May 12 15:30:24 raspberrypi dovecot: imap([email protected])<6036><6VLSTXSl4qTAqAEB>: Debug: fs: root=/var/email/vhosts/coinpays.ca/sales/mail, index=, indexpvt=, control=, inbox=/var/mail/[email protected], alt=
May 12 15:30:24 raspberrypi dovecot: imap([email protected])<6036><6VLSTXSl4qTAqAEB>: Logged out in=44 out=546 deleted=0 expunged=0 trashed=0 hdr_count=0 hdr_bytes=0 body_count=0 body_bytes=0
May 12 15:30:24 raspberrypi dovecot: imap-login: Debug: SSL alert: close notify
May 12 15:31:53 raspberrypi systemd[1]: Started Session c4 of user root.



doing this on a rpi 4.

Is This A Good Question/Topic? 0
  • +

Replies To: setting up roundcube

#2 ArtificialSoldier   User is offline

  • D.I.C Lover
  • member icon

Reputation: 2732
  • View blog
  • Posts: 8,011
  • Joined: 15-January 14

Re: setting up roundcube

Posted 12 May 2020 - 06:19 PM

I don't see anything in that log which shows any issues, it looks like the database things are working and it looks like the mailbox is checked and then the user is logged out.
Was This Post Helpful? 0
  • +
  • -

#3 Bobby_Bubbles   User is offline

  • D.I.C Regular

Reputation: 1
  • View blog
  • Posts: 381
  • Joined: 13-March 18

Re: setting up roundcube

Posted 13 May 2020 - 04:15 AM

thats the thing....these errors arent telling me anything. but when i login and try to send an email i get smtp error.

is there other logs that may be useful for this?

check this image out its what i mean. Also when i send emails to the sales address in the screenie i never get it also.

https://ibb.co/gmstNZB

This post has been edited by Bobby_Bubbles: 13 May 2020 - 04:16 AM

Was This Post Helpful? 0
  • +
  • -

#4 no2pencil   User is offline

  • Professor Snuggly Pants
  • member icon

Reputation: 6865
  • View blog
  • Posts: 31,644
  • Joined: 10-May 07

Re: setting up roundcube

Posted 13 May 2020 - 06:15 AM

What is the SMTP error that you are receiving?
Was This Post Helpful? 0
  • +
  • -

#5 Bobby_Bubbles   User is offline

  • D.I.C Regular

Reputation: 1
  • View blog
  • Posts: 381
  • Joined: 13-March 18

Re: setting up roundcube

Posted 13 May 2020 - 07:19 AM

connection to server failed.

i got a screenshot in th link i postd just above.
Was This Post Helpful? 0
  • +
  • -

#6 no2pencil   User is offline

  • Professor Snuggly Pants
  • member icon

Reputation: 6865
  • View blog
  • Posts: 31,644
  • Joined: 10-May 07

Re: setting up roundcube

Posted 13 May 2020 - 10:05 AM

The screenshot is a form. I don't see an error message. Do you have the ports open at the firewall? Can you telnet to it from localhost, & walk through the process of sending the email manually?
Was This Post Helpful? 0
  • +
  • -

#7 Bobby_Bubbles   User is offline

  • D.I.C Regular

Reputation: 1
  • View blog
  • Posts: 381
  • Joined: 13-March 18

Re: setting up roundcube

Posted 13 May 2020 - 10:27 AM

the screenshot is roundcube attempting to send an email

i didnt see any errors bing reported by syslog but is thre other logs i could check?

also i forwarded all ports and nmappeed my public wan nd saw it was all open.

can you walk me through th telnt process from start to finish im still new to setting up this and unsure what is needed.
Was This Post Helpful? 0
  • +
  • -

#8 no2pencil   User is offline

  • Professor Snuggly Pants
  • member icon

Reputation: 6865
  • View blog
  • Posts: 31,644
  • Joined: 10-May 07

Re: setting up roundcube

Posted 13 May 2020 - 10:39 AM

I only found this site with a quick "How to send email with Telnet" Google Search, & verified that it references return codes. So I'm not married to it. Also, note that it references ports 25/110. If you are using SSL/TLS, you will likely need to build a username/password with base64. It's been a while since I tested with this process, but it's really straight forward.
Was This Post Helpful? 0
  • +
  • -

#9 Bobby_Bubbles   User is offline

  • D.I.C Regular

Reputation: 1
  • View blog
  • Posts: 381
  • Joined: 13-March 18

Re: setting up roundcube

Posted 13 May 2020 - 11:18 AM

hmmm odd..wasnt mentioned in some of th articles i read.

i checked it out but when i trid to telnet to my domain it said connection refused.

Completely new to this area.
Was This Post Helpful? 0
  • +
  • -

#10 ArtificialSoldier   User is offline

  • D.I.C Lover
  • member icon

Reputation: 2732
  • View blog
  • Posts: 8,011
  • Joined: 15-January 14

Re: setting up roundcube

Posted 13 May 2020 - 12:53 PM

Either something isn't listening on the right port, or a firewall is blocking it, or port forwarding isn't working.
Was This Post Helpful? 0
  • +
  • -

#11 Bobby_Bubbles   User is offline

  • D.I.C Regular

Reputation: 1
  • View blog
  • Posts: 381
  • Joined: 13-March 18

Re: setting up roundcube

Posted 13 May 2020 - 01:20 PM

nmap 24.55.215.103

see what you can find.

and is there any logs i can check to help figure out the issue?
Was This Post Helpful? 0
  • +
  • -

#12 no2pencil   User is offline

  • Professor Snuggly Pants
  • member icon

Reputation: 6865
  • View blog
  • Posts: 31,644
  • Joined: 10-May 07

Re: setting up roundcube

Posted 13 May 2020 - 02:02 PM

View PostBobby_Bubbles, on 13 May 2020 - 03:20 PM, said:

nmap 24.55.215.103

see what you can find.

If you can't connect with localhost, looking at the external IP will be a waste of time.
Was This Post Helpful? 0
  • +
  • -

#13 ArtificialSoldier   User is offline

  • D.I.C Lover
  • member icon

Reputation: 2732
  • View blog
  • Posts: 8,011
  • Joined: 15-January 14

Re: setting up roundcube

Posted 13 May 2020 - 02:19 PM

If you can access the internet from your server, you can use a tool like this:

https://www.grc.com/shieldsup
Was This Post Helpful? 0
  • +
  • -

#14 Bobby_Bubbles   User is offline

  • D.I.C Regular

Reputation: 1
  • View blog
  • Posts: 381
  • Joined: 13-March 18

Re: setting up roundcube

Posted 13 May 2020 - 03:02 PM

it shows all ports are being forwarded. i could never get telnet to work rgardless where i am.

i ran nmap -p 25-993 portquiz.net > /var/dump and got this output

PORT    STATE    SERVICE
25/tcp  open     smtp
135/tcp filtered msrpc
136/tcp filtered profile
137/tcp filtered netbios-ns
138/tcp filtered netbios-dgm
139/tcp filtered netbios-ssn
443/tcp open     https
445/tcp filtered microsoft-ds
993/tcp open     imaps
995/tcp open     pop3s

Nmap done: 1 IP address (1 host up) scanned in 7.82 seconds



View PostArtificialSoldier, on 13 May 2020 - 02:19 PM, said:

If you can access the internet from your server, you can use a tool like this:

https://www.grc.com/shieldsup


ran it, got a no rsponse in green i presume thats positive?
Was This Post Helpful? 0
  • +
  • -

#15 ArtificialSoldier   User is offline

  • D.I.C Lover
  • member icon

Reputation: 2732
  • View blog
  • Posts: 8,011
  • Joined: 15-January 14

Re: setting up roundcube

Posted 13 May 2020 - 06:06 PM

That means it's not open to the outside internet. No response means it's acting like there's not even a server there. That's a tool for testing network security, so green is good when your network acts like there's not even a server there.
Was This Post Helpful? 0
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2