Re: [RCU] RC with Davical and calendar plugins from git.faster-it.com - any success?

2017-10-11 Thread Ivars Strazdiņš 
Hi,
yes, in the end I’ve got it working with a couple of notes.
First, Calendar plugin works for me with Apache only. It did not work properly 
with Nginx. Note that Roundcube does not support Nginx anyway, but it was 
working. We’re running Roundcube on Nginx for quite some time. Not with 
Calendar plugin though. You have to switch to Apache.
Another thing is that I had to modify source to get it working as stated before.
But I tried to diff again freshly checked out source and there are massive 
changes in 
https://gitlab.awesome-it.de/kolab/roundcube-plugins/tree/feature_caldav 

So this all seem to be a moving target. The version I have is definitely not 
the version you have.
It’s interesting why they commit broken stuff that doesn’t work out of box, but 
it’s their code and their playground.
Sorry that I can’t help you more on this.

Kind regards,
Ivars

> On 11 Oct 2017, at 22:00, Computerisms Corporation  
> wrote:
> 
> Hi Ivars,
> 
> I am wondering if you had any success with this in the end?  I have been 
> playing with this plug in for a day or so now and also not having any luck.  
> I haven't found a problem with expand_user function, but I worked around 
> insert_default_calendar by commenting the call to the function, since I want 
> only caldav anyway.  I have been working my way through several patches in 
> the kolab repository, and every time I do I get new problems and errors, but 
> I don't know if that is fixing it or making it worse.
> 
> I have a copy of the myroundcube calendar/calendar_plus plugin, which I also 
> tried to get working, but it seems to rely on the plugin system they were 
> using, and I am not sufficiently skilled in programming to decipher its 
> hiccup, and I don't want to try and transfer their whole plugin system to a 
> new server.  The license on the software doesn't seem to prohibit me from 
> changing the code, but it does prevent me from distributing it, so a dead end 
> road anyway...
> 
> I had really hoped the roundcube_next project would solve this caldav issue, 
> but can no longer afford to wait on this...
> 
> On 2017-06-01 06:16 AM, Ivars Strazdiņš wrote:
>> Hi,
>> has anyone succeeded to setup RC with Davical and calendar plugins from 
>> these guys? https://git.faster-it.com/roundcube_calendar/about/
>> I have made two attempts, but calendar plugin throws error:
>> [01-Jun-2017 15:44:21 +0300]:  DAV Error: Not authenticated in 
>> /usr/share/roundcubemail/plugins/calendar/lib/SabreDAV/lib/OldSabre/DAV/Client.php
>>  on line 425 (GET /?_task=calendar)
>> I have debugged that the plugin passes base64 encoded string '%p' instead of 
>> real user password to authentication backend. But why and how to fix that - 
>> I have no idea really. There is SabreDAV and OldSabre packed inside plugin 
>> which makes things even more interesting :/
>> Once, on my first attempt, I had managed to setup plugin so that it was able 
>> to write to CalDAV database, but not able to read (verified from other 
>> client). Now I cannot even repeat that with second installation. I get above 
>> error message on both GET and POST operations. I suspect it was a 
>> configuration thing so maybe that is all that's required to change. But I am 
>> not sure.
>> It should be noted that their repository is not without problems, the fork 
>> claims a working configuration, but some functions 
>> (insert_default_calendar(), _expand_user()) were missing, I had to add them 
>> from original sources here: 
>> https://gitlab.awesome-it.de/kolab/roundcube-plugins/tree/feature_caldav
>> Any insight appreciated. Thanks!
>> Ivars
>> ___
>> 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

Re: [RCU] Reset RC settings to default

2017-10-11 Thread absolutely_free 
Hi,

yes I did. But I don't know pretty much RC internals :)

After next user's login, will his user_id be recreated?

In case, is it necessary to manually modify contacts table to make address book 
working again for specific user?


Thank you very much

