Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #181  
Old 8th December 2014, 12:53
cwispy cwispy is offline
Junior Member
 
Join Date: Sep 2014
Posts: 15
Thanks: 3
Thanked 14 Times in 7 Posts
Default

I have spent quite a bit of time on the error trying to determine where the error is and I have now narrowed it down to the ispconfig module. There is an error in the multiserver logic where it loops through the results to get the server names from the whmcs tblservers.

This is what happens.

The module executes the sql

Query SELECT servergroup FROM tblproducts WHERE id = <productid>

This returns the server group with the ISPConfig servers that you set up in WHMCS.
Next the module runs the query to get the serverid's of all the servers in that group.

Query SELECT serverid FROM tblservergroupsrel WHERE groupid = <groupid>

This query returns an array of server id's. Then the module runs a lookup to get the hostname of each of those servers, except that it
does not use the serverid, it always uses id = 1, which results in the wrong server name being passed to ISPConfig.

In my instance, the server ids on the test server are 2, 3, 4 and 5.

Query SELECT hostname FROM tblservers WHERE id = 1
Query SELECT hostname FROM tblservers WHERE id = 1
Query SELECT hostname FROM tblservers WHERE id = 1
Query SELECT hostname FROM tblservers WHERE id = 1

So it looks like the bug should be pretty simple for the developer to fix and hopefully release an update to very soon.
Reply With Quote
The Following 2 Users Say Thank You to cwispy For This Useful Post:
MasteRTriX (8th December 2014), nokia80 (8th December 2014)
Sponsored Links
  #182  
Old 8th December 2014, 12:56
nokia80 nokia80 is offline
HowtoForge Supporter
 
Join Date: Apr 2009
Posts: 207
Thanks: 47
Thanked 3 Times in 3 Posts
Send a message via Skype™ to nokia80
Default

i have a multi server setup the module always make the mail domein on the wrong server pffff
__________________
You will only see if you get it...
ISPConfig is the future
Reply With Quote
  #183  
Old 8th December 2014, 15:21
Timmy Oblatus Timmy Oblatus is offline
Junior Member
 
Join Date: Nov 2013
Posts: 8
Thanks: 2
Thanked 5 Times in 2 Posts
Default

Nicely spotted!

And yeah, it would probably be rather easy to update this, if the plugin wasn't encoded..

Quote:
Originally Posted by cwispy View Post
I have spent quite a bit of time on the error trying to determine where the error is and I have now narrowed it down to the ispconfig module. There is an error in the multiserver logic where it loops through the results to get the server names from the whmcs tblservers.

This is what happens.

The module executes the sql

Query SELECT servergroup FROM tblproducts WHERE id = <productid>

This returns the server group with the ISPConfig servers that you set up in WHMCS.
Next the module runs the query to get the serverid's of all the servers in that group.

Query SELECT serverid FROM tblservergroupsrel WHERE groupid = <groupid>

This query returns an array of server id's. Then the module runs a lookup to get the hostname of each of those servers, except that it
does not use the serverid, it always uses id = 1, which results in the wrong server name being passed to ISPConfig.

In my instance, the server ids on the test server are 2, 3, 4 and 5.

Query SELECT hostname FROM tblservers WHERE id = 1
Query SELECT hostname FROM tblservers WHERE id = 1
Query SELECT hostname FROM tblservers WHERE id = 1
Query SELECT hostname FROM tblservers WHERE id = 1

So it looks like the bug should be pretty simple for the developer to fix and hopefully release an update to very soon.
Reply With Quote
The Following 2 Users Say Thank You to Timmy Oblatus For This Useful Post:
MasteRTriX (8th December 2014), nokia80 (8th December 2014)
  #184  
Old 8th December 2014, 16:03
cwispy cwispy is offline
Junior Member
 
Join Date: Sep 2014
Posts: 15
Thanks: 3
Thanked 14 Times in 7 Posts
Default

Thanks. I have sent an email to the devs as well pointing them to my post, so hopefully they will fix and release an update for everyone soon.
Reply With Quote
The Following User Says Thank You to cwispy For This Useful Post:
nokia80 (8th December 2014)
  #185  
Old 9th December 2014, 21:23
MasteRTriX MasteRTriX is offline
Member
 
Join Date: Aug 2009
Posts: 33
Thanks: 13
Thanked 4 Times in 4 Posts
Thumbs up

I've been seeing this module for a few years now, it seems that the response time of the developer is always the same (about 3 months). I have a multiserver setup, and didn't buy the module since from what I've read it still doesn't work, and seems it won't. Also the developer doesn't provide neither a demo site or a demo licence.
I hope the developer finds the time to work on this, or at least find someone who will. Maybe he sells the source code of the plugin so one can make it work.

Hope to see happy ending for this.

Last edited by MasteRTriX; 9th December 2014 at 21:26.
Reply With Quote
The Following User Says Thank You to MasteRTriX For This Useful Post:
nokia80 (9th December 2014)
  #186  
Old 10th December 2014, 10:38
cwispy cwispy is offline
Junior Member
 
Join Date: Sep 2014
Posts: 15
Thanks: 3
Thanked 14 Times in 7 Posts
Default

Unfortunately I have not seen a response from the developer either, so at this point, I am looking to rewrite this module.

When I purchased the module initially, I had a brief email conversation with the dev about the issue, and once it seemed to get 'to hard' he just stopped responding to me.

So I would have to warn others from purchasing this module. Your hard earned money would be better spent elsewhere.
Reply With Quote
The Following User Says Thank You to cwispy For This Useful Post:
nokia80 (10th December 2014)
  #187  
Old 11th December 2014, 18:20
cwispy cwispy is offline
Junior Member
 
Join Date: Sep 2014
Posts: 15
Thanks: 3
Thanked 14 Times in 7 Posts
 
Default

I have started a new thread http://www.howtoforge.com/forums/sho...d.php?p=322692 for the new module I started writing a few days ago.
Reply With Quote
The Following User Says Thank You to cwispy For This Useful Post:
loadingjkr (17th December 2014)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What can be wrong martin_rudowicz Installation/Configuration 10 1st December 2014 10:13
Freeradius and Mysql uvstudios HOWTO-Related Questions 4 19th February 2014 13:11
ISPConfig 3 - CentOS 5.4 - SSL Problems!?! owainbaber Installation/Configuration 4 26th July 2011 18:12
ISPConfig3 mail doesn't work Marr General 6 1st September 2010 10:32
subdomain and mail relay configuration aranthorn Installation/Configuration 24 3rd September 2007 23:53


All times are GMT +2. The time now is 07:03.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.