- Dev - Roundcube mailing lists

Cron <root@newweb> run-parts /etc/cron.daily
by root＠newweb.matematica 26 Aug '06

26 Aug '06

/etc/cron.daily/00webalizer: [new_snode] Warning: String exceeds storage size (70) [new_snode] Warning: String exceeds storage size (71) [new_snode] Warning: String exceeds storage size (75) [new_snode] Warning: String exceeds storage size (84) [new_snode] Warning: String exceeds storage size (77) [new_snode] Warning: String exceeds storage size (76) [new_snode] Warning: String exceeds storage size (76) [new_snode] Warning: String exceeds storage size (65) Do I add a trac ticket with this? I think it may be the same problem that= =20 mail with wrong encoding headers have. -- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18 --------------------------------------------------------- Lic. Mart=EDn Marqu=E9s | SELECT 'mmarques' || Centro de Telem=E1tica | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador --------------------------------------------------------- ---2066700192-483365070-1156588105=:26034--

1 0

options
by Simon Hickling 26 Aug '06

26 Aug '06

options

1 0

fatal error with asort by opening an e-mail
by Christian Beuschel 25 Aug '06

25 Aug '06

Hello developers! I just installed RoundCube from: package: roundcube-webmail repository: universe version: 0.1-20051021ubuntu1 on my box: AMD Athlon XP 2200 with 512 MB RAM Ubuntu 6.06 LTS "Dapper Drake" Apache 2.0.55 PHP 5.1.2 MySQL 5.0.22 If I try to open an e-mail, I get this message: >>> Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 10412 bytes) in /usr/share/roundcube-webmail/program/lib/imap.inc on line 1390 <<< I looked at the file an found: 1387: // sort index 1388: $i=0; 1389: if ($flag=="ASC") asort($index); 1390: else arsort($index); Maybe you can help me getting this fixed. Yours faithfully Christian (Chris) Beuschel

1 0

Filtering spam with SpamAssassin header
by Brennan Stehling 24 Aug '06

24 Aug '06

I would like to adjust RoundCube to automatically place new mail into the Junk folder if it has a spam ranking from SpamAssassin. On my server... http://pronto.offwhite.net/antispam.html ..I have SpamAssassin set up and it will place the X-Spam-Level header with a set of stars indicating the spam level. I think RoundCube could check the SpamLevel and provide a personal setting to allow the user to automatically drop spam into the Junk folder. Thoughts? -- Brennan Stehling Offwhite.net LLC brennan(a)offwhite.net

15 35

SQL Reserved Words
by Ryan Fife 22 Aug '06

22 Aug '06

Hello, I'm working on getting RoundCube to work with Oracle and have run into problems with SQL reserved words being used for both table and column names. Oracle is one of the most strict databases with regard to reserved words. Here is the list of tables and column names that I've found to cause problems: Tables: session (I changed it to sessions and updated my config file. Easy fix.) Reserved Field names: users.language messages.uid (Not SQL-standard reserved but Oracle reserved) messages.from messages.to messages.date messages.size There's also a problem in the identities table with a minus sign in one of the fields: identities.reply-to There is no mechanism to have table and column names mapped in the config file so I'm asking for a recommendation on how to proceed. I think the ideal solution would be to change all the columns from reserved words to allowed words since only UID is a special Oracle (and Postgres) reserved word and the rest shouldn't really be allowed anywhere. The other alternative is to quote them everywhere but I'm not sure how portable this is and I'm testing Oracle on it now. What does everyone suggest? I've also attached my first attempt at oracle.initial.sql. Cheers, Ryan

2 2

Re: SQL Reserved Words
by Ryan Fife 22 Aug '06

22 Aug '06

Ah yes...the initial Oracle file is attached this time. Ryan

1 0

Nox Spell Server
by phil 22 Aug '06

22 Aug '06

