Author Topic: DB Error: [1305] FUNCTION hmailserver1.update_passwd does not exist  (Read 6529 times)

Offline SorenR

  • Jr. Member
  • **
  • Posts: 13
Re: DB Error: [1305] FUNCTION hmailserver1.update_passwd does not exist
« Reply #15 on: July 05, 2015, 01:12:26 PM »
And right back to this.
This seems like it should not be that hard

[05-Jul-2015 02:48:16 +0000]: <0tg734bd> Plugin password (hmail driver): Failed to create COM object `hMailServer.Application': Access is denied.
[05-Jul-2015 02:48:16 +0000]: <0tg734bd> Plugin password (hmail driver): This problem is often caused by DCOM permissions not being set.
It's not...

If you run IIS/Apache on the same server as hMailServer just set the DCOM permissions for your webserver and...
Code: [Select]
// hMail Driver options
// -----------------------
// Remote hMailServer configuration
// true:  HMailserver is on a remote box (php.ini: com.allow_dcom = true)
// false: Hmailserver is on same box as PHP
$config['hmailserver_remote_dcom'] = false; // ==> FALSE <==
// Windows credentials
$config['hmailserver_server'] = array(
    'Server' => 'not-important', // hostname or ip address
    'Username' => 'not-important', // windows username
    'Password' => 'not-important' // windows user password
);

If you have IIS/Apache on a different box from hMailServer you need to set DCOM permissions for a different user and...
Code: [Select]
// hMail Driver options
// -----------------------
// Remote hMailServer configuration
// true:  HMailserver is on a remote box (php.ini: com.allow_dcom = true)
// false: Hmailserver is on same box as PHP
$config['hmailserver_remote_dcom'] = true; // ==> TRUE <==
// Windows credentials
$config['hmailserver_server'] = array(
    'Server' => 'mail.mailserver.com', // hostname or ip address
    'Username' => 'user-with-dcom-permission', // windows username
    'Password' => 'password' // windows user password
);

Offline wallst001

  • Jr. Member
  • **
  • Posts: 12
Re: DB Error: [1305] FUNCTION hmailserver1.update_passwd does not exist
« Reply #16 on: July 05, 2015, 02:55:29 PM »
Nope, unless I am missing something
Everything is on the VPS


// hMail Driver options
// -----------------------
// Remote hMailServer configuration
// true:  HMailserver is on a remote box (php.ini: com.allow_dcom = true)
// false: Hmailserver is on same box as PHP
$config['hmailserver_remote_dcom'] = false;
// Windows credentials
$config['hmailserver_server'] = array(
    'Server' => 'localhost', // hostname or ip address
    'Username' => 'Administrator', // windows username
    'Password' => 'xxxxxxxxxx' // windows user password
);

[05-Jul-2015 18:46:21 +0000]: <arr7des4> Plugin password (hmail driver): Failed to create COM object `hMailServer.Application': Access is denied.
[05-Jul-2015 18:46:21 +0000]: <arr7des4> Plugin password (hmail driver): This problem is often caused by DCOM permissions not being set.

com_dotnet

COM support   enabled
DCOM support   enabled
.Net support   enabled


DCOM config allowed: Local Launch & Local Activation
CREATOR OWNER
local account
SYSTEM
Administrator(S18384471)
Administrators(S18384471)
Users(S18374471\users)
IIS_IUSRS(s18384471\IIS_Iusrs
INTERACTIVE

What the F am I missing???

Im in into this project for a good sum of $$ and this is the biggest hurdle...so frustrating that you google this and everyone has a way different solution on how they got theirs to work.



« Last Edit: July 05, 2015, 03:11:56 PM by wallst001 »

Offline SorenR

  • Jr. Member
  • **
  • Posts: 13
Re: DB Error: [1305] FUNCTION hmailserver1.update_passwd does not exist
« Reply #17 on: July 05, 2015, 05:00:35 PM »
What the F am I missing???

Im in into this project for a good sum of $$ and this is the biggest hurdle...so frustrating that you google this and everyone has a way different solution on how they got theirs to work.
Perhaps "everyone" have their own way, but the ONLY supported solution for hMailServer is COM/DCOM, whether you like it or not.

Now get your ar** over to https://www.hmailserver.com/forum/ ... This is like trying fix an engine fault while at the tyre shop; Everyone but yourself is a silent bystander.

... And by the way ... I use the same username (SorenR) over there.