tallship

I Held off for some time before moving to WHMCS 7.5 due to the OpenSRS Domains Pro module being listed in the Marketplace as being supported through WHMCS 7.1. PHP 7 and GDPR considerations warranted the upgrade to WHMCS 7.5 in our case. I tested with my devel license a while back and used the Tucows' Horizon (testbed) server, and it seemed to work fine for new registrations, transfers, contact updates, etc. In our live environment it seems to be working fine on 7.5, but after calling them a little while ago they still were unable to provide me with any sort of timeline for their update roadmap. I know a lot of folks have migrated to enom, and it's attractive, but domain registration services on its own isn't our main business product, but rather, as an adjunct to other services we provide where the user may need to register a domain for other services they are setting up with us. I've read the latest reviews where it seems that a few people have had to tweak things a bit, including to fix a breakage when supporting IPv6. Other than that, what have most people experienced with this module when running on WHMCS 7.6? Generally speaking, is this module running fine for most people? Is there a small support group of folks choosing to support this module on the latest WHMCS version with code snippets for fixes, etc? I really don't want to move to enom for the majority of our gTLD services, but I don't want to disenfranchise my customer base by breakages in the OpenSRS module either. Thanks, and I look forward to your thoughts and suggestions.

I'm interested in using security questions (available at for customer verification over the phone for account and technical support. This appears to be implemented in a general way at: "Setup" ==> "Other" ==> "Security Questions", but if that is implemented, it also requires the user to answer their security question everytime they do a password reset for lost/forgotten password or when they want to change their password. I don't want to implement security questions for password changes or recovery, but I do wish to use them for customer verification when providing support for incoming callers over the telephone. Is there some way to have them choose a security question during registration but only have it available for the customer support rep to use for verification purposes over the phone? What would really be nice is to have a one time PIN that they can generate by signing into their account that we can verify over the phone, but I'm not aware of such a feature in WHMCS. Comments, suggestions?

The more I read the less I think I understand about the requirements particular to hosting and IT providers. Do hosting providers running WHMCS need to register and [more than likely] pay ICO a data protection fee? From the checklist located here: https://ico.org.uk/for-organisations/resources-and-support/data-protection-self-assessment/controllers-checklist/ And here's the specific language: Aside from this, What we've done so far is to enable the opt-in/opt-out capabilities in WHMCS 7.5, and we're preparing to add a couple of items to our privacy policy and terms of service related to: The ability to opt-in and opt out of marketing emails at will, by the customer. The ability to have all user data deleted, as per the GDPR, with the proviso that such a request amounts to a request for immediate cancellation request of all services, due to the inability to connect to, or manage any services once the user account has been removed. Much of what appears to be required flies in the face of requirements elsewhere for us to retain data for the purposes of income taxes, receipts, invoices, etc. There's just no way to delete the majority of a customer's information without also removing the ability to comply with US tax codes pertaining to the retention of receipts and transactions which is required for documenting taxable income, deductions, etc. Does someone have just a few simple things we need, as a standard hosting company, to implement in this regard?

Thanks John! Heard back from Lawrence and he passed on that info. Whatever the charges and suspensions were about were certainly on my end, and I'm looking forward to fixing those issues and eating crow with the customers as soon as I can access the admin login. Once again, thank you so much for your assistance in this matter, as well as your team! Kindest regards, Bradley

Not a dispute. Some kind of fubar in the client center's licensing module or something. I dunno. I just woke up, and did receive a response saying that the subscription has been fixed but for some reason I still can't login. I guess the support team is working on it now. Judging by the emails I've received, it's only a some sites of clients, but I've received some phone calls about having charged some people, which I'll need to reverse or credit accounts, and none of that is something I wouldn't be able to attend to if I could just get past that licensing error page. Customers can login, and do their thing, I just can't attend to administrative matters. This is really nerve racking.