The Google spell check guy has released his non-Google spell check option, Nox Spell Server. It's a server that runs Python and talks, via a local port, to Aspell - his comments: Nox Spell Server is a little Python Aspell server that is fully compatible with GoogieSpell. If you are concerned over privacy or reliability of Google's spell service, then look no more, because you found your solution Aspell also supports far more languages than Google spell service. http://orangoo.com/labs/?page_id=72 So this is very cool, and exactly what I was looking for, however it does mean that people that want to use it with Roundcube need to run this as a server/service for Roundcube to connect to. Can we include this in Roundcube, but have it in the config where it uses Google by default, and Nox if you call it out within the config? This way RC will work 'out of the box' but also allow you to use your local spell server, once it's config'd. I'm on vacation, but I'll start looking at this later in the week - would like to start testing this right away, if it weren't for this nice beach outside! P -- http://fak3r.com - you don't have to kick it -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

9 13

RC with huge mail box
by Eduardo Meyer 22 Aug '06

22 Aug '06

Hello, I am trying to use RC and it works fine, except for a mail box with around 600MB of e-mail usage. It keeps loading for around 2 minutes and later, gives up. any suggestions? -- =========== Eduardo Meyer pessoal: dudu.meyer(a)gmail.com profissional: ddm.farmaciap(a)saude.gov.br

2 1

IMAP folder name & UTF-8 problem
by Patrick T. Tsang 22 Aug '06

22 Aug '06

Hello All, The IMAP folder may contain naming like this: 1. MyFolder 2. myfolder 3. MyFoLoEr They all different but roundcude always pick the first one if it is on the top of the list. AND, there is no IMAP-UTF-7 to UTF-8 convertion on the IMAP folder. In my test, all my BIG5 IMAP folders cannot be read. may iconv would help. Thanks Patrick

1 0

Tickets assigned to 0.1-stable
by Michael Bueker 21 Aug '06

21 Aug '06

Hi there, if I understood the Roadmap correctly, there shouldn't be any tickets assigned to 0.1-stable, because we want to fix all known bugs until 0.1rc - is that correct? mtu -- Connectio Interruptus ist kein sicherer Schutz vor Viren!

2 1

Inbox issue resolved
by Brennan Stehling 20 Aug '06

20 Aug '06

http://trac.roundcube.net/trac.cgi/ticket/1436357 I diagnosed and resolve the issue, but I do not have Subversion rights. I would appreciate if a committer could review my changes. I have posted the patches as comments on the ticket. -- Brennan Stehling Offwhite.net LLC brennan(a)offwhite.net

2 2

Re: Filtering spam with SpamAssassin header
by Manu 18 Aug '06

18 Aug '06

Rob Smith wrote: > I went back and tried to apply your patch (although slightly modified > for DSPAM instead of SpamAssassin), and it didn't work on the latest > code from the SVN. When I first log in, emails turn green, but then as > soon as I click on any folder, nothing will turn green any more (even if > I just hard code the header check to true). Any clue what could have > happened? I think there's a problem with the cache. I use a field that I suspect not to be saved in the cache. I already mentioned this but nobody gives much attention and I wasn't able to fix it. It should be a matter of minutes for someone that have better understanding of it works. It's just about saving the 'junk' field of the object iilBasicHeader into the cache and retrieve it. Sorry.

4 6

Various issues with 0.1-beta2
by Manu 18 Aug '06

18 Aug '06

1) There's many IE CSS extensions in mail.css. 2) There's CSS typos or something like that line 535 to 537: html>body*#quicksearchbar { background-image: none; } html>body*#quicksearchbar a { top: 5px; } html>body*#quicksearchbar #quicksearchbox { width: 180px; top:0px; right: 1px; left: auto; } Firefox complains : Expected ',' or '{' but found '*'. Ruleset ignored due to bad selector. And there's a missing | and the end of a line. 3) A problem with MySQL ? I got this line hphp[10174]: ALERT - canary mismatch on erealloc() - heap overflow detected (attacker '212.234.8.113', file '/var/www/roundcubemail-0.1beta2/program/lib/DB/mysql.php', line 798) I run PHP 5.1.4 and MySQL 5.0.24 which are the latest versions available for my Gentoo.

1 0

How can I get started with sending in changes?
by Brennan Stehling 18 Aug '06

18 Aug '06