> 
> Il 11 ottobre 2017 alle 10.55 Reindl Harald  ha 
> scritto:
> 
> Am 11.10.2017 um 10:50 schrieb absolutely_f...@libero.it:
> 
> > > 
> > is there a way to reset RC settings for some user?
> > 
> > I am using RC 1.1.9 with MySQL backend
> > 
> > > 
> did you even try to look at the database?
> just delete the database record for the user
> 
> MariaDB [roundcube_db]> show fields from users;
> 
> +--+--+--+-+-++
> | Field | Type | Null | Key | Default
> | Extra |
> 
> +--+--+--+-+-++
> | user_id | int(10) unsigned | NO | PRI | NULL
> | auto_increment |
> | username | varchar(128) | NO | MUL | NULL
> | |
> | mail_host | varchar(128) | NO | | NULL
> | |
> | created | datetime | NO | | 1000-01-01
> 00:00:00 | |
> | last_login | datetime | YES | | NULL
> | |
> | language | varchar(5) | YES | | NULL
> | |
> | preferences | longtext | YES | | NULL
> | |
> | failed_login | datetime | YES | | NULL
> | |
> | failed_login_counter | int(10) unsigned | YES | | NULL
> | |
> 
> +--+--+--+-+-++
> 9 rows in set (0.00 sec)
> 
> MariaDB [roundcube_db]> select * from users where
> username='h.rei...@thelounge.net';
> 
> +-++---+-+-+--+---+--+--+
> | user_id | username | mail_host | created |
> last_login | language | preferences
> 
> | failed_login | failed_login_counter |
> 
> +-++---+-+-+--+---+--+--+
> | 1 | h.rei...@thelounge.net | 127.0.0.1 | 2012-03-03 01:50:57 |
> 2017-09-24 21:44:54 | de_DE |
> 
> a:10:{s:11:"client_hash";s:32:"5b9d50d7dc8b4ffecc3b348d1c96cc04";s:11:"search_mods";a:5:{s:1:"*";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:4:"Sent";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:6:"Drafts";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:5:"gmail";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:5:"INBOX";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}}s:16:"message_sort_col";s:4:"date";s:18:"message_sort_order";s:4:"DESC";s:9:"list_cols";a:7:{i:0;s:7:"threads";i:1;s:7:"subject";i:2;s:4:"from";i:3;s:4:"date";i:4;s:4:"size";i:5;s:10:"attachment";i:6;s:8:"priority";}s:22:"preview_pane_mark_read";i:5;s:10:"keep_alive";i:60;s:10:"prettydate";b:0;s:9:"junk_mbox";s:4:"junk";s:20:"default_imap_folders";a:5:{i:0;s:5:"INBOX";i:1;s:6:"Drafts";i:2;s:4:"Sent";i:3;s:4:"junk";i:4;s:5:"Trash";}}
> | NULL | NULL |
> 
> +-++---+-+-+--+---

Re: [RCU] RC with Davical and calendar plugins from git.faster-it.com - any success?

2017-10-11 Thread Computerisms Corporation 

Hi Ivars,

I am wondering if you had any success with this in the end?  I have been 
playing with this plug in for a day or so now and also not having any 
luck.  I haven't found a problem with expand_user function, but I worked 
around insert_default_calendar by commenting the call to the function, 
since I want only caldav anyway.  I have been working my way through 
several patches in the kolab repository, and every time I do I get new 
problems and errors, but I don't know if that is fixing it or making it 
worse.


I have a copy of the myroundcube calendar/calendar_plus plugin, which I 
also tried to get working, but it seems to rely on the plugin system 
they were using, and I am not sufficiently skilled in programming to 
decipher its hiccup, and I don't want to try and transfer their whole 
plugin system to a new server.  The license on the software doesn't seem 
to prohibit me from changing the code, but it does prevent me from 
distributing it, so a dead end road anyway...


I had really hoped the roundcube_next project would solve this caldav 
issue, but can no longer afford to wait on this...


On 2017-06-01 06:16 AM, Ivars Strazdiņš wrote:

Hi,
has anyone succeeded to setup RC with Davical and calendar plugins from these 
guys? https://git.faster-it.com/roundcube_calendar/about/
I have made two attempts, but calendar plugin throws error:
[01-Jun-2017 15:44:21 +0300]:  DAV Error: Not authenticated in 
/usr/share/roundcubemail/plugins/calendar/lib/SabreDAV/lib/OldSabre/DAV/Client.php on 
line 425 (GET /?_task=calendar)

I have debugged that the plugin passes base64 encoded string '%p' instead of 
real user password to authentication backend. But why and how to fix that - I 
have no idea really. There is SabreDAV and OldSabre packed inside plugin which 
makes things even more interesting :/

Once, on my first attempt, I had managed to setup plugin so that it was able to 
write to CalDAV database, but not able to read (verified from other client). 
Now I cannot even repeat that with second installation. I get above error 
message on both GET and POST operations. I suspect it was a configuration thing 
so maybe that is all that's required to change. But I am not sure.

It should be noted that their repository is not without problems, the fork 
claims a working configuration, but some functions (insert_default_calendar(), 
_expand_user()) were missing, I had to add them from original sources here: 
https://gitlab.awesome-it.de/kolab/roundcube-plugins/tree/feature_caldav

Any insight appreciated. Thanks!
Ivars
___
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

Re: [RCU] Upgrade from 1.1.9 to 1.3.1

2017-10-11 Thread A.L.E.C 
On 10/11/2017 10:56 AM, absolutely_f...@libero.it wrote:
> Hi,
> 
> is it possible to upgrade RC from 1.1.9 to 1.3.1 without intermediate
> version?

Yes, it is possible.


