October 29, 2015

PFSense: Bypassing Nat Reflection or Split DNS Using Windows Hosts File

We have a PFSense box, the problem is that it does not resolve WAN Domains on our internal network. What does this mean? For example, our […]
October 28, 2015

BUG: SugarCRM Not Showing Notes on Contact

October 27, 2015

UBUNTU: Change resolution on Virtual Appliance

To show available resolutions # xrandr   To apply resolution # xrandr -s 1360x768   The problem is that it is not permanent upon reboot… A possible […]
October 24, 2015

Networking: Asus RT-N66U Automatic Reboot

I’m using the RT-N66U only as an Access Point as I have a dedicated PF-Sense box as my main Router/Switch. The access point get terribly slow, so I […]
October 23, 2015

MySQL: Assign Opportunities to User based on Parent Account

Query to Select List:   SELECT * FROM opportunities LEFT JOIN accounts_opportunities ON accounts_opportunities.opportunity_id = opportunities.id LEFT JOIN accounts ON accounts_opportunities.account_id = accounts.id WHERE accounts.assigned_user_id = […]
October 23, 2015

MySQL: Assigned Calls to User based on Parent Account or Lead

Select List of Calls to Update: SELECT * FROM calls LEFT JOIN accounts ON calls.parent_id = accounts.id LEFT JOIN leads ON calls.parent_id = leads.id WHERE ( […]
October 22, 2015

MySQL: UPDATE or DELETE with JOIN Operators (Contacts)

Same as previous post but this time with Accounts instead of Leads. List the Contacts related to the Accounts this employee has assigned: SELECT contacts.* FROM accounts […]
October 22, 2015

MySQL: UPDATE or DELETE with JOIN Operators

I’m trying to update some records on Table C (contacts.assigned_used), but I have a Join from Table A (leads) and passing through in intermediary Table C. […]
October 19, 2015

JasperServer: API Configuration