I would like to help with RoundCube development by adjusting a local copy and then submit changes. I have a few barriers I will need to overcome. First, I am not really familiar with how things are handled from a general overview and could use a walk-through. I am also not a big PHP developer. I have mainly worked with Perl, Java and ASP.NET (C# and VB.NET). But I have worked with PHP a bit. You can see an example of something I once did with PHP here... http://brennan.offwhite.net/blog/2004/09/27/phpnuke-feeds-for-rss-20-and-at… Second, I do have a lot of experience with Javascript but I have been working with the popular libraries like Prototype and Scriptaculous. So the custom Javascript I am seeing is not familiar to me here either. I will need a little assistance with getting started with it. One nice piece of Javascript I created is GPlotter. http://gplotter.offwhite.net/ The latest release uses Prototype and it uses an Object Oriented model, so is easier to work with during maintenance. As I reviewed the Javascript for RC it was not clear that there was a OO approach in terms of controlling the UI and handling the mail. I'd like to discuss some ideas with the core team who have been dealing with the UI and Javascript. I think I can be a big help here. I am also familiar with Subversion, so I already have a local copy pulled down and I am watching updates as the come down. I have been hoping to understand the application design by simply reading the code. I have an idea of how things are working, but the coding style is different than my own. I need some time to get comfortable with it. I am interested in doing whatever I can. Let me know if you would be willing to walk me through the PHP architecture or the Javacript. Thanks, -- Brennan Stehling Offwhite.net LLC brennan(a)offwhite.net

1 0

Re: Filtering spam with SpamAssassin header
by Michel Moreira 16 Aug '06

16 Aug '06

Try allowing the roundcube users to set their spam level and actions, and roundcube 'll manage the messages through those rules, no admin panel access 'll be needed.. ;) 2006/8/16, Nipun Jain <jain.nipun(a)gmail.com>: > Well, what I am talking about is that I have set my install in such a way > that if the user receives any email marked as spam by spamassasin, then it > automatically goes into the spam folder and I have roundcube automatically > subscribe to this folder when a new user is created. As for users marking a > mail as spam, thats not possible as to configure spamassasin, you need to re > write subjects which can only be done through the admin panel. > > > On 8/17/06, Michel Moreira <drungrin(a)gmail.com> wrote: > > You, the admin, setup it... and the other users? how about them having > > an friendly interface for setting it that isnt dependant of the server > > software? > > > > 2006/8/16, Nipun Jain < jain.nipun(a)gmail.com>: > > > Well, not exactly. If you got some kinda control panel with your shared > > > hosting, I am pretty sure that you can set spam mail to show up in a > spam > > > folder. If you are using a cPanel based hosting, let me know, I ll > provide > > > you guidance to set it up the way you want. > > > > > > Regards, > > > Nipun Jain. > > > > > > > > > On 8/17/06, Michel Moreira <drungrin(a)gmail.com> wrote: > > > > I dont think that we can rely on the server side software, cause of > > > > shared hostings, dont having access to this stuff and a lot of hosting > > > > issues. > > > > > > > > 2006/8/16, Brennan Stehling < brennan(a)offwhite.net>: > > > > > Yes, it would be great to get the webmail client set up so that it > can > > > actually control the procmail and mailfilter behavior somehow. I > suppose > > > you would need some server-side software to handle that interaction. > > > > > > > > > > Are there any projects which do this? > > > > > > > > > > Brennan > > > > > > > > > > On Wed, 16 Aug 2006 15:07:07 -0400, Mehmet Tolga Avcioglu > > > <mehmet(a)activecom.net> wrote: > > > > > > > > > > > > In my opinion something like this should be setup in the delivery > > > agent > > > > > > (procmail, maildrop). This behavior should be consistent between > > > > > > clients. For example we have a web based configuration tool for > these > > > > > > types of settings which creates the appropriate .mailfilter files > and > > > > > > the MDA does the rest. The behavior is same even is the users logs > in > > > > > > through web client or thunderbird, etc. > > > > > > > > > > > > I would actually like to see the Settings section extended so > these > > > > > > types of server side configurations could be implemented (spam > rules, > > > > > > blacklist, whitelist, vacation, etc.) as additional > > > extensions/modules.?? > > > > > > > > > > > > -- > > > > > > Mehmet Tolga Avcioglu > > > > > > > > > > > > Brennan Stehling wrote: > > > > > >> I would like to adjust RoundCube to automatically place new mail > into > > > > > > the Junk folder if it has a spam ranking from SpamAssassin. > > > > > >> > > > > > >> On my server... > > > > > >> > > > > > >> http://pronto.offwhite.net/antispam.html > > > > > >> > > > > > >> ..I have SpamAssassin set up and it will place the X-Spam-Level > > > header > > > > > > with a set of stars indicating the spam level. I think RoundCube > > > could > > > > > > check the SpamLevel and provide a personal setting to allow the > user > > > to > > > > > > automatically drop spam into the Junk folder. > > > > > >> > > > > > >> Thoughts? > > > > > >> > > > > > >> -- > > > > > >> Brennan Stehling > > > > > >> Offwhite.net LLC > > > > > >> brennan(a)offwhite.net > > > > > >> > > > > > >> > > > > > >> > > > > > -- > > > > > Brennan Stehling > > > > > Offwhite.net LLC > > > > > brennan(a)offwhite.net > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >

