mariadb mysql stored udf wrong error message

i just wasted 12 hours chasing an error in stored function on mariadb
select sugarcrm.canstart('10.8.0.99') as "val";
ERROR 1054 (42S22): Unknown column 'fixedip' in 'field list'
the error " Unknown column 'fixedip' in 'field list" was not related to any table I was referencing in my udf. turns out it is referring to a parameter name in the udf
i am setting a user variable like this:
 SET @fixedip := fixedip; the error is that my parameter name is ipadr and not fixedip! I am pissed that I was mislead into thinking this was a column in a table i was querrying or inserting into  

very annoying😞!!!

sugarcrm and selinux

selinux prevents the httpd server(apache from sending emails or connecting to a remote database unless permission is explicitly granted by setting boo leans as follows.

1. to send emails  usng the httpd server using php mail()which sugar does 
2. set httpd_can_sendmail must be set to tru using the :setsebool command
3. like this "setsebool -P httpd_can_sendmail 1"
4. to connect to a remote mysql instance not at local host you must set the httpd_can_network_connect_db boolean like
5. setsebool -P  httpd_can_network_connect_db 1

Starting to Blog about technology

I have been working in the technology field since 1983. The last 7 of these 27 years has been like the first 7, exciting; the time spent learning and leveraging all that's new and available in the Open Source world. At the end of 2009 I made a decision to write about the available technologies and how I have leveraged these tools to support business process' for various enterprises; schools, Government entities and commercial organizations.

My approach will be to address both the executive viewers of this newsletter who may need guidance in how to leverage these tools and the consequential impact on the bottom line and the techies that may be interested in practical how to's. My knowledge of FOSS tools is fairly wide and diverse and include:

• Asterisk PBX
• SugarCRM
• Pentaho BI
• Drupal CMS
• Sendmail
• Request Tracker (RT) trouble ticketing
• OpenVPN
• OpenOffice
• MySql
• PostgreSQL
• Apache
• Squid Proxy Server
• Qemu Virtual Computing
• Various programing languages (Perl, PHP, Java, Shell scripting)
• Gimp
• Nagios
• Freemind - a mind mapping tool that is the best tool I have used to organize my thoughts and develop an action plan.
  

and several other tools from the linux OS that I have used to support various platforms inhouse and those of my clients from various outsourced sysadmin projects.

With this introduction out of the way I will tease my first project - the Asterisk PBX. I have used this application to implement a call center platform for a large travel agency consisting of 23 offices located in 5 countries. This has been an on going project that has allowed the agency to leverage voip technologies to significantly enhance the efficiency of their agents as well as improve customer service. Part I of this series will discuss the objectives and strategy employed leading to this deployment - the exec piece of this post - and will be delivered this month.