openSUSE Network Setup

Add the default gateway on your Suse Linux System Here we use the route add default gw command. Doing this at the command line dynamically sets the kernels routing table so none local packets are routed to the defined gateway. This won’t survive any reboots. See below on how to make it permanent. But here, … Read more

How large should be mysql innodb_buffer_pool_size?

First – run mysqltuner: ]# ./mysqltuner.pl >> MySQLTuner 1.6.4 – Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '–help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: [–] Skipped version check for MySQLTuner script [OK] Currently running … Read more

Ifconfig Command Not Found In CentOS 7

CentOS 7 minimal systems, use the commands “ip addr” and “ip link” to find the details of a network interface card. To know the statistics use “ip -s link”. To view the details of the network interface cards, enter the following commands: # ip addr To view the statistics of your network interfaces, enter the … Read more

Time stamped bash history logging

Timestamped bash history logging may be a great idea for logging changes. An example would look like this: Mar 28 15:08:26 database root: root@192.168.1.1 [10882]: shutdown -r now [0] Mar 28 15:08:31 database root: root@192.168.1.1 [10882]: cd /var/log [0] This can be done by adding 2 lines to the root .bashrc file or as a … Read more

Change and Update WordPress URLS in Database When Site is Moved to new Host

UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl’, ‘http://www.newurl’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; UPDATE wp_posts SET guid = replace(guid, ‘http://www.oldurl’,’http://www.newurl’); UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.oldurl’, ‘http://www.newurl’); UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://www.oldurl’,’http://www.newurl’); mysql> UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl’, ‘http://www.newurl’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; Query … Read more

Windows 2012 virtual machines using E1000/E1000e driver experience loss of network connectivity

Source: https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2109922 Virtual machine loses network connectivity intermittently In the Windows Event Viewer (Expand Windows Logs and select System), you see entries similar to: Intel(R) 82574L Gigabit Network Connection Network link is disconnected or Intel(R) 82574L Gigabit Network Connection Network link has been established at 1Gbps full duplex This issue would occur in these environments: The … Read more