Author Topic: Vacation Assistent, Forward Tab, Password Tab - hMailserver  (Read 26310 times)

Offline ZabbensX

  • Newbie
  • *
  • Posts: 7
Vacation Assistent, Forward Tab, Password Tab - hMailserver
« on: January 23, 2008, 07:44:04 AM »
Hi @ all,

i had developt the Forwad Tab and the Vacation Assistant Tab,
there is also a Password Change Tab i dont know exactly how did the work,
but thanks so far :)

In the Attachment there are the Files for all 3 Tabs,
to run the Password Change Tab both Databases have to be on one sql Server
You have to set the Permissions right ;)
In the passwd.inc you have to set up the right Database in the SQL Statement.

The Vacation and Forward Tab uses the COM interface from the hmailserver,
so you have to enable com in you php.ini

In the fwd.inc and the away.inc you have to set the adminpassword of the hmailserver,
and the host where hmailserver is running, mostly localhost...
The setting have to be done twice in each file.

I give no WARANTY on the Patch, so make a backup of your webmail Folder.
If you have some Questions, write in this Thread, so anyone can profit.

Greetings

ZX
It's not a bug - It's a feature

Offline Thunderstorm

  • Newbie
  • *
  • Posts: 1
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #1 on: January 23, 2008, 08:30:01 PM »
Hiya

Awesome thank you, added some functions to my clients for hmail :)
Just to let you know on the password page the text area labels are set for

"curpasswd" "conpasswd" etc

I change mine to read "Current Password" etc etc

anyway perfect after setting up and testing :)

Thank you
Peter

Offline MacOfTheEast

  • Newbie
  • *
  • Posts: 9
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #2 on: January 24, 2008, 06:25:52 AM »
Quote from: ZabbensX
The Vacation and Forward Tab uses the COM interface from the hmailserver,
so you have to enable com in you php.ini
Too bad, then, as the php com extensions are only available to winDOZE users :'(

MOTE

Offline ZabbensX

  • Newbie
  • *
  • Posts: 7
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #3 on: January 24, 2008, 10:54:08 AM »
Try it with SQL instead of the COM System...

When there is a SQL Databse it might work so?

It's not a bug - It's a feature

Offline ZabbensX

  • Newbie
  • *
  • Posts: 7
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #4 on: January 24, 2008, 11:09:17 AM »
Quote from: Thunderstorm
Hiya

Awesome thank you, added some functions to my clients for hmail :)
Just to let you know on the password page the text area labels are set for

"curpasswd" "conpasswd" etc

I change mine to read "Current Password" etc etc

anyway perfect after setting up and testing :)

Thank you
Peter

I put the wrong label / messages files in the Archiv, sorry ???
I replaced the Files and uploaded them again, now it should be fine...

Greetings

ZX
It's not a bug - It's a feature

Offline ajn

  • Newbie
  • *
  • Posts: 1
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #5 on: February 03, 2008, 03:36:02 PM »
Thank you! Works just perfect! ;)

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #6 on: February 06, 2008, 12:06:59 PM »
I'm wondering why you don't just include PHPWebAdmin. It is shipped with hMailServer and it has all the features you have coded new and much more.

In addition it is possible to run PHPWebAdmin on a separate host. If you use the code here, you must run RoundCube on the (Windows)Box where hMailServer resides.

If someone is interested in how I have integrated PHPWebAdmin into RoundCube (Tab in Personal Settings, inherit Authentication, suitable styling), just drop a note here or contact me via Private Message.

Please no mis-understanding, no critics for the great job here!

-Roland
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline jbaitz

  • Newbie
  • *
  • Posts: 5
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #7 on: February 21, 2008, 09:00:25 AM »
Roland,

I would be interested in the steps you took to integrate PHPWebAdmin into RC for Hmail.  We are currently testing a new mailsetup and would like to see what options this gives us.

Thanks

Justin

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #8 on: February 28, 2008, 12:47:50 PM »
@ jbaitz and joe.davis (mailed me via PM)

I do not have an instruction just for hmailserver PHPWebAdmin integration because I made a lot of changes ...

You can download the whole stuff @ http://liebl.ath.cx/dl/hMailServer/

Please consider that you have to modify the database structure as adviced in myroundcube_screenies.doc.

Key features of my modified RoundCube are:

* Sign up Users (CAPTCHA support) by web
* IDNA Domains/Users
* Password Tools
* Spam Filter Interface, Report Ham/Spam messages
* PHPWebadmin integration
* Google Ads support
* GoogieSpell Tunnel
* Advanced Addressbook
* Disallow spoofing Identies
* Lockout Tool for too many invalid logins or hack attempts
* Message Flags, Select Range, Invert Selection
* maybe there is more ...