I purchased a six month subscription for services and updates for days ago in preparation for GPDR. After downloading WHMCS 7.5.1, and upgrading to the latest versions of PHP, IonCube, and MariaDB, I upgraded to the latest version of WHMCS, and it got botched, so I opened trouble ticket #KXY-687063 Joshua Stanford, Technical Analyst I, tended to my support request. I've responded to that ticket several times with no further response, and finally, after thinking that I successfully completed the upgrade, I get this message: I've been a WHMCS customer since February 2012, more than six years. It was bad enough that you ignored me after I botched my upgrade the day after I purchased my six month support plan, but you left me hanging without a word for two more days and then I find out you've erased my purchase transaction from your system - ( I HAVE MY RECEIPTS AND BANK STATEMENTS!!! ) But to make things worse... now that my install has finished ALL of my customer's cPanel sites were ceremoniously autosuspended a few minutes ago because of this!!! Imagine this - you complete the upgrade for something you have paid for and HUNDREDS OF YOUR HOSTING CUSTOMERS HAVE THEIR SITES TURNED OFF in a matter of seconds!!!! I don't know what Joshua Stanford did, or why, but I want it fixed ASAP. As respectfully as I am able to ask, and boy..... I'm really biting my tongue here, please repair my account and place it back in good standing. Regards, Bradley D. Thornton

Okay I see what was meant by "slab pricing" now. This is good for folks that will use the resellerclub interface, and in WHMCS I suppose that a slab pricing model for say, gsuite that is paid annually or quarterly could work well, but since we can take the money up from for the annual payment, for example, and our reseller account would be prepaid anyway, resellerclub would just take from our credit as time goes by and we could set up separate order options in the order page in WHMCS and specify when our customer is to be invoiced again.

