Discussion in 'Feature Requests' started by nveid, Jan 16, 2006.

  1. LukaszP

    LukaszP New Member

    If I install Roundcube from package, what database is use?
  2. falko

    falko Super Moderator ISPConfig Developer

    ISPConfig's database.
  3. LukaszP

    LukaszP New Member

    I think so, but I can't find it... what names have table?
  4. falko

    falko Super Moderator ISPConfig Developer

    You can find the name of the database in /home/admispconfig/ispconfig/lib/
  5. danbogos

    danbogos New Member

    Hi Guys,

    I have installed the latest package (link provided above), but I cannot use it. Login and incoming e-mail works fine, but the outgoing mails are not sent out. The reason: the sender will be empty, it looks like roundcube cannot fetch the contact details from the database.

    From roundube logs:
    "[08-Jan-2007 09:37:03 +0100] DB Error: DB Error: unknown error Query: 1 ** SELECT identity_id, name, email, signature, html_signature FROM identities WHERE user_id='2' AND del<>1 ORDER BY "standard" DESC, name ASC [nativecode=sqlite_query() [<a href='function.sqlite-query'>function.sqlite-query</a>]: no such column: html_signature] in /home/admispconfig/ispconfig/web/roundcubemail/program/include/ on line 501"

    My question: do I need to do any extra settings to the one made automatically by inserting the package into ispconfig? As far as I saw, roundcube is using by default sqllite database, do I still need to create something in mysql?

    Thxs in advance for your time!

  6. falko

    falko Super Moderator ISPConfig Developer

    I've never used RoundCube, so I don't know how it works, but it seems that the html_signature column is missing in one of the database tables.
  7. danbogos

    danbogos New Member

    Thxs Falko for your fast reply. Got it now, it looks like there is necessary to alter the table identities as update process (

    Maybe paulrobert_a will do this in the package so the other users should not experience the same fault I had. By the way there is a new release already available on RoundCube site.

    Dan Bogos
  8. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    I was wondering if it's possible to name the package acording to the version, so we know what version we install or have installed.

  9. paulrobert_a

    paulrobert_a New Member

    Hey Folks,

    Another update, RoundCube SVN rev 461.

    Database alterations require database to be replaced, unless you do the changes manually.
    *RoundCube FAQ* Thanks danbogos

    Please don't contact me for support, I only created the package. For all support queries, please direct them to the roundcube forums.


    The Download
  10. paulrobert_a

    paulrobert_a New Member

    Hey DaRKNeSS,

    I'm not entirely sure what exactly you mean, as all the rc packages have names with the SVN rev number attached.

  11. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    Hee I am seeing that now, strange I know fur sure I heve downloaded twice an roundcube.pkg pakage. Mabey I did something wrong.:confused:

  12. paulrobert_a

    paulrobert_a New Member

    Hey DaRKNeSS,

    I know the ISPConfig website has it as 'RoundCube.pkg' and I have it as this for beta 1 on page 2 of this thread, along with a mirror... mibbie it was that, that caused the confusion?

    All well, I was curious to see what the name scheme was going to be :(

  13. s2angel

    s2angel New Member

    Debian user can not get mail anymore since latest roundcube pkg install..

    I have not seen anyone resolve or know if this is resolved..

    I also am running debian with todays verion(whatever it is ) of roundcube pkg from ispconfig website and am unable to recieve any emails now!

    Seems alike all my accounts are not recieving any emails

    weird everything was working then I go and add roundcube and its like they don't even make it to the server.. can someone help me?!

    The logs don't seem to show much..
    In the mean time I am going to go look around if I can and try to see what roundcube changed.. .. can roundcube actualy stop emails from coming in?

    Note I made a change to make my users logins be domain.com_username

    Not sure if this effects things
  14. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    sounds like your port 25 is blocked by your isp.
  15. s2angel

    s2angel New Member

    I wish it was something that simple..

    but that was not it..

    Turns out I selected maildir

    What is maildir exactly..??

    and how do I get the mail put back into the mail where it normaly was /var/mail in single files??

    aargh! Though its nobodies falut but ine.. always read ahead.. and read about what you don't understand!

    for 9am till now I had mail going there cause I selected maildir so I could access the webmail..

    I would still like to know how I can run both at the same time!..

    As I analized the logs mail was being deliverd fine.. so it made no sence (it was just saving it someplace else!)

    But as soon as it stopped coming in I went through the painfull process of elimination everything I had done
    eventualy unclicking the maildir check I placed earlier this morning! and testing a email account!)

    Maybe someone can explain maildir or point to a link or possibly explain how I can have pop accounts and webmail
    I look forward to the responce time will tell .. in the mean time I will start searching the fourms and the google for maildir info

    I still can't get outlook users to get email yet wither.. just thunderbird with tls enabled

    Last edited: Feb 13, 2007
  16. 3cwired_com

    3cwired_com New Member

    I believe maildir, is used when you are using the other webmail clients, and it facilitates the process, by putting peoples mails in separate folders. You might have to go to advanced in outlook and select authentication. I did notice that check box when I was poking around. I did however manage to set up my outlook and its working well so far.
  17. schmidtedv

    schmidtedv Member HowtoForge Supporter

    ...if anyone would like to use the mailfunctioning Spellcheck...there are missing files in all roundcube are mine, for the actual 0.1beta2.2 release, this includes the changes for to include the files into the compose-window! Just replase, if you are using this version, otherwise you have to do the changes manually :)

    After that spellcheck is working!!

    Attached Files:

  18. letic

    letic New Member

  19. damir

    damir New Member

    Does anyone have latest .pkg of roundcube, besides the one on

    Kind regards
  20. paulrobert_a

    paulrobert_a New Member

    Yeah sorry for the delay, here is the new home for the Roundcube package.



Share This Page