Arun's blog

A Technical Blog

  • Drupal 7 issue with SQL Mode TRADITIONAL

    PDOException: SQLSTATE[42000]: Syntax error or access violation: 1231 Variable ‘sql_mode’ can’t be set to the value of ‘TRADITIONAL’ in lock_may_be_available() (line 165 of /includes/lock.inc). This was the case when I installed Drupal 7 with Cpanel/Fantastico, the drupal site was displaying the above error. This issue is discussed at drupal issues . try to patch it…

  • Install and configure RSA web agent with Redhat EL5 and Apache

    Login to RSA interface: – Create the apache server as agent host with type web agent – Generate the config file (zip file containing sdconf.rec) from RSA interface, and download to your local machine Login to the web server – Download the RSA web agent installation files from RSA website. # mkdir -p /var/ace –…

  • Changing RSA passwords

      Reset SSH Password: ——————- Log in to Operations console (Master): Administration –> Networking –> Configure connectivity using SSH Do the same procedure on Replica also (if any), it is manual process. Reset Operations console password: ———————————- Login to the master appliance with SSH $ sudo -s // sudo as root # su – rsaadmin…

  • Configure IPv6 squid

    Squid 3.1+ support IPv6 – Compile and install 3.1.x version of squid. # useradd -d /opt/squid squid # wget http://www.squid-cache.org/Versions/v3/3.1/squid-3.1.11-20110228.tar.gz # tar xvzf squid-3.1.11-20110228.tar.gz # cd squid-3.1.11-20110228; ./configure –prefix=/opt/squid/ # make; make install # /opt/squid/sbin/squid -z Configure squid edit /opt/squid/etc/squid.conf cache_effective_user squid acl manager proto cache_object acl localhost src 127.0.0.1/32 ::1 acl to_localhost dst 127.0.0.0/8…

  • Performance issues with KVM – Redhat

    The general performance issue with KVM is due to DISK I/O – by default the Redhat KVM guest are created with x86_64 architecuture, if you installed 32 bit operating system change this to i686. <os> <type arch=’i686′ machine=’rhel5.6.0′>hvm</type> <boot dev=’hd’/> – Make sure the hypervisor used is correct in the configuration , either qemu or…

  • yum update, IndexError: tuple index out of range

    If you happen to get this error while updating server with yum update — . . . File “/usr/lib/python2.4/site-packages/M2Crypto/m2urllib2.py”, line 82, in https_open h.request(req.get_method(), req.get_selector(), req.data, headers) File “/usr/lib/python2.4/httplib.py”, line 813, in request if v[0] != 32 or not self.auto_open: IndexError: tuple index out of range — disable the location aware access from rhn. Ref:…

  • Public key authentication with bluecoat proxy

    – Create a key with length maximum 1024 on your machine $ ssh-keygen -t rsa -b 1024 -f filename – ssh to the bluecoat proxy > en # configure terminal #(config) ssh-console #(config ssh-console) inline client-key admin … < paste the key after those three dots > … ./arun

  • Converting LVM virtual machine storage to image

    To convert the LVM disk to qcow2 formatted disk image, Use lvdisplay to get the Logical volume name $ sudo lvdisplay Use qemu-img to convert to the required image format # qemu-img convert -O qcow2 /dev/mapper/lv_name <destination_file>.qcow2 eg: # qemu-img convert -O qcow2 /dev/mapper/disk1 disk1.qcow2 This will be useful to replicate the virtual machines to other…

  • Install CyanogenMod 6 (Android 2.2 Froyo alternative) on HTC Dream (ADP1)

    Atlast managed to get the 2.2 flavour on ADP1. (this installation is only applicable for root’d Android developer phone HTC dream) Requirements: Tools: fastboot images: Amon_Ra 1.7.0 ( http://files.androidspin.com/downloads.php?dir=amon_ra/RECOVERY/&file=recovery-RA-dream-v1.7.0.img ) radio image for adp1 (http://sapphire-port-dream.googlecode.com/files/ota-radio-2_22_19_26I.zip) update-cm-6.0.0-DS-signed.zip (http://forum.cyanogenmod.com/files/file/95-update-cm-600-ds-signedzip/) gapps-mdpi-tiny-20100926-signed.zip (http://forum.cyanogenmod.com/files/file/124-google-addon-mdpi-tiny-20101020/) DangerSPL (http://sapphire-port-dream.googlecode.com/files/spl-signed.zip) Procedure: Ref : http://wiki.cyanogenmod.com/index.php?title=Full_Update_Guide_-_Android_Dev_Phone_1#Installing_a_Custom_Recovery_Image – Download and copy all these images to the root…

  • Install *.apk to android phone

    It was disappointing that the android devices selling in most of the gulf countries doesnt have market place installed 🙁 – One of the core and major feature of androis is missing. Anyway the softwares available in Android Package file (apk) can be installed by downloading it to the pc using adb eg: to install…

  • Exporting display over ssh

    To export the display from a remote server over ssh: ssh -X user@host Just made sure that, X11 forwarding is enabled on the sshd_config . Once the connection is made, you can make sure the display is exported using: # echo $DISPLAY localhost:10.0 if the value is empty, make sure you have the necessary package…

  • IPv6 configuration for KVM guests

    It is simple and straight forward to enable IPv6 on KVM guests Configure the host machine with IPv6 Address on the bridge interface cat ifcfg-br0 IPV6INIT=yes IPV6ADDR=xxxx.xx::10 IPV6_DEFAULTGW=xxxx.xx::1 IPV6_AUTOCONF=no Configure the interface on virutal machines with ipv6 address cat ifcfg-eth0 IPV6INIT=yes IPV6ADDR=xxxx.xx::11 IPV6_DEFAULTGW=xxxx.xx::1 IPV6_AUTOCONF=no Add the the necessary firewall rules to ip6tables on the host…

  • NAT with port forwarding on Virtual Box

    You can use the host-only-adapter networking, if you require the virtual machine to be accessible only from the host machine. In this case your virtual machine will not have access to anywhere outside the host. Read more about virtual box networking at http://www.virtualbox.org/manual/ch06.html On the other hand NAT enabled interface can communicate with clients outside…

  • Convert KVM images to Virtual Box (VDI)

    The steps to convert KVM images to VirtualBox’s VDI format, ensuring cross-platform compatibility and a smoother transition. VirtualBox’s VDI (Virtual Disk Image) format comes with several advantages, making it a flexible choice for virtualization: Cross-Platform Compatibility: VDI images can run on Linux, macOS, or Windows, making them versatile and accessible. No Need for Virtualization-Enabled Processors:…

  • KVM image on LVM

    Virtualization has transformed the world of computing, offering flexibility, resource optimization, and cost-effectiveness. We’ll explore the process of converting qcow2/raw images to LVM logical volumes, giving you greater control over your virtualization resources. KVM is an excellent choice for virtualization on Linux, and when paired with LVM, it offers even more benefits. LVM allows you…

Got any book recommendations?

Get In Touch