Connection errors from WordPress to Azure MySQL database

Issue: You are getting connection issues to your hosted Azure MySQL database server. You are putting the correct information in, but still WordPress is showing Error Connecting to Database. Error: After some investigation, you most likely are getting this error: mysqli_real_connect(): (HY000/9002): SSL connection is required. Please specify SSL options and retry Resolution: Believe it Read more about Connection errors from WordPress to Azure MySQL database[…]

Centos 7 and firewalld to allow SNMP

We need to add a profile for SNMP to use UDP 161.  Edit /etc/firewalld/services/snmp.xml <?xml version=”1.0″ encoding=”utf-8″?> <service> <short>SNMP</short> <description>SNMP protocol</description> <port protocol=”udp” port=”161″/> </service> 2.  Reload the firewall:  firewall-cmd –reload 3.  Add it to the public zone:  firewall-cmd –zone=public –add-service snmp –permanent 4.  Reload the firewall again. It should be working now.  

Postfix outgoing address change

ISSUE:  When you install Postfix, the default outgoing address on that server will be apache@machinename.local. RESOLUTION:  To change the outgoing address or the FROM address from your mailings, make the following changes: edit the /etc/postfix/main.cf file change the mydomain field to your mail domain [mydomain = mydomain.com] Add the following text to the bottom of Read more about Postfix outgoing address change[…]

CentOS cheatsheet

Add user to group:  useradd -G <groupname> <username> Change password:  passwd <username> Allow sudo access: visudo Server Hostname:  /etc/hosts, /etc/sysconfig/network PostgreSQL: yum install postgresql-server postgresql-cli service postgresql initdb chkconfig postgresql on /var/lib/pgsql/data/pg_hba.conf (add “host all all 127.0.0.1/32 trust” near bottom of page) service postgresql start yum commands:   remove install list <package>* list installed | Read more about CentOS cheatsheet[…]

Migrate WordPress.com site

Issue:  Client wanted to migrate their WordPress.com site and retain full functionality in a WordPress.org site. Long/Short:  This is not possible to do, as the WordPress.com sites have built-in features exclusive to only WordPress’ own hosting platform.  Note in the article that you can only use Tools/Export to an XML file (or, of course, pay Read more about Migrate WordPress.com site[…]