1 0

Re: Filtering spam with SpamAssassin header
by Brennan Stehling 16 Aug '06

16 Aug '06

Can I even configure procmail to move potential spam into my IMAP Junk folder? I have not seen how that can be done. Brennan On Wed, 16 Aug 2006 21:03:50 +0200, Michael Bueker <m.bueker(a)berlin.de> wrote: > Brennan Stehling wrote: >> I would like to adjust RoundCube to automatically place new mail into > the Junk folder if it has a spam ranking from SpamAssassin. >> [...] >> Thoughts? > > IMHO, this is not Roundcube's task, but that of your MDA (procmail, > maildrop, whichever). > > ~Mik > > -- > A: Why don't they just launch an arial attack? > B: An _arial_ attack! For a moment I was worried it might be a > Times New Roman one! > C: As long as they don't fight a war on two fonts... > - seen on /. -- Brennan Stehling Offwhite.net LLC brennan(a)offwhite.net

3 3

Fix for Bug #1483930
by Michael Bueker 15 Aug '06

15 Aug '06

Hi, I've worked on Bug #1483930 and resolved it thus: There are now two additional labels named "previousmessage" and "nextmessage", which are used in message.html, as opposed to "previousmessages" and "nextmessages" in mail.html. I've included the label entries for en_GB, en_US, de_DE, de_CH and es in the patch. If that's an okay course of action for you, please commit the patch and close the ticket :) Cheers, mtu -- What seems to be the Officer, problem? - From South Park, "Bloody Mary" diff -uNr rc-294/program/localization/de_CH/labels.inc rc-294fix/program/localization/de_CH/labels.inc --- rc-294/program/localization/de_CH/labels.inc 2006-08-06 15:51:22.000000000 +0200 +++ rc-294fix/program/localization/de_CH/labels.inc 2006-08-06 17:15:07.000000000 +0200 @@ -99,7 +99,9 @@ $labels['deletemessage'] = 'In den Papierkorb verschieben'; $labels['printmessage'] = 'Diese Nachricht drucken'; $labels['previousmessages'] = 'Vorherige Nachrichten anzeigen'; -$labels['nextmessages'] = 'Weitere Nachrichten anzeigen'; +$labels['previousmessage'] = 'Vorherige Nachricht anzeigen'; +$labels['nextmessages'] = 'Folgende Nachrichten anzeigen'; +$labels['nextmessage'] = 'Folgende Nachricht anzeigen'; $labels['backtolist'] = 'Zurück zur Liste'; $labels['select'] = 'Auswählen'; diff -uNr rc-294/program/localization/de_DE/labels.inc rc-294fix/program/localization/de_DE/labels.inc --- rc-294/program/localization/de_DE/labels.inc 2006-08-06 15:51:20.000000000 +0200 +++ rc-294fix/program/localization/de_DE/labels.inc 2006-08-06 17:03:49.000000000 +0200 @@ -100,7 +100,9 @@ $labels['deletemessage'] = 'In den Papierkorb verschieben'; $labels['printmessage'] = 'Diese Nachricht drucken'; $labels['previousmessages'] = 'Vorherige Nachrichten anzeigen'; -$labels['nextmessages'] = 'Weitere Nachrichten anzeigen'; +$labels['previousmessage'] = 'Vorherige Nachricht anzeigen'; +$labels['nextmessages'] = 'Folgende Nachrichten anzeigen'; +$labels['nextmessage'] = 'Folgende Nachricht anzeigen'; $labels['backtolist'] = 'Zurück zur Liste'; $labels['select'] = 'Auswählen'; diff -uNr rc-294/program/localization/en_GB/labels.inc rc-294fix/program/localization/en_GB/labels.inc --- rc-294/program/localization/en_GB/labels.inc 2006-08-06 15:51:20.000000000 +0200 +++ rc-294fix/program/localization/en_GB/labels.inc 2006-08-06 16:56:16.000000000 +0200 @@ -99,7 +99,9 @@ $labels['deletemessage'] = 'Move message to trash'; $labels['printmessage'] = 'Print this message'; $labels['previousmessages'] = 'Show previous set of messages'; +$labels['previousmessage'] = 'Show previous message'; $labels['nextmessages'] = 'Show next set of messages'; +$labels['nextmessage'] = 'Show next message'; $labels['backtolist'] = 'Back to message list'; $labels['viewsource'] = 'Show source'; diff -uNr rc-294/program/localization/en_US/labels.inc rc-294fix/program/localization/en_US/labels.inc --- rc-294/program/localization/en_US/labels.inc 2006-08-06 17:09:45.000000000 +0200 +++ rc-294fix/program/localization/en_US/labels.inc 2006-08-06 16:58:43.000000000 +0200 @@ -98,7 +98,9 @@ $labels['deletemessage'] = 'Move message to trash'; $labels['printmessage'] = 'Print this message'; $labels['previousmessages'] = 'Show previous set of messages'; +$labels['previousmessage'] = 'Show previous message'; $labels['nextmessages'] = 'Show next set of messages'; +$labels['nextmessage'] = 'Show next message'; $labels['backtolist'] = 'Back to message list'; $labels['viewsource'] = 'Show source'; diff -uNr rc-294/program/localization/es/labels.inc rc-294fix/program/localization/es/labels.inc --- rc-294/program/localization/es/labels.inc 2006-08-06 15:51:22.000000000 +0200 +++ rc-294fix/program/localization/es/labels.inc 2006-08-06 17:05:28.000000000 +0200 @@ -103,7 +103,9 @@ $labels['deletemessage'] = 'Mover mensaje a la papelera'; $labels['printmessage'] = 'Imprimir este mensaje'; $labels['previousmessages'] = 'Mostrar mensajes anteriores'; +$labels['previousmessage'] = 'Mostrar mensaje anterior'; $labels['nextmessages'] = 'Mostrar mensajes siguientes'; +$labels['nextmessage'] = 'Mostrar mensaje siguiente'; $labels['backtolist'] = 'Volver a la lista de mensajes'; $labels['viewsource'] = 'Mostrar código'; diff -uNr rc-294/skins/default/templates/message.html rc-294fix/skins/default/templates/message.html --- rc-294/skins/default/templates/message.html 2006-08-06 15:51:29.000000000 +0200 +++ rc-294fix/skins/default/templates/message.html 2006-08-06 17:26:15.000000000 +0200 @@ -11,9 +11,9 @@ <roundcube:include file="/includes/header.html" /> <div id="messagecountbar"> -<roundcube:button command="previousmessage" imageSel="/images/buttons/previous_sel.png" imageAct="/images/buttons/previous_act.png" imagePas="/images/buttons/previous_pas.png" width="11" height="11" title="previousmessages" /> +<roundcube:button command="previousmessage" imageSel="/images/buttons/previous_sel.png" imageAct="/images/buttons/previous_act.png" imagePas="/images/buttons/previous_pas.png" width="11" height="11" title="previousmessage" />  <roundcube:object name="messageCountDisplay" />  -<roundcube:button command="nextmessage" imageSel="/images/buttons/next_sel.png" imageAct="/images/buttons/next_act.png" imagePas="/images/buttons/next_pas.png" width="11" height="11" title="nextmessages" /> +<roundcube:button command="nextmessage" imageSel="/images/buttons/next_sel.png" imageAct="/images/buttons/next_act.png" imagePas="/images/buttons/next_pas.png" width="11" height="11" title="nextmessage" /> </div> <div id="messagetoolbar">