... all the stuff is customizable by the config files.

NOTICE: Totally beta stuff, but productive on my site since 2 weeks without major issues.

-Roland
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline giuseppe

  • Newbie
  • *
  • Posts: 7
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #9 on: February 28, 2008, 03:54:49 PM »
I have compiled a sql script to make necessary database modifications for these plug-ins.

Code: [Select]
CREATE TABLE `accesscontrol` (
`id` int(10) unsigned,
`ip` varchar(15),
`host` varchar(128),
`sess_id` varchar(40),
`user_id` int(10),
`username` varchar(128),
`datetime` datetime,
`task` varchar(128),
`action` varchar(128),
`status` int(1),
`totalhits` int(10),
`hitslastmin` int(10),
`invalid_login` int(10)
);
ALTER TABLE `contacts` ADD `type` int(1);
ALTER TABLE `contacts` ADD `address` varchar(128);
ALTER TABLE `contacts` ADD `academic_title` varchar(128);
ALTER TABLE `contacts` ADD `nickname` varchar(128);
ALTER TABLE `contacts` ADD `email_2` varchar(128);
ALTER TABLE `contacts` ADD `email_3` varchar(128);
ALTER TABLE `contacts` ADD `street` varchar(128);
ALTER TABLE `contacts` ADD `number` varchar(128);
ALTER TABLE `contacts` ADD `zip` varchar(128);
ALTER TABLE `contacts` ADD `city` varchar(128);
ALTER TABLE `contacts` ADD `state` varchar(128);
ALTER TABLE `contacts` ADD `country_code` varchar(128);
ALTER TABLE `contacts` ADD `phone` varchar(128);
ALTER TABLE `contacts` ADD `fax` varchar(128);
ALTER TABLE `contacts` ADD `mobile` varchar(128);
ALTER TABLE `contacts` ADD `birthday` varchar(10);
ALTER TABLE `contacts` ADD `anniversary` varchar(10);
ALTER TABLE `contacts` ADD `gender` int(1);
ALTER TABLE `contacts` ADD `additional_information` longtext;
ALTER TABLE `identities` ADD `password` text;

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #10 on: March 01, 2008, 02:01:21 AM »
Thanks for the DB update code.

Did the stuff work for you? If you are a PHP coder, are you interested in joining MyRoundCube project?

-Roland

Quote
Quote from: ZabbensX on January 23, 2008, 01:44:04 pm
The Vacation and Forward Tab uses the COM interface from the hmailserver,
so you have to enable com in you php.ini
Too bad, then, as the php com extensions are only available to winDOZE users

P.S.: You can run the Remote Administration section (Folder PHPWebadmin) on the host where hMailServer resides. RoundCube can run on a different host. So my modifications will still work for Linux RC setups because I do not use the Windows hMailServer COM API.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline giuseppe

  • Newbie
  • *
  • Posts: 7
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #11 on: March 01, 2008, 05:45:35 PM »
Yep, the code worked for me except the email verification. When I click on the "Verify now" button, an error stating "Failed to send message" appears at the top of the page. I checked the rc logs but couldn't find a full description of the error.

I am not much of a PHP developer. My PHP knowledge doesn't go much further than tweaking code. I would be more than happy to help you test and tweak the features of your project. I can also help with documentation.

Thanks,
Joe

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #12 on: March 02, 2008, 02:21:58 AM »
I'm going to fly to Tenerife ... I'll contact you as soon as I'm back. I hate documentation and would be glad if you help.

Regarding the error:

Make sure that you have defined an appropriate user/password in the config file!

-Roland
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline kevinb

  • Newbie
  • *
  • Posts: 2
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #13 on: March 02, 2008, 02:35:36 PM »
Just downloaded Roland's mods and installed and ran the update script posted for the DB structure, however when I run RC, after logging in properly, it displays tons of error messages on the screen, all pertaining to inserting message information, ie: to address, from address, subject, etc, into a table in the RC database called "messages", however I do not have that in my DB and the update script posted does not create or reference that table either. Does anyone have the layout for it so I can see if that fixes my problem? TIA all.

Kevin

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Re: Vacation Assistent, Forward Tab, Password Tab - hMailserver
« Reply #14 on: March 04, 2008, 12:07:32 PM »
Kevin,

Greetings from Tenerife :) Are you sure to have RC DB structure from RC2 ?

I have modified these tables:

* identities (new col password)
* accesscontrol (completely new)
* contacts (a lot of new cols)

Table messages was not modified ...

-Roland
Regards,
Rosali
__________________
MyRoundcube Project (commercial)