ERROR: PleskException

ERROR: PleskException

Unable initialize session:

——————————————————————————–

0: /usr/local/psa/admin/plib/cmd_loginup.php:240
createSessionCommon(integer ’1′, string ‘admin’, boolean true, string ’65.93.164.55′, NULL null)
1: /usr/local/psa/admin/plib/cmd_loginup.php:373
createSessionAdmin(string ‘admin’, string ‘********’, string ‘***************************’, boolean false)
2: /usr/local/psa/admin/plib/cmd_loginup.php:130
createSession(string ‘admin’, string ‘********’)
3: /usr/local/psa/admin/htdocs/login_up.php3:28
++++++++++++++++++++++++++++++++++++++++++

If you are getting the above statements when you try to login to the plesk panel, here goes the resolution for it.

The issue is due to no free sapce in the hard disk for the plesk to start. In order to fix the issue, you can perform the following steps:

# Execute the following command in the konsole.

df -h
This command shows the current disk usage and available free space in each of the partition. In this case the “/” partition will have no free space. That is usage will be 100 %. So you need to delete the unwanted files in the filled up partition.

Once you have done this you need to restart the plesk service in the server using the following command:

/etc/init.d/psa restart

This should fix the issue

A fatal error has occurred Could not connect to database for SQL SessionHandler. Details have been logged for the administrator.

NB: This is the fix for cpanel servers

# Check the file /usr/local/cpanel/base/horde/config/conf.php

# You can find the following entry in the conf.php

$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '<password>';
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['database'] = 'horde';

Try to connect the database horde using the following method
#mysql -uhorde -p<password>

The password is one you get from the above file.

 You will get the "ERROR 1045 (28000): Access denied for user
'horde'@'localhost' (using password: YES)"

5. grant the privilege to the database using the mysql( in mysql prompt)
mysql> grant all privileges on horde.* to horde@localhost identified by
'<password>';

You can now login into the Horde Webmail now.

Changing interface IP address for exim mail server.

You can change the interface IP address for exim mail server in the exim configuration file (exim.conf).

1) Open the configuration file of exim.

vi /etc/exim.conf

2) Check for the following parameters.

remote_smtp:

driver = smtp

interface=

Change to like this:

remote_smtp:

driver = smtp

interface=x.x.x.x

NB: Replace x.x.x.x with your IP address.

3) Restart the mail service using the following command.

/etc/init.d/exim restart

Changing rdp port in windows using registry editor.

1. Start Registry Editor (start >> run >> type “regedit” and press ok).
2. Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TerminalServer\WinStations\RDP-Tcp\PortNumber

3. On the Edit menu, click Modify and then click Decimal.
4. Type the new port number, and then click OK.
5. Quit Registry Editor.

Rvsitebuilder installation in Cpanel

1. If the server has RVSkin installed, update RVSkin to v6.75 up. (Skip this step if you don’t have it).

perl /root/rvadmin/auto_rvskin.pl

2. After getting the license confirmation, SSH to the cPanel server as root, download the installer using the command below:

cd /usr/local/cpanel/whostmgr/docroot/cgi/
rm -f rvsitebuilderinstaller.tar
wget http://download.rvglobalsoft.com/rvsitebuilderinstaller.tar
tar -xvf rvsitebuilderinstaller.tar
chmod 755 addon_rvsitebuilder.cgi

3. Open WHM as root user, at the bottom left menu under Plugins section, you can find RVSiteBuilder Installer menu.

4. Click RVSiteBuilder Installer to begin the installation process.

5. After complete the installation, you will be sent to RVSiteBuilder Manager automatically.

How to add SPF record in windows DNS

You can create the SPF record using the link given below.

http://www.openspf.org/

Once you have created the SPF record you can add this to DNS settings with the steps given below.

Start >> Run >> dnsmgmt.msc >> Select Domain >> Right click on domain >> Select other new records >> Select Text(TXT) >> Click Create record >> Enter the SPF record in the box “Text”.

