Category: Code or Hosting

  • Granting MySQL Permissions and Deleting them

    Granting permissions in MySQL, localhost and external hosts must be separately run, the % sign means any external host and will not account for local connections: GRANT ALL PRIVILEGES ON *.* TO root@”localhost” IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON *.* TO root@”%” IDENTIFIED BY ‘password’; FLUSH PRIVILEGES; But say you wanted to then remove…

  • Solved iMessages Txt Msgs Coming From Email Address

    To correct the issue, on the iPhone, go to iMessages To check if you have the problem yourself: Go to settings > Messages > Send and Receive Under “You can be reached by iMessage at”, if your phone number is not ticked, you have this problem. To fix (this worked for me): Go to Settings…

  • A Troubleshooters Guide to Process Monitor (ProcMon)

    Process Monitor, by SysInternals under Microsoft, shows real-time file system, Registry and process/thread activity. To do this it registers itself with the Event Tracing for Windows to receive activity reports from both the file system and the windows registry. It can be found here: Windows Sysinternals Process Monitor. Display Overview Some basics of what to…

  • DOS commands for IP

    Below, you’ll find a list of the most common IP commands for Windows and DOS. These include ipconfig, trace route, netstat, arp, route, hostname, control netconnections, and other popular DOS and Windows IP commands. ipconfig /all ipconfig /displaydns ipconfig /flushdns ipconfig /release ipconfig /renew ipconfig /registerdns ipconfig /setclassid control netconnections netsetup.cpl ping whatismyip.com tracert netstat…

  • MSSQL Backup all Non System Databases Scripted

    Microsoft SQL Server backups, MSSQL Backup, process Note: You may need to go to Tools > Options > Query Results > SQL Server > Results to Text in the Studio Manager and change the “Maximum number of characters displayed in each column to 1024” (default is 256). Also make sure you are outputting the results…

  • SCP for practical uses

    A basic example: scp filename user@host.com:/path/where/you/want/it SCP The scp command allows you to copy files over ssh connections. This is pretty useful if you want to transport files between computers, for example to backup something. The scp command uses the ssh command and they are very much alike. However, there are some important differences. The…

  • FusionReactor and Forwarded Headers

    In some cases, FusionReactor may be behind a load balancer or CDN, or any other type of proxy that updates the source IP as seen by the server. It helps to see where the requests are actually originating from. For that, FusionReactor has an option for this: http://www.fusion-reactor.com/support/kb/frs-351/ See the Requests>Settings>Proxy, which lets you tell…

  • Installing ColdFusion 11 Under cPanel

    First, you need your installation defaults, find the installer.properties example below: INSTALLER_UI=SILENT SILENT_LICENSE_MODE=full SILENT_SERIAL_NUMBER= SILENT_PREV_SERIAL_NUMBER= SILENT_INSTALLER_TYPE=standalone SILENT_INSTALL_ODBC=false SILENT_INSTALL_JNBRIDGE=false SILENT_INSTALL_ADMIN=false SILENT_INSTALL_SOLR=true SILENT_INSTALL_PDFG=true SILENT_INSTALL_FOLDER=/opt/coldfusion11 SILENT_ENABLE_PROD_SECURE_PROFILE=true SILENT_ENABLE_PROD_DEFAULT_PROFILE=false SILENT_ENABLE_DEV_PROFILE=false SILENT_ADMIN_IP=127.0.0.1 SILENT_JETTY_IP= SILENT_ADMIN_USERNAME=admin SILENT_ADMIN_PASSWORD=Adm1n$12 SILENT_ENABLE_RDS=false SILENT_RDS_PASSWORD=Adm1n$12 SILENT_JETTY_USERNAME=admin SILENT_JETTY_PASSWORD=Adm1n$12 SILENT_CONTEXT_ROOT= SILENT_AUTO_ENABLE_UPDATES=true SILENT_MIGRATE_COLDFUSION=false SILENT_PREV_CF_MIGR_DIR=/opt/coldfusion10 ENABLE_RDS=false ENABLE_WSRP=false ENABLE_JSDEBUG=false ENABLE_CFR=false ENABLE_CFSWF=false ENABLE_CFFORMS=false With this file, you can install ColdFusion 11 with the following: ./ColdFusion_11_WWEJ_linux64.bin…

  • Switching SSLs when on Multiple HTTPS Bindings

    I had to switch out a certificate on a server and got the below error messages, documented here to make this familiar int he future. I was worried that it would break the other sites on the server, 2 others using the old certificate. Instead the server updated the certificate on all 3 and all…

  • ColdFusion 11 init.d script

    I recently installed ColdFusion 11 on RHEL, but the cfinit script did not exist. I then pulled up a ColdFusion 10 init script, updated the CF10-CF11 bits, corrected the coding error for the CFSTATUS section particular to my OS and have the script below: #!/bin/bash # chkconfig: 345 90 14 # description: starts the ColdFusion…