1. Login to phpMyAdmin and select Joomla’s db from the drop down menu. It will show all the tables in that db.
2. In the text field enter the following query.
UPDATE `jos_users` SET `password` = MD5( new_password ) WHERE `jos_users`.`username` = admin ; [Replace the term new_password with your new password and admin with the exact user if it’s different from admin.
3. Click the GO button once you completes the 2nd step.
4. You should now able to login with the new password.

How to fix Cpanel Remote Mysql issue with the error message: WARNING [2] mysql_connect(): OK.shorter than expected

How to fix Cpanel Remote Mysql issue having the error message: WARNING [2] mysql_connect(): OK packet 6 bytes shorter than expected, Line: 34 in file C:\inetpub\local_intranet\website_updater.php

We need to perform two steps to check this which can be done as follows:

Firstly, check the mysql remote connection after making sure that you are using the following parameters;

MySQL server : Server IP

Port : 3306

User : fill in mysql user for eg: username_test

Password : password of the mysql user.

Continue reading…

Configure OpenLDAP for use with SAMBA

In order to use LDAP and SAMBA we need to configure the /etc/ldap/slapd.conf file.
# Copy the samba.schema file to the OpenLDAP schema directory.

cp /usr/share/doc/samba-doc/examples/LDAP/samba.schema.gz /etc/ldap/schema/
# Unzip the file.

gzip -d /etc/ldap/schema/samba.schema.gz
# Open the /etc/ldap/slapd.conf file for editing.

vim /etc/ldap/slapd.conf
# Add the following lines to the document where the other "include" lines are:

include         /etc/ldap/schema/samba.schema
include         /etc/ldap/schema/misc.schema
# Change the line:

access to attribute=userPassword
# to:

access to attrs=userPassword,sambaNTPassword,sambaLMPassword
# Restart OpenLDAP:

/etc/init.d/slapd restart

Some useful commands using lsof

LiSt Open Files is a useful and powerful tool that will show you opened files. In Unix everything is a file: pipes are files, IP sockets are files, unix sockets are files, directories are files, devices are files, inodes are files…
Useful Examples
So in this tangle of files lsof listst files opened by processes running on your system.
When lsof is called without parameters, it will show all the files opened by any processes.

Continue reading…