sandip's blog

Below script replaces non-ascii character with an underscore in file/folder names.

Before running the below script, cd to the folder with files that need renamed first.

Logjam broke Sendmail?

Generate new DH keys file:

Edit sendmail.mc:

Update sendmail.cf and restart:

Refer to https://weakdh.org/sysadmin.html for other service fixes.

If you don't have system level access, and want to clean your oracle schema, the following sql will produce a series of drop statments, which can then be executed. Not all of them will execute - if you drop with cascade, dropping the PK_* indices will fail.

Confirm with:

Purge out the recyclebin if not needed:

1. Server rebooted during lvm snapshot and put volume group in inconsistent state.
   

   # vgs
     VG   #PV #LV #SN Attr   VSize   VFree
     vg0    1   3   0 wz--n- 229.66G 9.66G
     vg1    2   3   0 wz-pn- 279.46G 9.46G
   

   Note the "p" attribute in vg1 which put the group in partial mode.

2. To resolve, I first vgreduce then re-created the volume group from a good known archive:

Below is a summary of steps taken to get memcache support for php:

1. Install memcached and php-pear for pecl support to download and compile memcache for php.

2. Configure memcached (/etc/sysconfig/memcached) and start it up:

3. Create /etc/php.d/memcache.ini file with the below contents:

4. Reload apache and/or php-fpm processes:

5. Check with "php -i" or "phpinfo()" that memcache support is enabled.

6. Memcached listens to port 11211 by default. Status and stats:

To run, give the script the file name as argument:

Test the file via xxd, if the mark is present, the first line should output as below:

I've had to do mysql database restores based on lvm snapshot backups, one too many times... from damaging sql statements. So here is some notes from the last one for future reference:

* Prior to restore, make sure no writes are coming to the corresponding db schema.

* Restore the database schema from the daily archived snapshot:

Note: The above process is for database schema with MyISAM tables only, so just restoring the corresponding db folder was sufficient.

The snapshot.log file has the status of the master/slave replicated positions shown via "show master status\G" and "show slave status\G". Additionally, I also pipe in the file sizes of the mysql bin logs at the time the lvm snapshot was taken.

Once the database has been restored from the daily snapshot archive, begin restoring from the binary logs to bring the data up to date.

* Extract from bin log using position recorded in the snapshot.log file:

* Edit the db1.sql file and remove the unwanted transaction.

Note: If you do not have exact positions, you could playback the logs with an approximate start and end date in the below format:

* However, If duplicate error occurs, change "INSERT" to "INSERT IGNORE" or "REPLACE" to overwrite:

* Check to make sure that no other database schema is being used, if found you will have to remove those lines as well if playing back just a single schema:

* Run import:

With that import, the datbase schema should be caught up and restored back to it's current state with the unwanted transaction/s removed.

Go to VirtualBox Preferences and under "Network", add host-only network. This will add a new vboxnet0 interface, which comes up as "192.168.56.1/24"

In the Guest Settings, add the "Host-only" to a second "Network Adapter"

Once Guest boots up, assign a static IP to the second adapter.

For Debian based servers, edit /etc/network/interfaces and add the below, which should bring up the network upon reboot:

You should now be able to ping and ssh to the guest via the host server on the second interface.

All bind templates are at "/usr/lib/opcenter/bind" location.

Modify "named_conf_zone.tmpl" file to allow for transfers adding in the IP addresses of secondary DNS.

To change the IP address of an Ensim server, modify the following files replacing any instance of the old IP address with the new one:

Reboot the server, then run the "NBDetectchanges"