im having a lot of difficulty getting RC to work in debian jessie and since there isn't a package in the repos ive come here for some much needed help
in summary, what is the correct procedure to get all above talking to each other ?
are there any other dovecot/postfix packages that are pre requisites ?
what needs to be added to:
/etc/dovecot/dovecot-sql.conf.ext ? /etc/dovecot/conf.d/auth-sql.conf.ext ? /etc/dovecot/conf.d/10-auth.conf ?
i have next to no experience with PHP but ive checked the options against /etc/php5/fpm/php.ini
these are missing:
php has the required compiled in modules
regarding nginx, ive not installed it from repos and it has many components disabled but it does support fast cgi, php-fpm, etc, and i can submit php web forms
from the RC installer tests
everything is ok except getting dovecot auth working
after finishing the installer and going to login i can never complete login
browser: "connection to storage server failed"
mail.log dovecot: imap-login: Disconnected (no auth attempts in 0 secs):
no errors logged for nginx or roundcube
shmick@riseup.net wrote:
im having a lot of difficulty getting RC to work in debian jessie and since there isn't a package in the repos ive come here for some much needed help
in summary, what is the correct procedure to get all above talking to each other ?
are there any other dovecot/postfix packages that are pre requisites ?
what needs to be added to:
/etc/dovecot/dovecot-sql.conf.ext ? /etc/dovecot/conf.d/auth-sql.conf.ext ? /etc/dovecot/conf.d/10-auth.conf ?
i have next to no experience with PHP but ive checked the options against /etc/php5/fpm/php.ini
these are missing:
- zend.ze1_compatibility_mode disabled - NA
- suhosin.session.encrypt disabled - NA
- magic_quotes_runtime disabled - NA
- magic_quotes_sybase disabled - NA
php has the required compiled in modules
regarding nginx, ive not installed it from repos and it has many components disabled but it does support fast cgi, php-fpm, etc, and i can submit php web forms
from the RC installer tests
everything is ok except getting dovecot auth working
after finishing the installer and going to login i can never complete login
browser: "connection to storage server failed"
mail.log dovecot: imap-login: Disconnected (no auth attempts in 0 secs):
no errors logged for nginx or roundcube
sql logs
[07-Oct-2014 15:48:32 +1100]: [1] SELECT vars, ip, changed, now() AS ts FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:48:32 +1100]: [2] INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('529elml2apbjqrdqhqjm2bm5g3', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '193.32.74.55', now(), now()); [07-Oct-2014 15:49:44 +1100]: [1] SELECT vars, ip, changed, now() AS ts FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [2] DELETE FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [3] SELECT * FROM users WHERE mail_host = 'localhost' AND username = 'user'; [07-Oct-2014 15:49:45 +1100]: [4] DELETE FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [5] INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('529elml2apbjqrdqhqjm2bm5g3', 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7c2tpbnxzOjU6ImxhcnJ5Ijs=', '193.32.74.55', now(), now());
userlogins
[07-Oct-2014 15:49:45 +1100]: Failed login for user from 193.32.74.55 in session 529elml2apbjqrdqhqjm2bm5g3 (error: -2)
no other logs from php, nginx, mail
surely its the inability to connect to the mysql db
where are the instructions for that ?
advice ?
On 7/10/14 4:00 PM, shmick@riseup.net wrote:
shmick@riseup.net wrote:
im having a lot of difficulty getting RC to work in debian jessie and since there isn't a package in the repos ive come here for some much needed help
in summary, what is the correct procedure to get all above talking to each other ?
are there any other dovecot/postfix packages that are pre requisites ?
what needs to be added to:
/etc/dovecot/dovecot-sql.conf.ext ? /etc/dovecot/conf.d/auth-sql.conf.ext ? /etc/dovecot/conf.d/10-auth.conf ?
i have next to no experience with PHP but ive checked the options against /etc/php5/fpm/php.ini
these are missing:
- zend.ze1_compatibility_mode disabled - NA - suhosin.session.encrypt disabled - NA - magic_quotes_runtime disabled - NA - magic_quotes_sybase disabled - NA
php has the required compiled in modules
regarding nginx, ive not installed it from repos and it has many components disabled but it does support fast cgi, php-fpm, etc, and i can submit php web forms
from the RC installer tests
everything is ok except getting dovecot auth working
after finishing the installer and going to login i can never complete login
browser: "connection to storage server failed"
mail.log dovecot: imap-login: Disconnected (no auth attempts in 0 secs):
no errors logged for nginx or roundcube
sql logs
[07-Oct-2014 15:48:32 +1100]: [1] SELECT vars, ip, changed, now() AS ts FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:48:32 +1100]: [2] INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('529elml2apbjqrdqhqjm2bm5g3', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '193.32.74.55', now(), now()); [07-Oct-2014 15:49:44 +1100]: [1] SELECT vars, ip, changed, now() AS ts FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [2] DELETE FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [3] SELECT * FROM users WHERE mail_host = 'localhost' AND username = 'user'; [07-Oct-2014 15:49:45 +1100]: [4] DELETE FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [5] INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('529elml2apbjqrdqhqjm2bm5g3', 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7c2tpbnxzOjU6ImxhcnJ5Ijs=', '193.32.74.55', now(), now());
userlogins
[07-Oct-2014 15:49:45 +1100]: Failed login for user from 193.32.74.55 in session 529elml2apbjqrdqhqjm2bm5g3 (error: -2)
no other logs from php, nginx, mail
surely its the inability to connect to the mysql db
where are the instructions for that ?
advice ?
Is dovecot working without RoundCube, i.e. can you use an IMAP client to access your mailbox?
Ben.
On Sat, Oct 4, 2014 at 11:06 AM, shmick@riseup.net shmick@riseup.net wrote:
browser: "connection to storage server failed"
Here you have the reason stated ^^.
Please check the 'default_host' setting in your Roundcube config and make sure the connection type (e.g. tls://), hostname and port are set to whatever dovecot is running at.
Best, Thomas
Ben Schmidt wrote:
On 7/10/14 4:00 PM, shmick@riseup.net wrote:
shmick@riseup.net wrote:
im having a lot of difficulty getting RC to work in debian jessie and since there isn't a package in the repos ive come here for some much needed help
in summary, what is the correct procedure to get all above talking to each other ?
are there any other dovecot/postfix packages that are pre requisites ?
what needs to be added to:
/etc/dovecot/dovecot-sql.conf.ext ? /etc/dovecot/conf.d/auth-sql.conf.ext ? /etc/dovecot/conf.d/10-auth.conf ?
i have next to no experience with PHP but ive checked the options against /etc/php5/fpm/php.ini
these are missing:
- zend.ze1_compatibility_mode disabled - NA - suhosin.session.encrypt disabled - NA - magic_quotes_runtime disabled - NA - magic_quotes_sybase disabled - NA
php has the required compiled in modules
regarding nginx, ive not installed it from repos and it has many components disabled but it does support fast cgi, php-fpm, etc, and i can submit php web forms
from the RC installer tests
everything is ok except getting dovecot auth working
after finishing the installer and going to login i can never complete login
browser: "connection to storage server failed"
mail.log dovecot: imap-login: Disconnected (no auth attempts in 0 secs):
no errors logged for nginx or roundcube
sql logs
[07-Oct-2014 15:48:32 +1100]: [1] SELECT vars, ip, changed, now() AS ts FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:48:32 +1100]: [2] INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('529elml2apbjqrdqhqjm2bm5g3', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '193.32.74.55', now(), now()); [07-Oct-2014 15:49:44 +1100]: [1] SELECT vars, ip, changed, now() AS ts FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [2] DELETE FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [3] SELECT * FROM users WHERE mail_host = 'localhost' AND username = 'user'; [07-Oct-2014 15:49:45 +1100]: [4] DELETE FROM session WHERE sess_id = '529elml2apbjqrdqhqjm2bm5g3'; [07-Oct-2014 15:49:45 +1100]: [5] INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('529elml2apbjqrdqhqjm2bm5g3', 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7c2tpbnxzOjU6ImxhcnJ5Ijs=', '193.32.74.55', now(), now());
userlogins
[07-Oct-2014 15:49:45 +1100]: Failed login for user from 193.32.74.55 in session 529elml2apbjqrdqhqjm2bm5g3 (error: -2)
no other logs from php, nginx, mail
surely its the inability to connect to the mysql db
where are the instructions for that ?
advice ?
Is dovecot working without RoundCube, i.e. can you use an IMAP client to access your mailbox?
Ben.
yes, pop3s imaps working fine
Thomas Bruederli wrote:
On Sat, Oct 4, 2014 at 11:06 AM, shmick@riseup.net shmick@riseup.net wrote:
browser: "connection to storage server failed"
Here you have the reason stated ^^.
Please check the 'default_host' setting in your Roundcube config and make sure the connection type (e.g. tls://), hostname and port are set to whatever dovecot is running at.
its exactly the same - localhost strange thing is it doesn't matter if its ssl:// or the local IP, ive tried them all, this is always logged
IMAP connect: NOT OK(Login failed for user from 1.2.3.4. Could not connect to ssl://localhost:993: Unknown reason)
something could be wrong with the installer script
when i go back and enable the installer, update config, and try logging into imap, this:
SMTP send: NOT OK(Invalid sender or recipient)
?
Throwing in my bit of experience here...
So, you can't send emails, but Dovecot is working, right? Then, what is your *Postfix* config? Do you have any smtpd_restrictions enabled? Maybe you need to add localhost or 127.0.0.0/8 to mynetworks?
Matthias
On 10/7/14 9:16 AM, shmick@riseup.net wrote:
Thomas Bruederli wrote:
On Sat, Oct 4, 2014 at 11:06 AM, shmick@riseup.net shmick@riseup.net wrote:
browser: "connection to storage server failed"
Here you have the reason stated ^^.
Please check the 'default_host' setting in your Roundcube config and make sure the connection type (e.g. tls://), hostname and port are set to whatever dovecot is running at.
its exactly the same - localhost strange thing is it doesn't matter if its ssl:// or the local IP, ive tried them all, this is always logged
IMAP connect: NOT OK(Login failed for user from 1.2.3.4. Could not connect to ssl://localhost:993: Unknown reason)
something could be wrong with the installer script
when i go back and enable the installer, update config, and try logging into imap, this:
SMTP send: NOT OK(Invalid sender or recipient)
? _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Matthias Sitte wrote:
Throwing in my bit of experience here...
So, you can't send emails, but Dovecot is working, right? Then, what is your *Postfix* config? Do you have any smtpd_restrictions enabled? Maybe you need to add localhost or 127.0.0.0/8 to mynetworks?
Matthias
my MTA is fine i can send/recv email without any issue RC can send tests so i dont think its an MTA issue
its either a dovecot or mysql db issue
ive reluctantly read some 'howtos' whereby people explicitly state adding sql info to the various dovecot confs
can somebody from RC confirm if this is necessary ?
On 10/7/14 9:16 AM, shmick@riseup.net wrote:
Thomas Bruederli wrote:
On Sat, Oct 4, 2014 at 11:06 AM, shmick@riseup.net shmick@riseup.net wrote:
browser: "connection to storage server failed"
Here you have the reason stated ^^.
Please check the 'default_host' setting in your Roundcube config and make sure the connection type (e.g. tls://), hostname and port are set to whatever dovecot is running at.
its exactly the same - localhost strange thing is it doesn't matter if its ssl:// or the local IP, ive tried them all, this is always logged
IMAP connect: NOT OK(Login failed for user from 1.2.3.4. Could not connect to ssl://localhost:993: Unknown reason)
something could be wrong with the installer script
when i go back and enable the installer, update config, and try logging into imap, this:
SMTP send: NOT OK(Invalid sender or recipient)
? _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Let me try to pinpoint the problem:
to one of the users in the DB, you've checked that the mail actually arrives in the corresponding folder on the HDD, and that the logs are ok?
access to that same user work (with password auth)?
If your answer is 'yes' to all questions, then your mail server is working fine /locally/. If not, of course you'll need to fix this first.
Again, if your answer is 'yes', then you have a working mail server. If not, go back and fix this first.
If you still have problems with RC, then the problem is not your mail server, but your RC config. Enable the debug/log options in your config -- maybe that'll point you in the right direction.
I've run into the same troubles setting up RC, so I understand how frustrating it can be, but I don't think that the RC installer is the culprit ...
Matthias
On 10/7/14 9:37 AM, shmick@riseup.net wrote:
Matthias Sitte wrote:
Throwing in my bit of experience here...
So, you can't send emails, but Dovecot is working, right? Then, what is your *Postfix* config? Do you have any smtpd_restrictions enabled? Maybe you need to add localhost or 127.0.0.0/8 to mynetworks?
Matthias
my MTA is fine i can send/recv email without any issue RC can send tests so i dont think its an MTA issue
its either a dovecot or mysql db issue
ive reluctantly read some 'howtos' whereby people explicitly state adding sql info to the various dovecot confs
can somebody from RC confirm if this is necessary ?
On 10/7/14 9:16 AM, shmick@riseup.net wrote:
Thomas Bruederli wrote:
On Sat, Oct 4, 2014 at 11:06 AM, shmick@riseup.net shmick@riseup.net wrote:
browser: "connection to storage server failed"
Here you have the reason stated ^^.
Please check the 'default_host' setting in your Roundcube config and make sure the connection type (e.g. tls://), hostname and port are set to whatever dovecot is running at.
its exactly the same - localhost strange thing is it doesn't matter if its ssl:// or the local IP, ive tried them all, this is always logged
IMAP connect: NOT OK(Login failed for user from 1.2.3.4. Could not connect to ssl://localhost:993: Unknown reason)
something could be wrong with the installer script
when i go back and enable the installer, update config, and try logging into imap, this:
SMTP send: NOT OK(Invalid sender or recipient)
? _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
hi, thanks buddy,
Matthias Sitte wrote:
Let me try to pinpoint the problem:
- You've installed MySQL, Postfix, Dovecot?
yes
- MySQL is used for virtual users/domains?
no; it never had anything to do with postfix the instructions don't state this as a requirement
- You've set up Postfix and Dovecot to work with the MySQL DB?
no the instructions don't state this as a requirement
- You've sent /locally/ (i.e., on the server) a test using mail or mailx
MTA is fine send/recv imap,submission,pop,smtp
to one of the users in the DB, you've checked that the mail actually arrives in the corresponding folder on the HDD, and that the logs are ok?
- You've checked /locally/ (again, on the server) that POP and IMAP
access to that same user work (with password auth)?
yes
If your answer is 'yes' to all questions, then your mail server is working fine /locally/. If not, of course you'll need to fix this first.
- You set up a test account using, eg, Thunderbird?
- You can access the mail box via POP and IMAP?
- You can send an email via SMTP?
Again, if your answer is 'yes', then you have a working mail server. If not, go back and fix this first.
If you still have problems with RC, then the problem is not your mail server, but your RC config. Enable the debug/log options in your config -- maybe that'll point you in the right direction.
is all this necessary ?
http://www.xenlens.com/debian-wheezy-mail-server-postfix-dovecot-sasl-mysql-...
I've run into the same troubles setting up RC, so I understand how frustrating it can be, but I don't think that the RC installer is the culprit ...
Matthias
On 10/7/14 9:37 AM, shmick@riseup.net wrote:
Matthias Sitte wrote:
Throwing in my bit of experience here...
So, you can't send emails, but Dovecot is working, right? Then, what is your *Postfix* config? Do you have any smtpd_restrictions enabled? Maybe you need to add localhost or 127.0.0.0/8 to mynetworks?
Matthias
my MTA is fine i can send/recv email without any issue RC can send tests so i dont think its an MTA issue
its either a dovecot or mysql db issue
ive reluctantly read some 'howtos' whereby people explicitly state adding sql info to the various dovecot confs
can somebody from RC confirm if this is necessary ?
On 10/7/14 9:16 AM, shmick@riseup.net wrote:
Thomas Bruederli wrote:
On Sat, Oct 4, 2014 at 11:06 AM, shmick@riseup.net shmick@riseup.net wrote:
browser: "connection to storage server failed"
Here you have the reason stated ^^.
Please check the 'default_host' setting in your Roundcube config and make sure the connection type (e.g. tls://), hostname and port are set to whatever dovecot is running at.
its exactly the same - localhost strange thing is it doesn't matter if its ssl:// or the local IP, ive tried them all, this is always logged
IMAP connect: NOT OK(Login failed for user from 1.2.3.4. Could not connect to ssl://localhost:993: Unknown reason)
something could be wrong with the installer script
when i go back and enable the installer, update config, and try logging into imap, this:
SMTP send: NOT OK(Invalid sender or recipient)
? _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
On 10/8/14 9:09 AM, shmick@riseup.net wrote:
hi, thanks buddy,
Matthias Sitte wrote:
Let me try to pinpoint the problem:
- You've installed MySQL, Postfix, Dovecot?
yes
- MySQL is used for virtual users/domains?
no; it never had anything to do with postfix the instructions don't state this as a requirement
- You've set up Postfix and Dovecot to work with the MySQL DB?
no the instructions don't state this as a requirement
- You've sent /locally/ (i.e., on the server) a test using mail or mailx
MTA is fine send/recv imap,submission,pop,smtp
to one of the users in the DB, you've checked that the mail actually arrives in the corresponding folder on the HDD, and that the logs are ok?
- You've checked /locally/ (again, on the server) that POP and IMAP
access to that same user work (with password auth)?
yes
If your answer is 'yes' to all questions, then your mail server is working fine /locally/. If not, of course you'll need to fix this first.
- You set up a test account using, eg, Thunderbird?
- You can access the mail box via POP and IMAP?
- You can send an email via SMTP?
Again, if your answer is 'yes', then you have a working mail server. If not, go back and fix this first.
If you still have problems with RC, then the problem is not your mail server, but your RC config. Enable the debug/log options in your config -- maybe that'll point you in the right direction.
is all this necessary ?
first, you need to identify the problem: is it your mail server, your web server, or RC?
you want to make sure that your mail server is properly working, so you should check/test all the components. you can run your own tests if you like, the above are mere suggestions. usually it's not the web server, either. so please enable all the debug/log options in RC and scan through the logs what's happening...
http://www.xenlens.com/debian-wheezy-mail-server-postfix-dovecot-sasl-mysql-...
did you follow this tutorial, or is it something you found on the internet? 'cause it /does/ use virtual domains/users stored in a MySQL database, and you just said that you /don't/ use MySQL for that...
not quite sure I understand your mail server setup right now ...
Matthias Sitte wrote:
On 10/8/14 9:09 AM, shmick@riseup.net wrote:
hi, thanks buddy,
Matthias Sitte wrote:
Let me try to pinpoint the problem:
- You've installed MySQL, Postfix, Dovecot?
yes
- MySQL is used for virtual users/domains?
no; it never had anything to do with postfix the instructions don't state this as a requirement
- You've set up Postfix and Dovecot to work with the MySQL DB?
no the instructions don't state this as a requirement
- You've sent /locally/ (i.e., on the server) a test using mail or mailx
MTA is fine send/recv imap,submission,pop,smtp
to one of the users in the DB, you've checked that the mail actually arrives in the corresponding folder on the HDD, and that the logs are ok?
- You've checked /locally/ (again, on the server) that POP and IMAP
access to that same user work (with password auth)?
yes
If your answer is 'yes' to all questions, then your mail server is working fine /locally/. If not, of course you'll need to fix this first.
- You set up a test account using, eg, Thunderbird?
- You can access the mail box via POP and IMAP?
- You can send an email via SMTP?
Again, if your answer is 'yes', then you have a working mail server. If not, go back and fix this first.
If you still have problems with RC, then the problem is not your mail server, but your RC config. Enable the debug/log options in your config -- maybe that'll point you in the right direction.
is all this necessary ?
first, you need to identify the problem: is it your mail server, your web server, or RC?
you want to make sure that your mail server is properly working, so you should check/test all the components. you can run your own tests if you like, the above are mere suggestions. usually it's not the web server, either. so please enable all the debug/log options in RC and scan through the logs what's happening...
http://www.xenlens.com/debian-wheezy-mail-server-postfix-dovecot-sasl-mysql-...
did you follow this tutorial, or is it something you found on the internet? 'cause it /does/ use virtual domains/users stored in a MySQL database, and you just said that you /don't/ use MySQL for that...
not quite sure I understand your mail server setup right now ...
my MTA is fine email doesn't have to be in an sql db - mine isnt its just text files before i subscribed to this list and in my original post ive always enabled degug logs for all nothing is logged appart from what i wrote ive examined all logs and thats why im confused now how to proceed if i cant ill start again
my MTA is fine email doesn't have to be in an sql db - mine isnt its just text files before i subscribed to this list and in my original post ive always enabled degug logs for all nothing is logged appart from what i wrote ive examined all logs and thats why im confused now how to proceed if i cant ill start again
you've enabled all debug/log options in RC's "logging/debugging" section and nothing shows up? i mean, you are logging for example SQL queries, don't you?
just copy the section from your config/defaults.inc.php to config/config.inc.php and enable the options.
maybe this is worth a look: https://workaround.org/ispmail/wheezy/webmail-roundcube
without further, however, I am out of ideas...