Horde Error…….Could not connect to database for SQL SessionHandler

1) Open the horde configuration file.

cd /usr/local/cpanel/base/horde/config
vi conf.php

2) Change the following two lines from:
$conf[’sql’][’hostspec’] = ‘localhost’;
$conf[’sessionhandler’][’params’][’hostspec’] = ‘localhost’;

To:

$conf[’sql’][’hostspec’] = ‘localhost:/var/lib/mysql/mysql.sock’;
$conf[’sessionhandler’][’params’][’hostspec’] = ‘localhost:/var/lib/mysql/mysql.sock’;

Uninstalling apf in linux machine

First you need to stop the apf service running in the server.

/etc/rc.d/init.d/apf stop

Remove all the apf files from the server.

$ rm -Rf /etc/apf
$ rm -Rf /etc/rc.d/init.d/apf
$ rm -Rf /var/log/apf_log
$ rm -Rf /var/log/apfados_log
$ rm -Rf /usr/local/sbin/apf

Disable apf in the run levels to avoid unwanted resource usage.

$ /sbin/chkconfig –level 345 apf off

Open the following file:

/etc/cron.daily/fw

Now remove the following line from it and save.

/etc/rc.d/init.d/apf restart >> /dev/null 2>&1

MYSQL installation in FREEBSD

Installing mysql in freebsd is simple as we can do the installation from the ports. The FreeBSD Ports and Packages Collection offers a simple way for users and administrators to install applications.

The following steps would guide you on how to install mysql 4.1 in the FREEBSD server.

NB: These are steps for a fresh installation of mysql in the server.

=========================================

cd /usr/ports/databases/mysql41-server/
make install clean
/usr/local/bin/mysql_install_db
chown -R mysql /var/db/mysql/
chgrp -R mysql /var/db/mysql/
/usr/local/bin/mysqld_safe –user=mysql &
/usr/local/bin/mysqladmin -u root password newpassword

=========================================

Replace newpassword with whatever password you wish to keep for mysql.

Edit /etc/rc.conf and add the following line to it:

mysql_enable=”YES”

Now the mysql server version 4.1 is installed in the server.

If you want to install mysql 5 in the server, you just need to make a single change in the above steps. You need to access the mysql50-server folder instead of mysql41-server. So the installations steps would look like:

===================================

cd /usr/ports/databases/mysql50-server
make install clean
/usr/local/bin/mysql_install_db
chown -R mysql /var/db/mysql/
chgrp -R mysql /var/db/mysql/
/usr/local/bin/mysqld_safe -user=mysql &
/usr/local/bin/mysqladmin -u root password newpassword

===================================

Replace newpassword with whatever password you wish to keep for mysql.
Edit /etc/rc.conf and add the following line to it:

mysql_enable=”YES”

Now mysql 5 installation is over in the server.

Configuring a website in Windows IIS……..

You can use the following steps to create a website using IIS.

1) Click  Start >> run.

2) Type “inetmgr” in the “run” window. This will open  the “Internet Service manager” window.

3) Expand the local machine in the left panel and right click on “Web Sites”. Select New >> Website.
This will open “Web Site Creation Wizard”.

4) Click the next button to start the setup.

5) Enter the description for the website, that is the name of your site and click next.

6) In the next screen you can enter the IP address, port and host headers if any. Select an IP
address from the drop down list. If the website to be hosted is name based hosting then select
“[All Unassigned]“. The default port for the website is normally 80. If you are using SSL for
your domain then the port is 443. Host headers means if you want an alias name for you website,
you can specify the alias name in the host headers column. Now click next.

7) In the next screen you can specify the home directory for your website. Click on “Browse” and
select the folder that contains the files for you website. Now click next.

8) In the next screen you can specify the Web Site Access Permissions where you can specify read/
write access. Click next to continue.

9) Click “Finish” to exit the wizard.

10) Now the website is defined in the windows web server IIS.