On Thu, Jan 21, 2010 at 1:07 PM, chasd <chasd(a)silveroaks.com> wrote:
> Apply the SQL file to your existing database :
> mysql -u roundcube -p webmail < mysql.update.sql
>
> If that borks it up, you can drop that database and load in your backup from
> the dump file and try again, or dump the borked data and compare it to your
> backup data.
I ran the command as suggested and got the following error:
[root@ideweb1 SQL]# mysql -u roundcube -p webmail < mysql.update.sql
Enter password:
ERROR 1091 (42000) at line 6: Can't DROP 'idx'; check that column/key exists
What does this mean? Did I do something wrong? Did I need to have
MySQL stopped or running? I don't understand why I got this error.
_______________________________________________
List info: http://lists.roundcube.net/users/
I am having troubles sending email with an attachment through rouncube.
I did confirm that I can send attachments via IMAP using the Thunderbird
email client. I have set PHP memory limit to 32M and the email attachment
limit to 12M in roundcube. When I try to send a 2M attachment I get the
following 2 lines in the error log:
[21-Jan-2010 07:00:27] PHP Warning:
sort() expects parameter 1 to be array, boolean given in
/var/www/roundcube/program/include/rcube_imap.php on line 1118
[21-Jan-2010
07:02:11] PHP Fatal error: Allowed memory size of 33554432 bytes exhausted
(tried to allocate 6952037 bytes) in
/var/www/roundcube/program/lib/Net/SMTP.php on line 887
It looks like PHP
is already exhausting the 32M, but I have no idea why?
_______________________________________________
List info: http://lists.roundcube.net/users/
On Thu, Jan 21, 2010 at 1:07 PM, chasd <chasd(a)silveroaks.com> wrote:
>
> On Jan 21, 2010, at 11:31 AM, Carlos Williams wrote:
>
>
>>
>> What exactly am I suppose to do? Run what command against the
>> 'mysql.update.sql' file?
>
> Apply the SQL file to your existing database :
> mysql -u roundcube -p webmail < mysql.update.sql
Ah, thank you very much! I will try that this evening and hopefully
nothing gets messed up. I did a MySQL dump just in case it does.
-Carlos
_______________________________________________
List info: http://lists.roundcube.net/users/
I am upgrading my Linux servers version of RoundCube this evening at
6pm. I have followed the Wiki:
http://trac.roundcube.net/wiki/Howto_Upgrade
1. Copy my old RC directory:
cp -r /var/www/html/roudcube /var/www/html/roundcube_old
2. I backed up my MySQL database as suggested using 'sqldump'
mysqldump -u roundcube -p webmail > /var/backup/mysql/webmail.dump
3. I re-did my new v0.3.1 main.inc.php and db.inc.php from scratch
using my old v0.2.1 configs as references.
4. Database Setup? This is where I am lost / confused. I am suppose to
go to the 'SQL' directory and look for 'mysql.update.sql' since I am
using MySQL 5.
What exactly am I suppose to do? Run what command against the
'mysql.update.sql' file? The Wiki is vague? I appears to be a .sql
file and I don't know what I should do with it. Can someone please
help and explain the process?
Thank you very much!
-Carlos
_______________________________________________
List info: http://lists.roundcube.net/users/
I find that sorting email folders by date doesn't always work
as expected. If you have slid an email into an alternate
folder, it appears that the email date-order assumes the date
of the slide, rather than the original date.
So sorting is screwy if you have moved emails around.
Am I missing something here?
_______________________________________________
List info: http://lists.roundcube.net/users/
Simple question here. I want to make the print icon available to users
on the action bar. I have had no luck finding how to do that in the forums
or list archives.
Thanks,
Javid
_______________________________________________
List info: http://lists.roundcube.net/users/
Hi,
I've denied access to logs, config and temp directory, except for
allowing 127.0.0.1
For the plugins directory I wanted to do the same, but then the Junk
icon doesn't show up anymore.
I tried with allowing 127.0.0.1 and the local server ip-address, and
that still doesn't give access to that icon from the plugins directory.
I'd like to restrict access to the plugins directory for anyone not
using RoundCube on my server, how to achieve that ?
Regard,
Adrian
_______________________________________________
List info: http://lists.roundcube.net/users/
How can I verify that I'm actually running fastcgi?
--
Stan
_______________________________________________
List info: http://lists.roundcube.net/users/
Is there any ability to have the roundcube main screen show the user's
email address
somewhere (perhaps to the right of the icons) ?
Perhaps even their name as defined in the roundcube records?
_______________________________________________
List info: http://lists.roundcube.net/users/
Hello,
i´ve some problem with Roundcube using TLS negotiation during SMTP. I´ve
searched through mailinglists and wiki but didn´t find a solution.
this is my smtp configuration:
$rcmail_config['smtp_server'] = 'tls://mail.jetsys.de';
$rcmail_config['smtp_port'] = 25;
$rcmail_config['smtp_user'] = '%u';
$rcmail_config['smtp_pass'] = '%p';
$rcmail_config['smtp_auth_type'] = '';
but sending a mail from Roundcube doesn´t succeed with this error message:
postfix/smtpd[30061]: connect from daolin.jetsys.de[192.168.9.1]
postfix/smtpd[30061]: lost connection after UNKNOWN from
daolin.jetsys.de[192.168.9.1]
postfix/smtpd[30061]: disconnect from daolin.jetsys.de[192.168.9.1]
roundcube: fsockopen(): unable to connect to tls://mail.jetsys.de:25
(Unknown error) (0):
roundcube: Failed to connect socket: fsockopen(): unable to connect to
tls://mail.jetsys.de:25 (Unknown error) ():
roundcube: [01-Jan-2010 10:49:18 +0100]: SMTP Error: SMTP error:
Connection failed: Failed to connect socket: fsockopen(): unable to
connect to tls://mail.jetsys.de:25 (Unknown error) in
/srv/www/htdocs/mail/program/steps/mail/func.inc on line 1365 (POST
/mail/?_task=mail&_action=send)
well, this isn´t really a syslog entry which gives me any clue whats
possibly wrong.
a telnet to my smtp server shows:
daolin:~ # telnet localhost smtp
Trying ::1...
Connected to localhost.
Escape character is '^]'.
220 mail.jetsys.de ESMTP Postfix
EHLO localhost
250-mail.jetsys.de
250-PIPELINING
250-SIZE
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH LOGIN CRAM-MD5 GSSAPI PLAIN DIGEST-MD5
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
and sending mail via thunderbird works as expected.
postfix/smtpd[29994]:connect fromhelena.jetsys.de[192.168.9.247]
postfix/smtpd[29994]: 1AFC4201E7:
client=helena.jetsys.de[192.168.9.247], sasl_method=CRAM-MD5,
sasl_username=js
postfix/cleanup[29998]: 1AFC4201E7: message-id=<4B3DC456.2000605(a)jetsys.de>
postfix/qmgr[6757]: 1AFC4201E7: from=<js(a)jetsys.de>, size=650, nrcpt=1
(queue active)
postfix/smtpd[29994]: disconnect from helena.jetsys.de[192.168.9.247]
i´ve also no problems with using TLS accessing the cyrus imap server.
Greetings, Jörg
_______________________________________________
List info: http://lists.roundcube.net/users/
Hi all
I need a few guiding steps for the change password plugin.
I
have my users in a Mysql database but I don't understand how to use the
plugin to get this working. The plugin talks about a macro called
update_passwd which should contain a fairly simple sql query. I can make
the sql query with out problems but where do I insert it??
Thanks!
--
/Thomas
http://wiki.lnxgeek.org
Go Ubuntu!!!
_______________________________________________
List info: http://lists.roundcube.net/users/
Hi all,
Do Citadel and Roundcube "play nicely" together ? any gotchas ?
cheers
sond
_______________________________________________
List info: http://lists.roundcube.net/users/
I am wondering if anyone has created a method to specify a domain name
on the address bar to eliminate the user from having to enter it. I
know that a 'default' can be set up, but this is not what I am intending.
I host webmail for dozens of domains. It would be very convenient if the
main index page (index.php) could have the domain attached; such as:
http://www.maindomain.net/roundcube/index.php/?_domain=custdomain.com
would/could create a login page which does NOT require a complete email
address, but attaches the "custdomain.com" to the userID which the
customer
has entered. If they bookmarked the link to: /?_domain=custdomain.com
they would never have to enter their domain name.
If this has been accomplished I would appreciate learning about it, else
I will delve into the code required to accomplish it. ... OR if someone
advises that existing architecture would make it very difficult I would
appreciate learning this as well.
Thanks!
Jim
_______________________________________________
List info: http://lists.roundcube.net/users/
Hi
I got a problem with the loginnames that roundcube sends to the server
for authentication. It seems that the username given to roundcube on
loginscreen is processed with strtolower() to lower case and send to the
server.
My user for example is user(a)domain.tld but I can login to roundcube as
well with UsEr(a)domain.tld which would never work in direct communication
with the server (for example with Thunderbird).
Is there a reason why roundcube lower-cases the usernames? If my user
would be User(a)domain.tld then the login in roundcube will always be
rejected as roundcube sends user(a)domain.tld which does NOT exist on the
server.
Is there a setting in the conf to force roundcube to send the username
as given by the user without any forcing of lower-case?
Thanks for any help
Cheers
tobi
_______________________________________________
List info: http://lists.roundcube.net/users/
Hi all,
I'm just tinkering a bit with the new_user_identity plugin to make it
compliant with our Exchange Server (argh!) installation here, and so far
things work out alright I would say. I had to adapt how user_name and
user_email are set, but thanks to the well-structured framework, that
wasn't much of a problem.
Now, I would like to set the 'organization' for each user at login to a
fixed string as well, but couldn't find out how to do this.
Hints, anyone?
Cheers,
Nico
_______________________________________________
List info: http://lists.roundcube.net/users/
This mailing list (hosted at gigo.com) will see delays Dec 22 through Dec
23, as gigo.com goes through a hardware upgrade. During this time posts to
lists may be delayed by as much as 24 hours. My intent is to keep this down
to a few hours or less.
The administrators of the mailing lists have my contact info. End users may
check the status of the server by visiting http://status.gigo.com .
-Jason Fesler
postmaster@ various domains, including the list you're reading this on.
_______________________________________________
List info: http://lists.roundcube.net/users/
i know it doesnt say so in the docs, but has anyone gotten
the roundcube database to work on oracle?
regards,
Jason
_______________________________________________
List info: http://lists.roundcube.net/users/
I remember asking this question some versions ago and never really
received a specific answer so now I am running a new mail server
(Postfix) with TLS / SASL Authentication & would like to know if its
possible when sending email from RC, can encrypt via TLS? I found the
option in my 'main.inc.php' file to login using TLS encryption:
// the mail host chosen to perform the log-in
// leave blank to show a textbox at login, give a list of hosts
// to display a pulldown menu or set one host as string.
// To use SSL/TLS connection, enter hostname with prefix ssl:// or tls://
$rcmail_config['default_host'] = 'tls://mail.iamghost.com';
The above setting works perfect as show in my mail.log file:
Dec 10 08:35:19 mail dovecot: imap-login: Login: user=<carlos>,
method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, TLS
Now I would like to use TLS for sending mail from RC and I am not sure
how to go about this specifically. Below I added a section from my
Postfix 'main.cf' file showing it's configured to send using SMTP but
I just don't know to enable this on my RC webmail client.
# SMTP settings
smtpd_tls_cert_file=/etc/ssl/certs/mail.crt
smtpd_tls_key_file=/etc/ssl/private/mail.key
smtpd_use_tls=yes
smtpd_tls_session_cache_database = btree:/var/lib/postfix/smtpd_scache
smtp_tls_session_cache_database = btree:/var/lib/postfix/smtp_scache
smtpd_tls_loglevel = 1
smtpd_sasl_auth_enable = yes
#smtp_sasl_auth_enable = yes
I am running "Version 0.3.1-20091031".
Thanks so much!
_______________________________________________
List info: http://lists.roundcube.net/users/
OK, I feel kinda stupid here, because I don't use this Microsoft stuff, but
still it's me who gets complaints about IE + RC usability. I'm using
RoundCube 0.3.1 with the default skin.
1. Message search field seems to be disabled, at least some users report that
they cannot click and type to it. I'm not sure about the exact browser
versions though.
2. Internet Explorer is said to not remembering the login credentials.
Can you suggest anything to look into?
Thank you,
Kristof
_______________________________________________
List info: http://lists.roundcube.net/users/
On Sat, 5 Dec 2009 20:31:24 +0700, "Mahfuzur Rahman"
<mahfuz(a)itconnectbd.com> wrote:
> Dear Sir,
>
>
>
> Recently I am configure Roundcube Webmail in Ubuntu 9.04 server edition.
> This time It work fine but I cant change some configuration which is
user
> quota and attachment file size. Would you please help me to solve the
> problem?
>
>
>
> Regards,
>
> Mahfuzur Rahman
>
> Bangladesh
hi Mahfuzur Rahman
use quota software
man quota
all depends on your mail server ....
nb : google is your friends
_______________________________________________
List info: http://lists.roundcube.net/users/
On Wed, 2 Dec 2009 20:22:40 +0100, till <klimpong(a)gmail.com> wrote:
> On Wed, Dec 2, 2009 at 8:11 PM, fakessh <fakessh(a)fakessh.eu> wrote:
>> On Wed, 2 Dec 2009 11:04:03 -0700, gnul <nullchar(a)gmail.com> wrote:
>>> I have not run RoundCube under mod_security, but from what I know
>>> about mod_security, I am sure it can be done.
>>>
>>> mod_security simply applies a [long] list of rules to the contents of
>>> each request (GET/POST/HEAD/etc) including the header.
>>>
>>> Depending on your ruleset, you often have to add exceptions for
>>> certain applications, and/or disable entire rules server-wide. What
>>> I've done in the past is: tail -F error_log while you use the
>>> application. Then you add exceptions for the uri (e.g. "/roundcube")
>>> or hostname or disable certain rules inside the modsecurity*.conf
>>> files.
>>>
>>
>> Thank you for your interest in my problem
>> how easy to apply new rules to mod_security ?
>
> I think you can do it in .htaccess. But you should check with your
> provider.
>
> Till
I can edit my file myself .htaccess .
I have root access on the machine
_______________________________________________
List info: http://lists.roundcube.net/users/
On Wed, 2 Dec 2009 08:17:14 -0600, chasd <chasd(a)silveroaks.com> wrote:
> Sorry about my last message, I made a mistake not to send it to the
> list.
>
>> here's nobody else who encounters the same problems with the
>> release 0.3.1 and
>> mod_security. here is the problem for tests ordered by Charles, we
>> must stop
>> roundcube and now I have three accounts running on production with
>> roundcube
>> disables mod_security
>>
>> It bothers me to stop my webmail service for several hours
>>
>> if anyone has a solution, an official patch
>>
>> a good suggestion
>
> I think the issue is that no one else on the list is running
> mod_security. I think you are the first to run into the issue.
>
> If someone else is running RC and mod_security, please speak up.
I listen to any suggestions regarding my problem with mod_security
I made some test on XP and VISTA successfully
with mod_security disabled
thanks for all your feedbacks
_______________________________________________
List info: http://lists.roundcube.net/users/
English:
Hello,
Since my last roundcube upgrade, Roundcube
interface doesn't display attachment icons on email where there is
attachement. Can you help me ?
Thanks !
French:
Bonjour,
Depuis une
mise à jour de roundcube, l'icône de pièce jointe ne s'affiche plus lorsque
j'au un email avec un attachement. Est ce normal ? Avez vous une solution ?
Merci !
_______________________________________________
List info: http://lists.roundcube.net/users/