1 1

Re: Sorting Support in IMAP
by Eric Stadtherr 14 Aug '06

14 Aug '06

2 2

Sorting Support in IMAP
by Kevin Landers 14 Aug '06

14 Aug '06

I am wondering what kind of look up or test RoundCube does in order to decide whether or not it will allow the user to use the sorting function at the top of the columns in your mail folders. I have had the problem with quotas in the past, where RoundCube's initial look for Quota support in IMAP failed, even though Quota support does exist. So I had to comment out the checks for the Quota support in order to force RC to just go ahead and use the Quota functions. I am wondering if RC is doing a similar lookup in reference to sorting. I have logged in using Brett's RC 0.1 Beta 2 demo install. I logged into a demo account provided by "SKaero" on the RC forums. When I use his demo email account, the sorting features are present in each column. However, I then logged out and logged back in using my own account on my own server and I do not receive any sorting options. Where should I look to resolve this issue? Anyone have any insights? Thanks in advance, Kevin L.

2 3

New Template Command
by Brett Patterson 14 Aug '06

14 Aug '06

Hi all. After a user on the forum (Flash) tried to easily add a variable into a template. He tried many things, and I devised a nice template way of doing it. You can see the steps to do so here: http://roundcubeforum.net/forum/index.php?topic=342.msg1887#msg1887 It works as expected in the following manner: <roundcube:variable name="variableName" /> As with PHP, variableName != VariableName != VARIABLENAME != vArIaBlEnAmE != . . . so the name is case sensitive. This allows users to add variables they want in to their skin easily. Not sure if you want to add this or not, but I thought I'd put it on the table as an option for the beta3 or rc1 release (whichever naming convention you want to go with). ~Brett