-- 
Aleksander 'A.L.E.C' Machniak
Kolab Groupware Developer [http://kolab.org]
Roundcube Webmail Developer   [http://roundcube.net]

PGP: 19359DC1 # Blog: https://kolabian.wordpress.com
___
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users

Re: [RCU] Reset RC settings to default

2017-10-11 Thread A.L.E.C 
On 10/11/2017 10:50 AM, absolutely_f...@libero.it wrote:
> is there a way to reset RC settings for some user?

UPDATE users SET preferences = NULL WHERE 

above will reset all settings, but if you want to reset some specific
option you can use bin/moduserprefs.sh script.

-- 
Aleksander 'A.L.E.C' Machniak
Kolab Groupware Developer [http://kolab.org]
Roundcube Webmail Developer   [http://roundcube.net]

PGP: 19359DC1 # Blog: https://kolabian.wordpress.com
___
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users

Re: [RCU] SMTP and IMAP/STARTTLS

2017-10-11 Thread A.L.E.C 
On 10/11/2017 04:37 PM, Rich Lott wrote:

> 1. When roundcube accesses a remote IMAP server to fetch mail.
> 
> 2. When roundcube accesses a remote SMTP server to send mail.

Use tls:// prefix.

-- 
Aleksander 'A.L.E.C' Machniak
Kolab Groupware Developer [http://kolab.org]
Roundcube Webmail Developer   [http://roundcube.net]

PGP: 19359DC1 # Blog: https://kolabian.wordpress.com
___
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users

Re: [RCU] SMTP and IMAP/STARTTLS

2017-10-11 Thread Rich Lott 

Hi

On my first issue: wanting to use different SMTP settings for different 
hosts, I've found this plugin: 
https://gitlab.com/kolab-roundcube-plugins/ude-login

which is not quite what I wanted but will do.

However, I'm still having problems with starttls. There's two situations 
where I need to check/fix STARTTLS


1. When roundcube accesses a remote IMAP server to fetch mail.

2. When roundcube accesses a remote SMTP server to send mail.


On 11/10/17 14:57, Reindl Harald wrote:
it does always when the server offers TLS and frankly it does even on 
127.0.0.1 and then complain about certificte not machting - but why 
don#t you see the TLS connection in your maillog on the smtp server?


Thanks, but in my situation I do not control either of the remote 
servers, so I cannot check their logs.



I enabled imap_debug on roundcube but it does not seem to be clear :

[11-Oct-2017 15:32:49 +0100]:  [50AA] S: * OK [CAPABILITY 
IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE *STARTTLS* 
AUTH=PLAIN] Dovecot ready.
[11-Oct-2017 15:32:49 +0100]:  [50AA] C: A0001 ID ("name" 
"Roundcube" "version" "1.3.0 " "php" "7.0.19-1" "os" "Linux" "command" 
"/?_task=mail&_action=refresh")

[11-Oct-2017 15:32:49 +0100]:  [50AA] S: * ID ("name" "Dovecot")
[11-Oct-2017 15:32:49 +0100]:  [50AA] S: A0001 OK ID completed.
[11-Oct-2017 15:32:49 +0100]:  [50AA] C: A0002 AUTHENTICATE 
PLAIN ** [37]
[11-Oct-2017 15:32:49 +0100]:  [50AA] S: A0002 OK [CAPABILITY 
IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT 
SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT 
MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS 
LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES 
WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE] Logged in






I have enabled smtp_debug on roundcube. Here's the chat while SENDING to 
the SMTP server:



Send: EHLO (x removed )
Recv: 250-xx removed xx
Recv: 250-PIPELINING
Recv: 250-SIZE 3024
Recv: 250-VRFY
Recv: 250-ETRN
Recv: 250-STARTTLS
Recv: 250-ENHANCEDSTATUSCODES
Recv: 250-8BITMIME
Recv: 250 DSN
Send: RSET
Recv: 530 5.7.0 Must issue a STARTTLS command first
Send: QUIT
Recv: 221 2.0.0 Bye

So it looks like RC is not sending STARTTLS back in response?

?


--
Rich

___
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users

[RCU] SMTP and IMAP/STARTTLS

2017-10-11 Thread Rich Lott 

Hi

I have two questions

1. Roundcube allows a list of domains for IMAP through the 
$config['default_host'] = Array() config option. The different hosts 
require different SMTP settings also, but it seems that the smtp 
settings are assumed to be static. Is there a hook or such that allows 
me to set some config after a user is logged in, and based on the host 
(etc) they selected? i.e. someone who selects foo.com as the host needs 
to send to smtp.foo.mailserver.com and someone who selects bar.com as 
the host needs to send via localhost.



2. My (externally controlled) IMAP host offers STARTTLS over port 143 
(it does not open port 993). It's not clear to me whether RC is moving 
to TLS after the initial unencrypted connection. I don't want to use an 
insecure connection, but I can't see a way to check or specify that 
STARTTLS must be done?



Many thanks, and apols if these are daft questions, but I have read the 
config files and wiki, I promise :-)




--
Rich
___
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users

[RCU] Upgrade from 1.1.9 to 1.3.1

2017-10-11 Thread absolutely_free 
Hi,

is it possible to upgrade RC from 1.1.9 to 1.3.1 without intermediate version?

Thank you___
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users

[RCU] Reset RC settings to default

2017-10-11 Thread absolutely_free 
Hi,

is there a way to reset RC settings for some user?

I am using RC 1.1.9 with MySQL backend.

Thank you___
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users