Users

users@lists.roundcube.net

2 participants
2900 discussions

bulk import csv (multi contacts)
by Webert de Souza Lima 17 Jul '18

17 Jul '18

Hi, I have to import multiple csv files for multiple contacts (basically 1 csv with thousands contacts per user). I wonder if there's a way to use roundcube internal code to do this for me with the help of bach script to loop through the CSVs and parse what user it belongs to, and use such tool to automate the importing of CSV. I first tried to script to to mysql db directly, but I would have to convert everything to a vCard first, and I would have to figure out the user/group/contact relations, so no. The CSV file I have is in the expected MS Outlook 2010 format (headers). Thanks. Regards, Webert Lima DevOps Engineer at MAV Tecnologia *Belo Horizonte - Brasil* *IRC NICK - WebertRLZ*

2 2

enabling internal service tls authentication
by David Mehler 16 Jul '18

16 Jul '18

Hello, I've got a vps that I'm wanting to tighten down its webmail setup. Currently it's running php 5.6 and it does have the openssl extension loaded. It's got apache 2.4 and that hooks in to php via php-fpm. I'm running Postfix and Dovecot and Roundcube 1.3.6. What I'm wanting to do is tls-encrypt all server communications from roundcube to the various imap/smtp servers. I've got letsencrypt providing my server certificates. In my roundcube configuration I've got a map pointing: #cat host1_config.inc.php <?php $config['username_domain'] = 'example.com'; $config['default_host'] = 'tls://mail.example.com'; // For STARTTLS IMAP $config['imap_conn_options'] = array( 'ssl' => array( 'verify_peer' => true, // certificate is not self-signed if cafile provided 'allow_self_signed' => false, // Letsencrypt 'ssl_cert' => '/usr/local/etc/ssl/acme/example.com/fullchain.pem', 'ssl_key' => '/usr/local/etc/ssl/acme/private/example.com/privkey.pem', // probably optional parameters 'ciphers' => 'TLSv1.2:@STRENGTH', 'peer_name' => 'mail.example.com', ) ); // For STARTTLS SMTP $config['smtp_conn_options'] = array( 'ssl' => array( 'verify_peer' => true, // certificate is not self-signed if cafile provided 'allow_self_signed' => false, // Letsencrypt 'ssl_cert' => '/usr/local/etc/ssl/acme/example.com/fullchain.pem', 'ssl_key' => '/usr/local/etc/ssl/acme/private/example.com/privkey.pem', // probably optional parameters 'ciphers' => 'TLSv1.2:@STRENGTH', 'peer_name' => 'mail.example.com', ), ); When I atempt to connect via roundcube I get a gateway timeout message and this in my imap server log: 2018-07-16 14:01:31 imap-login: Info: Disconnected (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, TLS handshaking: SSL_accept() failed: error:140760FC:SSL routines:SSL23_GET_CLIENT_HELLO:unknown protocol, session=<AsiSniFxS91/AAAB> Any ideas? Thanks. Dave.

1 0

Re: [RCU] installation php modues [SOLVED]
by Teno Deuter 11 Jul '18

11 Jul '18

following the below thread: https://www.roundcubeforum.net/index.php?topic=15450.0 did solve the issue Thank you very much for your help On Tue, Jul 10, 2018 at 4:19 PM, Vincent Van Houtte <vvh(a)aplusv.be> wrote: > On 2018-07-10 15:59, Teno Deuter wrote: >> >> Thnak you for your reply. >> >> Any idea why I get the: >> >> Mimetype to file extension mapping: NOT OK > > > Google provides some hints. Did you try the solutions posted here? > https://www.google.com/search?q=Mimetype+to+file+extension+mapping%3A++NOT+… > > Kind regards, > Vincent > > >> >> Thank you >> >> Regarrds >> >> On Tue, Jul 10, 2018 at 1:45 PM, Reindl Harald <h.reindl(a)thelounge.net> >> wrote: >>> >>> just install the extension packages and make sure they are enabled in >>> php.ini or a php.ini-dropin >>> >>> php -m >>> >>> Am 10.07.2018 um 13:20 schrieb Teno Deuter: >>>> >>>> in a OpenBSD 6.3 machine I run httpd and opensmptd and try to intall >>>> roundcubemail 1.3.5 from the OpenBSD packages repository. >>>> >>>> When running the installer, in the first page, I get following warnings: >>>> >>>> FileInfo: OK >>>> Libiconv: OK >>>> Intl: NOT AVAILABLE(See http://www.php.net/manual/en/book.intl.php) >>>> Exif: OK >>>> LDAP: NOT AVAILABLE(See http://www.php.net/manual/en/book.ldap.php) >>>> GD: NOT AVAILABLE(See http://www.php.net/manual/en/book.image.php) >>>> Imagick: NOT AVAILABLE(See >>>> http://www.php.net/manual/en/book.imagick.php) >>>> >>>> but pkg_info shows: >>>> >>>> php-gd-5.6.34 image manipulation extensions for php >>>> php-intl-5.6.34 intl library support for php >>>> >>>> and I think php-imagick is already part of the php OpenBSD package. >>>> >>>> Why do I get the above warnings? >>>> >>>> also, in the second installation page I get the following: >>>> >>>> Mimetype to file extension mapping: NOT OK >>>> >>>> but in httpd.conf, on the top of the file, I have the following entry: >>>> >>>> types { include "/usr/share/misc/mime.types" } >> >> _______________________________________________ >> Roundcube Users mailing list >> users(a)lists.roundcube.net >> http://lists.roundcube.net/mailman/listinfo/users > > > Vincent Van Houtte > _______________________________________________ > Roundcube Users mailing list > users(a)lists.roundcube.net > http://lists.roundcube.net/mailman/listinfo/users