1 0

attachment problem
by George Wu 11 Aug '06

11 Aug '06

There is a bug with roundcube where attachments don't get correctly displayed. This happens when a user sends email with an attachment via Apple Mail client to a user using roundcube. Although the email is viewable there is no attachment. Forwarding and saving to drafts correctly displays an attachment as well as forwarding to anyone else. diff -uNr rev304/roundcubemail/program/steps/mail/func.inc rev304-fixed/program/steps/mail/func.inc --- rev304/roundcubemail/program/steps/mail/func.inc 2006-08-08 16:27:06.000000000 -0700 +++ /var/www/lolamail/program/steps/mail/func.inc 2006-08-09 10:53:10.000000000 -0700 @@ -426,7 +426,8 @@ $message_icon = $attrib['messageicon']; // set attachment icon - if ($attrib['attachmenticon'] && preg_match("/multipart\/m/i", $header->ctype)) +// if ($attrib['attachmenticon'] && preg_match("/multipart\/m/i", $header->ctype)) + if ($attrib['attachmenticon'] && preg_match("/multipart\//i", $header->ctype)) $attach_icon = $attrib['attachmenticon']; $out .= sprintf('<tr id="rcmrow%d" class="message%s%s %s">'."\n", @@ -875,7 +876,8 @@ } // message contains multiple parts - else if ($message_ctype_primary=='multipart' && is_array($structure->parts)) + // else if ($message_ctype_primary=='multipart' && is_array($structure->parts)) + if ($message_ctype_primary=='multipart' && is_array($structure->parts)) { foreach ($structure->parts as $mail_part) { I've commented out the lines in question that cause this bug and replaced them with lines that do show the attachment. Is there a reason why lines 813 and down aren't under line 878 (i.e. nested if)? Also I can send out an email via Apple Mail if anyone is interested. Basically Apple Mail uses multipart/alternative as default and an attachment is contained after it. - George

1 1

Encoding problem
by Jan Mikus 11 Aug '06

11 Aug '06

There is encoding problem in headers with central european characters. Recipient address "Jan Mikuš <mikus(a)itcomputers.cz>" after encoding return "=?UTF-8?Q?Jan=20Miku=C5=A1=20<mikus(a)itcomputers.cz>?=" (right is "=?UTF-8?Q?Jan=20Miku=C5=A1?= <mikus(a)itcomputers.cz>") and Postfix this header encode to "=?UTF-8?Q?Jan=20Miku=C5=A1=20 <mikus(a)itcomputers.cz>,\n ?=(a)arachne.itcomputers.cz".

3 2

Alert message when attaching a file to a mail
by Ian 11 Aug '06

11 Aug '06

Hello, Since I updated Roundcube with the second beta, a JS alert() with some obscure HTML code is shown every time I upload an attachment. The file is uploaded correctly, I think this message was just used for debugging purpose. It can be removed by removing the line 2189 of the file "program/js/app.js". (the one with "alert(content)") Ian