Hi Chris, So I can use the integration with the free account I've had with you for years now too, right? And the the "More Details" button at the link above just goes back to that same link (https://www.whmcs.com/partners/resellerclub), so I'm not sure what other lower price benefits we get from using the WHMCS version (https://freeaccount.myorderbox.com/reseller) verses the direct resellerclub version (https://manage.resellerclub.com/reseller/). I'm unable to login to my free WHMCS resellerclub account at: https://whmcs.resellerclub.com, even though I can login to the other two URLs above. Is this URL no longer a valid portal entrance? Apologies, but it's been years since I've tried to login there (and things do change). Finally,I want to integrate with the "FREE ResellerClub Tools v2" module from the marketplace here: https://marketplace.whmcs.com/product/534. to be clear, I should be able to use either of my accounts (the WHMCS free resellerclub account or the direct one I have with them, but be able to enjoy additional wholesale savings if I use my WHMCS Free resellerclub account? i.e., I'll enjoy additional cost savings over that of the regular resellerclub reseller account that I have? @resellerclub, Thank you for the clarification I'm not sure what is meant by slab based pricing. Can you explain? I'm trying to decide which of my two accounts to integrate into my WHMCS. Thanks!

Brian! Thank you! Exactly what I was looking for! Worked like a charm.

Hello, I looked on the forums and found only two posts dating back to 2009 or so related to how I can change the default autoincrement number for the next quote that I create. Those two old threads are located HERE and HERE For whatever reason, in only one of those threads, two tables were mentioned, but I don't wish to break anything on my production system and no instructions were actually offered by any of the respondents, although there were people replying with off-topic suggestions such as, "...why don't you do this because..." - which weren't helpful at all to the OPs of those topics, or me - as the licensee and operator of my own billing system, I know what reasons I have for wishing to start my quote numbers at a higher number than say, "1". To be clear, the current quote number is '8', the next one sent out will appear to the customer as '9', and I want to change the next quote number to, for example, 1024. Here's what my database looks like at the moment: MariaDB [db666]> select id,quoteid from tblquoteitems; +----+---------+ | id | quoteid | +----+---------+ | 1 | 3 | | 2 | 3 | | 3 | 4 | | 4 | 4 | | 5 | 4 | | 6 | 5 | | 7 | 5 | | 8 | 6 | | 9 | 6 | | 10 | 7 | | 11 | 7 | | 12 | 8 | | 13 | 8 | +----+---------+ 13 rows in set (0.00 sec) MariaDB [db666]> select id from tblquotes; +----+ | id | +----+ | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | +----+ 6 rows in set (0.00 sec) I would prefer to just have an insert or update statement I could use in the mysql cli, for example, changing the next quote number to '123456' instead of '9', but instructions for PhpMyAdmin will do I suppose (I would prefer to just do the update or insert and be done with it forever instead of having to install PhpMyAdmin). Do I need to update or insert into one or both of the tables above, and are there other considerations I need to make with regards to other tables in the database? Also, if you have a handy insert or update statement for me to just change the latest id and/or quoteid I can basically cut and paste that would be great! (Yes of course I'll do a mysqldump prior to testing Thanks, in advance, for any assistance you can provide!

Hey there everyone, I stumbled across a thread over at ReliableSite's forum concerning their dedicated server module taking forever to load. I had some discussions with a few WHMCS operators who had tried the module after setting themselves up as resellers but were disappointed that the order pages took forever to load. I didn't experience this myself, but then I've been running UNIX machines and database servers since dirt was invented, so when someone reached out to me with their woes on the matter, the first place I went and looked was at their database config. Over the years I've come to realize that well over 90% of people just turn MySQL, MariaDB, or PostgreSQL on and figure that's all they need to do to rock Gibralter with speed and elegance where their dynamic, database driven sites are concerned. We've all run across those people with a kazillion WordPress modules installed and chuckled at those excrutiating load times, before telling the customer to just, "remove all of the modules that you aren't using!" Well, that's certainly true but there's things under the hood of your UNIX machine that you can do to alleviate many of the issues that even serial module installers experience. Back to ReliableSite's WHMCS Dedicated Server Module. I did witness this little puppy taking forever to load order pages on someone's install and assured them that there's a simple fix that they should have implemented long before they ever installed any software on their webservers. So without further ado, here's a reprint of that post I made on their forums, in the form of a cookbook tutorial for those who don't wish to simply visit the original post for the particulars: http://support.reliablesite.net/community/a47/whmcs-inventory-module-slow-loading.aspx#137 <snip> Since the question was answered, but no real solutions were offered in the form of example configs, I thought that I would offer my two cent worth here: The issue of the long load time is mitigated by the use of cache. One must be careful not to bring their database server to a crawl by setting unrealistic levels of cache - this isn't something that you just throw a couple of gigs, or even hundreds of MegaBytes at - think about how large your entire database is, and then upon realizing that the size of the query is rather small, proceed accordingly. Be conservative (start small and work your way up, even 10MBytes makes a *HUGE* difference in performance, so don't think you need a 500M cache okay?). Here's what my /etc/my.cnf.d/server.cnf looks like, for the applicable entries on MariaDB 10.x: sql_mode="" query_cache_size = 16M query_cache_type=1 query_cache_limit=1M query_cache_min_res_unit = 2k Bear in mind that even 16MBytes for cache may be waaaay more than you need. The "sql_mode" entry isn't required on MariaDB because it's already enabled by default, so it's just there for good measure and to remind me of such. Now, here's the important part. after you put this into the appropriate my.cnf file for your particular Linux distro or UNIX variant, restart your database server: In one console window do the following: tail -f /var/lib/mysql/<hostname>.err In another console, restart mysqld and watch for errors in the console where you're following the error log: /etc/rc.d/rc.mysqld restart If everything is good, then let's check: mysql -uroot -p MariaDB [(none)]> show status like 'Qcache%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_free_blocks | 2 | | Qcache_free_memory | 16720008 | | Qcache_hits | 89 | | Qcache_inserts | 43 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 4 | | Qcache_queries_in_cache | 19 | | Qcache_total_blocks | 54 | +-------------------------+----------+ 8 rows in set (0.00 sec) Kewl!!! Now let's hit your page in a browser. Yes, the first query is going to be long enough for the page to render that 30 people could have lost interest thinking you're running a boyscout server and left you forever, but then go back to the home page and then hit the dedicated server product page again... BOOM! Fricken' lightning! Pretty kewl, huh? Now, this is important, so don't forget this part. During the time when you run your cronjob to update the inventory, the very first time someone hits your dedicated server product page, they're going to have to wait for that 30 seconds or so (One person said over two minutes), so make sure that you also include a curl or wget of that URL *After* the inventory update runs as part of that cronjob. This way, the first time anyone hits the page it will render at breakneck speed. Not only that, but even with the modest cache settings I've included here as an example, your entire WHMCS install should fly on the second hit of any dynamic page that hasn't been updated or changed after the first HTTP request for it. You can take this even further if you like, with memcached or redis and/or varnish, etc., but transparent reverse proxies and other concepts of load balancing are beyond the scope of my little tutorial here. One final note - if you simply cut and paste commands you're going to get lost because, as I said, make sure the commands and file locations are specific to your particular Linux distro or UNIX variant - if you don't know your way around the CLI or understand where your files are and how to start and stop services on your box, then you may want to consider hiring out for the task - you can break it if you don't know what your doing, and although it's an easy fix, you should understand a lot more than just how to point and click in cPanel . I hope that helps, and I'm interested to hear what people have to say about the huge performance boost you're now going to realize. Enjoy, </snip> Well like I said in the post in their support forums, I hope that helps!

Yes that is correct I would really like to say that I like that system, but when one considers that you can't trust the weekly updates from the (one single) developer to not break some aspect of the install... We used to draw straws to see who would be the first to update their system and elbow check it for major bugs before giving the all clear sign and telling everyone else it appeared safe to update their systems. Last time I looked over there, I believe that there is still a weekly report on the new updates. I remember once when he pushed out an update and everyone's ticket imports broke - for about five days!!! Yeah, that guy could do so much more if he just opened it up for 3rd party developers and actually, well, I don't think even modulesgarden has anything supporting that platform anymore. It was just too fricken' scary, not knowing whether he would go off his meds and take down the license servers on a whim. Besides, WHMCS has matured into a great platform for the management and orchestration of virtualization (so much more than just SolusVM available now), and they've never charged anyone a hundred bucks for a pre-sales question either lolz. Sad, because he's a really talented developer too. Well enough accolades for WHMCS here, it's kinda like preachin' to the choir I'm actually a cli kinda guy and would never consider installing something as comprehensive as WHMCS under a cPanel server for myself, although I realize that's how most folks do it, and will. so openssh is the client I use scp almost exclusively. That begs the question of how I ended up without some files in the admin dir and all I can come up with is plain old operator error (PEBKAC). The copying over of files again seemed to be the fix, and aside from what I think is a very minor CSS issue in the dashboard where a couple of blocks overlap just a little, the system seems to be running beautifully now. Problems I have to face at this point are dealing with the company logo on the pdf version of invoices being almost as huge as the page itself and other cosmetic adjustments. I think I'm going push an update to 7.1.2 with a full update instead of via patch just for good measure in case I borked somewhere else but all in all I'm soooo happy I didn't choose to go back to that *other* system - I dunno if I'd be able to sleep at night without Valium if I had done that So do we actually know each other from those old forums? If so pm me so we can catch up, coz I have been wanting to connect again with some of the other brave souls with whom I shared those trauma filled days of uncertainty with lolz. And BTW, I still have my original first three editions of Yggdrasil LGX on my bookshelf, prominently displayed, as well as hard copies of the first two editions of the "Linux Bible, GNU Testament" published by them. Back when I still used Faceplant I know I had actually friended Adam (the creator/maintainer of that distro) and did some devel work on the Arena browser when it was the only alternative to Mosaic. Thanks for all of the support and suggestions, you have a wonderful St. Paddy's day, and don't consume any scrambled green eggs or too much green beer! Kindest regards, Bradley .

Wow, ChrisD thank you so much. Everything appeared to be working fine but now there's actually a whole new look, the modulequeue works, the create new order can be populated with a partial search of the client name, and when I check a box in domain pricing the fields present themselves for population of prices. There's a fresh new apppearance with other items in the dashboard, and what was there before has a complete facelift too. Again, thank you very much and yes, after checking through all of your suggestions it was all taken care of by copying over the admin dir again, although I'm still scratching my head as to how all of it didn't get there in the first place, and why there was some limited functionality (for a while) in the domain pricing area. Suffice it to say it's all better now. I'm running MariaDB 10, but entered in sql_mode="" into /etc/my.cnf.d/server.cnf for good measure anyway, and there are still some suggestions in "Help ==> System Health Status" that I'm considering, such as xmlrpc and the like. So one more time, thanks Chris!

I've created a quick screencast video to illustrate the problem I'm experiencing (Less than two minutes), which is available here: http://screencast-o-matic.com/watch/cbeDVz6BCK Okay here's the synopsis on our 7.1.1 installation... 1.) Setup ==> Products/Services ==> Domain Pricing: As shown in the video, there aren't any boxes to add pricing info for a couple of TLDs, nor for additional yr pricing on others. Having issues where there are no pricing option dialog boxes in order to deploy domain pricing levels, in some cases even for a single year (exhibited where I added a TLD - there weren't any boxes to enter pricing info at all). The following screenies demonstrate what is being displayed in that regard: 2.) Orders ==> Add New Order: Also in the video, The client picker list from the drop down is empty, rendering me incapable of creating a new order this way. Now, I can still Open a client's account info and create a new order from there, and that auto-populates the field with that particular client's info, but not from "Orders ==> Add New Order", which is effectively useless if you can't attach that order to a client. 3.) "WHMCS Cron Job Activity" email: Has, as listed in the link below, This daily in my inbox also includes "4 Pending Module Actions in Queue. Go to Module Queue »" at the bottom of the email, but when I click on the link I get a 404, as seen in the following screenie: i.e., when clicking on the link (redacted - https://whmcsinstall.sld.tld/admin_dir/modulequeue.php) it results in a 404 error. ---------------------------------------------- Permissions and Ownership: Each user on the system is a member of the group 'users', instead of being members of a unique group matching their own particular username: i.e. username groupname ________ _________ jschmoe users So what we have currently with file and directory ownership is: username:apache #(i.e., jschmoe:apache) since Apache runs as the username 'apache'. This is standard for the distro (Slackware) that the system is running on, as opposed to what a CentOS box would look like: i.e, username groupname ________ _________ jschmoe jschmoe During installation care was taken to make sure that sane permissions were granted and the additional security recommendations were followed - such as placing certain directories outside of the DocumentRoot and specifying this in the config files. But all crons run seamlessly with no errors found, including ticket imports into departments, invoicing, escalations, etc., and this appears to be some sort of issue pulling data from the database to me. Perhaps some select statements aren't running or there's a permission issue in some templates that I haven't uncovered by double checking file/dir permissions as per the docs? And the 404 error has me a bit perplexed too, making me wonder if some of the other problems are somehow related to that. Thanks in advance for any advice and suggestions you may have, and I'll be happy to provide any additional information that might assist in uncovering these issues. .

Thank you for that assessment @liz926 A little sparse, but nevertheless worhtwhile receiving. Without looking at anything else, yours comes w/a 15 day trial, and if I like it, the price is reasonable, so there's certainly no harm in kicking the tires and taking it for a drive to make an informed decision. I just hope that I can trial the WHMCS in-house version too so I can make a decent comparison. If anyone else has specific input as to the differences in feature set etc., it would be greatly appreciated. Some things that are important to us are: Realtime time tracker - we like to set a timer and stop/start tasks as we work on them Ability to share some/all/none of the details of projects with customers Sub-task delegation to various project members and/or the customer Some sort of conversion, inclusion method into invoices pertaining to projects If anyone does have extra input to add regarding this module (Yes I have read the information about this module) I'm quite interested in knowing what you find most interesting and promising about adopting this module. Kindest regards,