L3Y

Just saw if i truncate the pricing table then i am able to delete and modify the product prices. Here is how our pricing table looks like : INSERT INTO `pricings` (`id`, `company_id`, `term`, `period`, `price`, `setup_fee`, `cancel_fee`, `currency`) VALUES (1, 1, 1, 'month', 159.0000, 0.0000, 0.0000, 'CAD'), (2, 1, 1, 'month', 141.8300, 0.0000, 0.0000, 'USD'), (3, 1, 1, 'month', 112.0400, 0.0000, 0.0000, 'EUR'), (4, 1, 1, 'month', 144.9900, 0.0000, 0.0000, 'CAD'), (5, 1, 1, 'month', 219.0000, 0.0000, 0.0000, 'CAD'), (6, 1, 1, 'month', 195.3600, 0.0000, 0.0000, 'USD'), (7, 1, 1, 'month', 154.3200, 0.0000, 0.0000, 'EUR'), (8, 1, 1, 'month', 259.0000, 0.0000, 0.0000, 'CAD'), (9, 1, 1, 'month', 231.0400, 0.0000, 0.0000, 'USD'), (10, 1, 1, 'month', 182.5100, 0.0000, 0.0000, 'EUR'), (11, 1, 1, 'month', 245.0000, 0.0000, 0.0000, 'CAD') [...] I can't figure out what's wrong in it... It work now, but we need to re-configure our prices manually....

Hi, I'm getting this error if i try to delete price row for a domain extension in a package. I imported from WHM** and now this happen while editing / deleting our domain prices : "Currency code must be 3 characters." Why exactly? The currency is set and i checked the db : it's all 3 characters, everywhere there is a currency field. The currency is set correctly in the Blesta admin. See attachment for the error, and our currency settings. thank you, Carl

I think the whm** import tool require an update to work with the OpenSRS module

Oh! don't forget if you exclude something, sometimes it can means the script is vulnerable. Care should be taken ...and NEVER disable a rule by commenting. Only add whitelists.

Hi, I know this is an old question, but... ..here is a new answer In order to use NAXSI with Blesta : 1) restric your server to your own ip - important while you are in learning mode 2) enable NAXSI in Learning mode 3) run this to create your whitelist rules : mv /var/log/nginx/error.log /var/log/nginx/error.log-bak touch /var/log/nginx/error.log mv /var/log/nginx/access.log /var/log/nginx/access.log-bak touch /var/log/nginx/access.log wget https://naxsi.googlecode.com/files/nx_util-1.0.tgz tar -zxf nx_util-1.0.tgz cd nx_util-1.0/nx_util NOW : BROWSE YOUR BLESTA EVERYWHERE! Go in the admin, and submit all the forms. Do the same in the client area. Try every features. You will generate some logs, in /var/log/nginx/error.log and /var/log/nginx/access.log. We will use these logs to create our whitelist rules : python nx_util.py -c nx_util.conf -l /var/log/nginx/*.log -o You'll get some rules created based on your logs. I suggest to review them first, and then only whitelist the ones you really need. Now add them to your whitelist file, and you are done. Note : Don't forget to comment the line LearningMode; in the file /etc/nginx/naxsi.rules ...and to restart nginx Cheers

Hi, +1 on this We require a GlobalSign module. Thank you, Carl

Sorry about this. Just downloaded the correct importer here and it worked : http://www.blesta.com/forums/index.php?/topic/960-whmcs-migrator-beta-updated-2013-11-12/ There is no bug in it. it's working now, with the latest version. thank you!

Hi, I'm trying to migrate from WHMCS 5.3.10 to Blesta 3.2 Seems like option_pricing_id cannot be nul, but it is in our db importStaff ----------------- importStaff took: 0.2447 seconds ----------------- importClients ----------------- importClients took: 7.1084 seconds ----------------- importContacts ----------------- importContacts took: 0.1203 seconds ----------------- importTaxes ----------------- importTaxes took: 0.0021 seconds ----------------- importCurrencies ----------------- importCurrencies took: 0.0037 seconds ----------------- importInvoices ----------------- importInvoices took: 9.0035 seconds ----------------- importTransactions ----------------- importTransactions took: 30.7386 seconds ----------------- importPackages ----------------- importPackages took: 1.6567 seconds ----------------- importPackageOptions ----------------- importPackageOptions took: 2.8433 seconds ----------------- importServices ----------------- importSupportDepartments ----------------- importSupportTickets ----------------- importMisc ----------------- decrypted 18 values using WHMCS' custom algorithm decrypt took: 0.0015 seconds total time took: 54.4234 seconds Array ( [error] => Array ( [0] => The import completed but the following errors ocurred: [1] => importServices: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'option_pricing_id' cannot be null on line 124 [2] => importSupportDepartments: There is already an active transaction on line 163 [3] => importSupportTickets: There is already an active transaction on line 163 [4] => importMisc: There is already an active transaction on line 163 ) ) cheers

Hourrah The Virtualizor module is now available on Blesta : http://www.virtualizor.com/wiki/Blesta_Module Public and Private "Cloud alike" : Love it They are apparently working on HA also. with a couple of modifications to the plugin (i.e. : send email upon action) it rocks! But, i still require OpenSRS : i wouldn't change this provider at all. Will be waiting for some good news on this. ...but when it comes available, i'll purchase Blesta 4 sure

Two other things are missing i can see : GlobalSign OpenSRS We cannot really move without OpenSRS. we have too many domains with them thank you Carl

Thank you. I'll email him right away.

Hi, We have a bug in our whmcs. ...we cannot use it anymore, and whmcs support don't know what to do to fix this, so they ask us to wait since 3 weeks for a manager who never replied to our ticket. It's no longer a good solution for us, and we would like to migrate to Blesta. But if we migrate to Blesta, we will loose theses features, and cannot live without. We require : - Interac online (we are using http://internetsecure.com but we may change our provider if required. The InternetSecure module for whmcs we have is unencrypted and hold i a single file (less than 100 lines). I assume it wouldn't take more than a couple of hours to convert this into a Blesta module). - Virtualizor Module (makes a while it's supposed to be available, as per your forum - any news?) Is there any beta versions of Virtualizor/Interac modules we can start using right now? How can i continue to accept Interac payments? Most of our clients enjoy the fact they can pay using their debit card. Thank you, Carl