hmail and roundcube

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
iburnthings
New user
New user
Posts: 16
Joined: 2014-09-11 05:01

hmail and roundcube

Post by iburnthings » 2014-09-11 05:08

Does anyone recommend a specific webmail client for hmail? I've been using roundcube and for the most part it does what I need except pull aliases and domains from hmail. If anyone has experience with getting the roundcube plugin virtuser_query or modifying it to work with hmail I would appreciate help. Alternatively is there a way to create a flat file from hmail databases so that the RC plugin virtuser_file will read it? I recognize this isn't the roundcube forum and I don't expect it to be supported here but I figured it wouldn't hurt to ask.

Here's what I posted on the RC forum:

I need some help getting virtuser_query plugin to extract usernames from one table, and create identities in RC based on the domains in another table.

My hmail database has a few tables that I need virtuser to look at.
the first is table hm_accounts and it has an accountaddress column which lists as user@domain1.tld
the next is hm_aliases which has custom email addresses for a select number of accounts. aliasname has custom@domain.tld and aliasvalue has user@domain.tld
the third is hm_domain which has my primary domain as a single entry
the fourth is hm_domain_aliases which has all my secondary domain names linked to the primary. column daaslias lists 'domain1.tld' 'domain2.tld'

so I need virtuser_query to take the hm_accounts entry for the current user %u, remove @domain1.tld from it
then look at hm_domain_aliases and add each %u to each entry in table hm_domain_aliases
create identities for each.
Then less importantly I'd like to have hm_aliases processed and identities created for each custom email

Alternatively if it's possible to get virtuser_file to accept wildcards as part of the flatfile
for example instead of defining each account manually, just put something like.
%u@domain.tld %u
%u@domain1.tld %u

or a small script to generate my flatfile using a similar method described for virtuser_query

Another option would be to take %u (or the rc table 'identities' extract the 'name' value)
then take 'hm_domain_aliases'
add them together with an @ between them and inject the new values into roundcubemail.identities table

I don't know much about php, scripting, or mysql commands at all. Thanks in advance for the help.

User avatar
timex163
Normal user
Normal user
Posts: 38
Joined: 2014-06-17 13:20
Location: Montréal

Re: hmail and roundcube

Post by timex163 » 2014-09-11 23:46

Does anyone recommend a specific webmail client for hmail?
I gave my users the choice from Horde, Roundcube and SquirrelMail. ( The cpanel Mail combo)

If you want to give them a feel and options like OWA and GMAIL, i would go for horde.

If it's only for emails, go for Round Cube. Fast and really able.

If you want to give them an emergency fast webmail I would chose SquirrelMail.
If anyone has experience with getting the roundcube plugin virtuser_query or modifying it to work with hmail I would appreciate help. Alternatively is there a way to create a flat file from hmail databases so that the RC plugin virtuser_file will read it? I recognize this isn't the roundcube forum and I don't expect it to be supported here but I figured it wouldn't hurt to ask
That takes a while to do... and there multiple files to change.

You have 2 choices in my opinion :

1 : Hire a web developper to do it for you

Or

2 : Learn PHP and MYSQL. A good place to start is at developphp (dot) com

User avatar
timex163
Normal user
Normal user
Posts: 38
Joined: 2014-06-17 13:20
Location: Montréal

Re: hmail and roundcube

Post by timex163 » 2014-09-11 23:49

On second thought, I think Horde can do that for you right off the bat.

iburnthings
New user
New user
Posts: 16
Joined: 2014-09-11 05:01

Re: hmail and roundcube

Post by iburnthings » 2014-11-03 23:43

I've decided not to change mail servers. My user base is likely to not grow very fast so I'm not in need of a self registration process right now.

Post Reply