1 0

Re: [RCU] installation php modues
by Teno Deuter 10 Jul '18

10 Jul '18

Thnak you for your reply. Any idea why I get the: Mimetype to file extension mapping: NOT OK Thank you Regarrds On Tue, Jul 10, 2018 at 1:45 PM, Reindl Harald <h.reindl(a)thelounge.net> wrote: > just install the extension packages and make sure they are enabled in > php.ini or a php.ini-dropin > > php -m > > Am 10.07.2018 um 13:20 schrieb Teno Deuter: >> in a OpenBSD 6.3 machine I run httpd and opensmptd and try to intall >> roundcubemail 1.3.5 from the OpenBSD packages repository. >> >> When running the installer, in the first page, I get following warnings: >> >> FileInfo: OK >> Libiconv: OK >> Intl: NOT AVAILABLE(See http://www.php.net/manual/en/book.intl.php) >> Exif: OK >> LDAP: NOT AVAILABLE(See http://www.php.net/manual/en/book.ldap.php) >> GD: NOT AVAILABLE(See http://www.php.net/manual/en/book.image.php) >> Imagick: NOT AVAILABLE(See http://www.php.net/manual/en/book.imagick.php) >> >> but pkg_info shows: >> >> php-gd-5.6.34 image manipulation extensions for php >> php-intl-5.6.34 intl library support for php >> >> and I think php-imagick is already part of the php OpenBSD package. >> >> Why do I get the above warnings? >> >> also, in the second installation page I get the following: >> >> Mimetype to file extension mapping: NOT OK >> >> but in httpd.conf, on the top of the file, I have the following entry: >> >> types { include "/usr/share/misc/mime.types" }

2 1

installation php modues
by Teno Deuter 10 Jul '18

10 Jul '18

Dear list, in a OpenBSD 6.3 machine I run httpd and opensmptd and try to intall roundcubemail 1.3.5 from the OpenBSD packages repository. When running the installer, in the first page, I get following warnings: FileInfo: OK Libiconv: OK Intl: NOT AVAILABLE(See http://www.php.net/manual/en/book.intl.php) Exif: OK LDAP: NOT AVAILABLE(See http://www.php.net/manual/en/book.ldap.php) GD: NOT AVAILABLE(See http://www.php.net/manual/en/book.image.php) Imagick: NOT AVAILABLE(See http://www.php.net/manual/en/book.imagick.php) but pkg_info shows: php-gd-5.6.34 image manipulation extensions for php php-intl-5.6.34 intl library support for php and I think php-imagick is already part of the php OpenBSD package. Why do I get the above warnings? also, in the second installation page I get the following: Mimetype to file extension mapping: NOT OK but in httpd.conf, on the top of the file, I have the following entry: types { include "/usr/share/misc/mime.types" } Thank you

1 0

confirm 76b9e7c74680783319e8788aca3a98fc8bdd0128
by César Bordón 09 Jul '18

09 Jul '18

1 0

Re: [RCU] PHP patch update, Roundcube crashes
by Rouncube Lbutlr 03 Jul '18

03 Jul '18

One other thing, php does work, this is a roundcube specific error. here is the relevant part of my info.php file: Jun 30 2018 16:37:36 Configure Command './configure' '--with-layout=GNU' '--with-config-file-scan-dir=/usr/local/etc/php' '--disable-all' '--enable-libxml' '--enable-mysqlnd' '--with-libxml-dir=/usr/local' '--with-pcre-regex=/usr/local' '--with-zlib-dir=/usr' '--program-prefix=' '--enable-fpm' '--with-fpm-user=www' '--with-fpm-group=www' '--enable-embed' '--with-regex=php' '--with-zend-vm=CALL' '--prefix=/usr/local' '--localstatedir=/var' '--mandir=/usr/local/man' '--infodir=/usr/local/info/' '--build=i386-portbld-freebsd11.1' 'build_alias=i386-portbld-freebsd11.1' 'CC=cc' 'CFLAGS=-O2 '-pipe' '-fstack-protector' '-fno-strict-aliasing'' 'LDFLAGS= '-fstack-protector'' 'LIBS=-lpthread' 'CPPFLAGS=' 'CPP=cpp' 'CXX=c++' 'CXXFLAGS=-O2 '-pipe' '-fstack-protector' '-fno-strict-aliasing' Server API FPM/FastCGI Virtual Directory Support disabled Configuration File (php.ini) Path /usr/local/etc Loaded Configuration File /usr/local/etc/php.ini Scan this dir for additional .ini files /usr/local/etc/php Additional .ini files parsed /usr/local/etc/php/ext-10-opcache.ini, /usr/local/etc/php/ext-18-session.ini, /usr/local/etc/php/ext-20-bcmath.ini, /usr/local/etc/php/ext-20-calendar.ini, /usr/local/etc/php/ext-20-ctype.ini, /usr/local/etc/php/ext-20-curl.ini, /usr/local/etc/php/ext-20-dom.ini, /usr/local/etc/php/ext-20-filter.ini, /usr/local/etc/php/ext-20-ftp.ini, /usr/local/etc/php/ext-20-gettext.ini, /usr/local/etc/php/ext-20-gmp.ini, /usr/local/etc/php/ext-20-hash.ini, /usr/local/etc/php/ext-20-iconv.ini, /usr/local/etc/php/ext-20-imap.ini, /usr/local/etc/php/ext-20-json.ini, /usr/local/etc/php/ext-20-ldap.ini, /usr/local/etc/php/ext-20-mcrypt.ini, /usr/local/etc/php/ext-20-mysqli.ini, /usr/local/etc/php/ext-20-openssl.ini, /usr/local/etc/php/ext-20-pdo.ini, /usr/local/etc/php/ext-20-posix.ini, /usr/local/etc/php/ext-20-pspell.ini, /usr/local/etc/php/ext-20-readline.ini, /usr/local/etc/php/ext-20-simplexml.ini, /usr/local/etc/php/ext-20-sqlite3.ini, /usr/local/etc/php/ext-20-tokenizer.ini, /usr/local/etc/php/ext-20-xml.ini, /usr/local/etc/php/ext-20-xmlwriter.ini, /usr/local/etc/php/ext-30-pdo_sqlite.ini, /usr/local/etc/php/ext-30-phar.ini, /usr/local/etc/php/ext-30-xmlreader.ini PHP API 20131106 PHP Extension 20131226 Zend Extension 220131226 Zend Extension Build API220131226,NTS PHP Extension Build API20131226,NTS Debug Build no Thread Safety disabled Zend Signal Handling disabled Zend Memory Manager enabled Zend Multibyte Support disabled IPv6 Support enabled DTrace Support disabled Registered PHP Streamsphp, file, glob, data, http, ftp, https, ftps, phar Registered Stream Socket Transportstcp, udp, unix, udg, ssl, sslv3, tls, tlsv1.0, tlsv1.1, tlsv1.2 Registered Stream Filtersstring.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, convert.iconv.*, mcrypt.*, mdecrypt.*

3 2

(no subject)
by Rouncube Lbutlr 01 Jul '18

01 Jul '18

On 30 Jun 2018, at 04:18, Rouncube Lbutlr <lbutler+roundcube(a)covisp.net> = wrote: > Fatal error: Undefined class constant 'MYSQL_ATTR_FOUND_ROWS' in > /usr/local/www/roundcube/program/lib/Roundcube/rcube_db_mysql.php on > line 144 > Fatal error: Undefined class constant =E2=80=98MYSQL_ATTR_FOUND_ROWS' in > /usr/local/www/roundcube/program/lib/Roundcube/rcube_db_mysql.php on > line 144 I recompile php56 making sure that FPM was enabled, but this made no difference. I turned on CGI just for grins, but that didn't help. Nothing is logged in the http-error log, and the roundcube log only shows the above error.

1 0

PHP patch update, Roundcube crashes
by Rouncube Lbutlr 01 Jul '18

01 Jul '18

Fatal error: Undefined class constant 'MYSQL_ATTR_FOUND_ROWS' in /usr/local/www/roundcube/program/lib/Roundcube/rcube_db_mysql.php on line 144 Fatal error: Undefined class constant ‘MYSQL_ATTR_FOUND_ROWS' in /usr/local/www/roundcube/program/lib/Roundcube/rcube_db_mysql.php on line 144 I made sure that php56-mysql and php56-curl were up-to-date with the rest of php56

2 1

Firefox - "Mixed content is not blocked: not secure"
by Philip Rhoades 30 Jun '18

30 Jun '18

People, I access RCM in a SSL protected directory and use FF as the routine browser for accessing this RCM on my server. After upgrading from Fedora 27 x86_64 to F28 on my workstation, I started seeing a "grey lock with an orange triangle": https://support.mozilla.org/en-US/kb/mixed-content-blocking-firefox?redirec… It appears that this is due to: skins/classic/images/watermark.gif - if I delete that file then the lock returns to its expected green colour without the orange triangle. Is this a serious issue? Thanks, Phil. -- Philip Rhoades PO Box 896 Cowra NSW 2794 Australia E-mail: phil(a)pricom.com.au

2 1

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users