2 1

Re: Addressbook database (was Re: Ticket #1332930 (Feature Requests))
by Eric Stadtherr 10 Aug '06

10 Aug '06

Brett, I have to disagree - XML is not meant for persistent storage of application data. You sacrifice referential integrity and efficient query capability if you just store everything as long text documents. Sure, the code to parse and transform it is easy, but the runtime cost of parsing through a complicated XML document for a single value in a single context is significant. Picture the popup address completion list taking 3-5 seconds to fill itself out when you start typing a name into the "Recipient" field... As an aside, if we do ever end up wanting to represent contact information in XML, there's a schema out there already for it: http://www.jabber.org/jeps/jep-0054.html -Eric > Eric Stadtherr wrote: >> >> I would suggest a database schema such as the following (let me know >> if my HTML table doesn't come across correctly): >> >> <snip> >> >> This would make it easily mappable to vCard contents without being too >> locked into vCard specifics. The "Field" column keeps you from having >> "n" columns for "n" bits of information (and saves space if only a >> subset of the fields are provided for a contact). The labels would map >> reasonably well to vCard parameters, while maintaining semantic >> consistency with tools like Apple's Address Book. Primary Key could be >> a simple surrogate key assigned to each row, or a compound key >> consisting of (Contact ID, Field, Label). The compound key would be >> more intuitive, but may cause implementation problems if the database >> provider doesn't like NULL values in the PK. Indexes could be built on >> any combination of columns to optimize searching. >> >> What do you think? >> >> -Eric >> >> >> >> On Thu, 10 Aug 2006 20:07:52 +0200, Thomas Bruederli wrote: >> >> Eric Stadtherr wrote: >> > Should rev306 be backed out then? It goes against this concept. >> > >> Well, my explanations haven't been clear enough when I talked to >> Tobias... I'll take care of that, but it definitely goes against my > ideas. >> >> I don't see any reason to have lots of fields in the database if we >> choose a format that can be parsed fast and allows us interchange > the >> data with other formats for import/export/sync. If searching the >> contacts gets a problem I suggest to create a fulltext index with > all >> field values required for search. >> >> Please don't hesitate to post your opinions to the > addressbook/database >> design. >> >> Regards, >> Thomas >> > Upon that note, why not use XML... it's what it's meant for. Instead of > another table to hold contacts, or multiple rows per contact, just store > XML data in one field. Then you can have X number of attributes of any > vCard or whatever format. It's easily parsable in PHP and can be > exported in a number for formats. It may even be quicker ;) > > <?xml version="1.0" encoding="ISO-8859-1"?> > <contacts> > <contact> > <fullname>FN</fullname> > <email type="home">fname(a)site.domain</email> > <email type="work">full.name(a)company.com</email> > <tele type="fax">+1 011-555-1234</tele> > </contact> > <contact> > <fullname>FN2</fullname> > <email type="home">someone(a)somewhere.de</email> > <tele type="work">+1 234-555-6666</tele> > </contact> > </contacts> > > Something like that would work wouldn't it? Obviously all the values > would be wrapped inside of <![CDATA[ ]]> tags... > > ~Brett

1 0

UTF7 - UTF8 folder encoding errors
by Eric Liang 10 Aug '06

10 Aug '06

Hello, I think the functions for UTF7-UTF8 encoding/decoding are not performing well, especially on the folders (view/create/rename folder). This happens mostly on non ISO-8859-1 charsets (in the source it shows that this function is not yet done). Is there a chance we get IMP's enc/decoding functions and use those instead? They work nicely in any system I tested IMP on. If someone wants privately to work with me on this issue please contact me directly. I am willing to spend a lot of my time in testing and debugging. I tried to fix this myself but I'm not good enough and even though I managed to decode folders fine (these folders contained foreign chars created by other programs) I messed things up with other functions. So basically I need someone who knows what he's doing in order to fix this together. Also, I propose that wherever needed, we should make the charset conversion assumptions configurable by the admin and not have them hardcoded to ISO-8859-1. If someone wants to work on this with me (I have a test system showcasing the issues which can be used for testing the fixes as well) please contact me directly. Thanks, Eric

3 6

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev