Horde webmail error

Written by AlanV on April 9, 2009 – 10:49 pm -

If horde webmail is not working on windows + plesk server and receiving following errors when login to horde….

Warning: main() [function.include]: Failed opening ‘PEAR.php’ for inclusion (include_path=’C:\Inetpub\vhosts\webmail\horde\lib;.;./includes;./pear’) in C:\Inetpub\vhosts\webmail\horde\lib\core.php on line 46

Warning: main(): Failed opening ‘PEAR.php’ for inclusion (include_path=’C:\Inetpub\vhosts\webmail\horde\lib;.;./includes;./pear’) in C:\Inetpub\vhosts\webmail\horde\lib\core.php on line 26

And so on………

This happens mainly because PHP and Zend installers force PHP to use a default configuration file for all applications, but horde uses a special configuration file which is placed to its folder.

Solution:
Please edit registry by command regedit and clean up the default configuration location by removing the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\php\IniFilePath


Tags: , , , ,
Posted in Dedicated Server Hosting, Plesk For Windows, VPS hosting, Windows VPS | 2 Comments »

MSSQL Connection Error with PHP

Written by Mike on February 28, 2009 – 10:15 pm -

mssql_connect() is a function which establishes a connection to a MS SQL server using PHP. To use MSSQL database in PHP page make sure that MSSQL dll is enabled in PHP. To check open php.ini file and search for following

extension=php_mssql.dll

Sometime it happens that when you try to connect MSSQL database using PHP it throws following Error (espiceally when you have installed PHP 5)

Warning:  mssql_connect() [function.mssql-connect]: Unable to connect to server:  SERVER\SQLEXPRESS in C:\Inetpub\wwwroot\dbconnection.php on line 6

The problem come due to higher version ntwdblib.dll available with PHP 5. The simple fix for this problem is to replace the ntwdblib.dll with old version. You can download the Old version of dll file from http://trulymanaged.com/downloads/ntwdblib.dll OR if you have Plesk Control Panel you can directly copy/replace C:\WINDOWS\system32\ntwdblib.dll with C:\Parallels\Plesk\additional\PleskPHP5\ntwdblib.dll


Tags: , , ,
Posted in Plesk For Windows, VPS hosting, Windows VPS | 1 Comment »

Plesk ERROR: PleskMainDBException

Written by Mike on January 17, 2009 – 2:08 pm -

While accessing plesk control panel, somtime we get following Error

ERROR: PleskMainDBException
MySQL query failed: Table 'psa.APSApplicationItems' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:218
        db_query(string 'SHOW CREATE TABLE `APSApplicationItems`')
1: /usr/local/psa/admin/plib/SQLParser.php:27
        SQLParser->handleDatabase()
2: /usr/local/psa/admin/plib/MySQL5FixBinaryColumns.php:36
        MySQL5FixBinaryColumns::run()
3: /usr/local/psa/admin/auto_prepend/auth.php3:90

SOLUTION:

The Main reason of this problem is corrupted Plesk Database. We can check that using following command

[root@server ~]#  mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa
psa.APSApplicationItems
error    : Table 'psa.APSApplicationItems' doesn't exist
psa.APSClientApplicationItems
error    : Table 'psa.APSClientApplicationItems' doesn't exist
psa.APSLicenseTypes
error    : Table 'psa.APSLicenseTypes' doesn't exist
psa.APSLicenses
error    : Table 'psa.APSLicenses' doesn't exist

To resolve the issue, please do the following:

- remove corrupted tables from plesk database
- restore them from plesk database distributive

you can do above using following Steps

1.  Backup undamaged Tables

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -NB -e'show tables' > ../tables
for i in `cat ../tables`
 do
  mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa $i > $i.sql
 done

2. Remove Plesk database from /var/lib/mysql/ manually.

3. Restore the latest valid daily dump which can be found in /var/lib/psa/dumps/ directory.

4. Finally Restore the backup which we have taken on step 1.

for i in `cat ../tables`
 do echo $i
  mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa < $i.sql
 done

NOTE: Fix for this problem is completely depends upon the error you are getting. So, be careful before trying this fix.


Tags: ,
Posted in Plesk For Linux, VPS hosting, Windows VPS | 1 Comment »

How do I create a new user account on windows 2003?

Written by Swapnil on November 17, 2008 – 12:28 pm -

It is ALWAYS recommended to create additional two (2) users, apart from Administrator. These two users are – another member of “Administrators” group (to avoid actually logging on with the Administrator account, but you have the same privileges) & a regular user, who is part of “Users” group. It is recommended to only log on with regular user, and use the “runas” command when you need to run any particular program as an Administrator; log on with the secondary Administrator user when it is absolutely needed. This will show you how to create a secondary Administrator.

==========

Click the Start button, then Run…

Then type lusrmgr.msc

In window that opens, right click in the right panel and click “New User”

In the New User dialog, type in desired user name and password (secondary Administrator account).  Uncheck User must change password, & check Password never expires. Now, go to the Properties of new User; Go to the “Member of” tab and press the Add button.

Then Type Administrators, and press the Check Names button (to complete the name) and press OK when it is done, then press OK on the Local Users and Groups dialog

Now you have a secondary Administrator account; The above steps will be same to add a regular user (highly recommended) until the User properties.


Tags: , , ,
Posted in Dedicated Server Hosting, VPS hosting, Windows VPS | No Comments »

Windows 2003 Advanced TCP/IP settings

Written by Swapnil on November 17, 2008 – 12:21 pm -

Here is the “Advanced TCP/IP settings” article for windows users..

Advanced TCP/IP settings :-

The Advanced TCP/IP dialog will allow you to configure settings relative to DNS, WINS and specify multiple IP Addresses and Gateway’s. To come up with the  Advanced TCP/IP Settings dialog, simply right click the desired connection from the Network Connections folder, and choose properties, to view the Properties dialog box of the selected connection. Now, select Internet Protocol (TCP/IP) from the list and click the Properties button. This will openup the Internet Protocol (TCP/IP) Properties dialog.

Next step is to click the Advanced button and popsup the Advanced TCP/IP Settings dialog with four tabs to choose the option , from the given below:

IP Settings allows you to add more IP Addresses or  to change the routing properties of the network card.

DNS allows you to set how the TCP/IP connection uses the DNS.

WINS allows you to set how the TCP/IP connection uses WINS for computers that can not access Active Directory.

Options allows you to set TCP/IP Filtering and specify which ports will be used for TCP/IP communication.

The IP Settings Tab : –

The IP addresses box at the top allows you to assign additional IP Addresses to a single network card. This is useful if you are hosting multiple websites on the same web server and want to give each its own IP Address for example.

Simply click the Add button to add an IP Address and Subnet Mask >> Click “Edit” to modify the currently selected item and “Remove” to delete the currently selected item from the list.

The Default gateways box in the middle, Comes into action  if you want the network connection to use multiple default gateways. Click the Add button to add a Default gateway, and assign it a Metric value. A “metric value” is the cost of a specific route. Cost can reflect speed, reliability and number of hops. The route with the lowest metric value is used. So if you have two Default Gateways set up, one with a metric of 10 and the other with a metric of 20, then the  one with 10 will get the first priority.  Leaving the metric at automatic means that the route metric for this default gateway will be calculated automatically, and the fastest route will be chosen.

The Edit and Remove buttons in the Default gateways box, does exactly the same as  the IP addresses box.

At the bottom of the IP Settings tab you can set whether you want the Interface to have a specific metric or to be assigned one automatically. By default this option is checked. Uncheck it if you wish to input an Interface metric value of your choice.

The DNS Tab : –

The “DNS server addresses, in order of use box” at the top of the DNS tab is used to list the IP Addresses of the DNS Servers that will be used for name resolution. These servers are ordered and used in priority, so if one server does not work then it will move to the next one down the list. To set the order of IP Addresses, select an IP Address and press the up and down button on the right hand side.

It is important to keep in mind that TCP/IP will not move on to the next server if it fails to resolve the request. It will only move to the next server if the first server it tries is unavailable (perhaps down for maintenance or in the middle of a reboot).

Append primary and connection specific DNS suffixes, and Append parent suffixes of the primary DNS suffix are enabled by default. These options are used for resolution of unqualified names.

The first option is used to resolve unqualified names using the parent domain. For example, if you had a computer name of test and a parent domain called trulymanaged.com it would resolve to test.trulymanaged.com. The query would fail if test.trulymanaged.com does not exist in the parent domain. The second option is used to resolve unqualified names using the parent-child domain hierarchy. A DNS query will move one step up the domain hierarchy if it fails at the current level. It will do this until it reaches the root of the hierarchy.

The textbox on the right of the DNS suffix for this connection is used to explicitly set a DNS suffix that will override any other setting already specified for this connection.

Register this connections addresses in DNS will register all this connections IP Addresses in DNS under the computers FQDN. Using this connections DNS suffix in DNS registration will register all IP Addresses for this connection in DNS under the parent domain.

The WINS Tab : -

The WINS tab is used to specify WINS related settings such as the list of WINS servers to be used for NETBIOS name to IP resolution, the LMHOSTS file to be used as an alternate means of lookups and the NETBIOS settings for the network connection.

Use the “WINS addresses, in order of use box” at the top to add the WINS servers you want the system to use for IP to name resolution. Press the Add button for a small dialog box to appear waiting for you to enter the IP Address of the WINS server. Use the Edit and Remove buttons to modify or delete a selected item respectively. If you have more than one WINS server in the list, press the up and down arrow buttons to adjust the priority of which servers will be queried first. If one server is not available then the next one down will be used, and so on and so forth.

Check the Enable LMHOSTS lookup checkbox so that if WINS cannot resolve a name then the local LMHOSTS file will be used. The LMHOSTS file can be found in \WINDOWS\system32\drivers\etc. It goes by the name of lmhosts.sam and can be modified in a text editor. Entries are placed at the bottom of the file and when used, the listed IP Addresses are matched against a specified host name. If you already have an LMHOSTS file defined on another machine on the network, use the Import LMHOSTS button to select this file and import it to the local machine.

The NETBIOS settings at the bottom allow you to explicitly define how NETBIOS will be used on the system. Choose Default if you want the DHCP server to assign the NETBIOS setting, Enable NETBIOS over TCP/IP if you use a static IP Address or the DHCP Server does not give NETBIOS settings, and Disable NETBIOS over TCP/IP if you do not use NETBIOS or WINS on your network.

The Options Tab (TCP/IP Filtering) :-

The Options tab allows you to configure TCP/IP Filtering settings; you can define which ports or protocols are permitted. Select the Permit Only radio button and use the Add button to add TCP/UDP port numbers or a protocol version to the respective list. If you permit traffic only from a defined set of ports, all other traffic will be dropped.


Tags: , , , , , ,
Posted in Dedicated Server Hosting, Windows VPS | 1 Comment »

Plesk key update deferral notification

Written by Mike on November 5, 2008 – 5:07 pm -

ERROR:

You getting emails from Plesk, or getting Following error while pressing “Retrieve Keys” from Plesk >> Server >> License Management

Licensing Server Unreachable: Unable to connect with licensing server.
Please make sure that your network allows communication to ka.swsoft.com:5224.
For more details check system help pages


SOLUTION:

Plesk connects Parallels license server at 5224 port for the license update procedure. Make sure that the outgoing connection to ka.swsoft.com:5224 is not blocked on Plesk server or somewhere in the net. This can be examined with commands:

# nmap -P0 -p5224 ka.swsoft.com

[root@support ~]# nmap -P0 -p5224 ka.swsoft.com

Starting nmap 3.70 ( http://www.insecure.org/nmap/ ) at 2008-11-05 10:00 EST
Interesting ports on ka.parallels.com (64.131.90.38):
PORT     STATE    SERVICE
5224/tcp filtered unknown

Nmap run completed -- 1 IP address (1 host up) scanned in 2.205 seconds


# telnet ka.swsoft.com 5224

[root@support ~]# telnet ka.swsoft.com 5224
Trying 64.131.90.38...
Connected to ka.swsoft.com.
Escape character is '^]'.

Tags: , ,
Posted in Plesk For Linux, Windows VPS | 26 Comments »

Difference Between MSSQL Server 2005 Express, Standard and Work group Edition

Written by Mangesh on November 4, 2008 – 2:10 am -

Difference Between MSSQL Server 2005 Express, Standard and Work group Edition

MS SQL 2005 Express Edition features are as follows :

* CPU : No
* 1 GB max memory limit for buffer pool : Yes
* 4GB max database size : Yes
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : No
* Basic Integration Services : No
* Advanced Integration Services : Yes

MSSQL 2005 Standard Edition features are as follows :

* CPU : Yes
* 1 GB max memory limit for buffer pool : No
* 4GB max database size : No
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : Yes
* Basic Integration Services : Yes
* Advanced Integration Services : Yes

MSSQL 2005 Workgroup Edition features are as follows :

* CPU : Yes
* 1 GB max memory limit for buffer pool : No
* 4GB max database size : No
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : Yes
* Basic Integration Services : No
* Advanced Integration Services : No


Tags: ,
Posted in Dedicated Server Hosting, VPS hosting, Windows VPS | 4 Comments »

PHP Cache

Written by Pravin on October 18, 2008 – 10:23 am -

If your sites are using php as the major scripting & the server load is highly around 10+, PHP Cachers like APC , Xcache or Eaccelerator can are really help to minimize the load to 1-2.

APC: The Alternative PHP Cache (APC) is a free and open opcode cache for PHP. It was conceived of to provide a free, open, and robust framework for caching and optimizing PHP intermediate code.

XCache: XCache is a open-source opcode cacher, which means that it accelerates the performance of PHP on servers. It optimizes performance by removing the compilation time of PHP scripts by caching the compiled state of PHP scripts into the shm (RAM) and uses the compiled version straight from the RAM. This will increase the rate of page generation time by up to 5 times as it also optimizes many other aspects of php scripts and reduce serverload.

Eaccelerator: It is a free open-source PHP accelerator, optimizer, and dynamic content cache. It increases the performance of PHP scripts by caching them in their compiled state, so that the overhead of compiling is almost completely eliminated. It also optimizes scripts to speed up their execution. eAccelerator typically reduces server load and increases the speed of your PHP code by 1-10 times.


Tags: , , , ,
Posted in Dedicated Server Hosting, linux, Linux VPS Hosting, Plesk For Linux, VPS hosting, Windows VPS | 1 Comment »

Business and IT benefits of Virtualizing Serves?

Written by Pravin on October 18, 2008 – 3:50 am -

Operations running 24×7 are the key objectives of business continuityin any organization. It is a best practice to  establish data centers & sites in different geographic regions with replicated applications and data using geographic redundancy.

Implementing geographic redundancy is the main task which can be done in different ways. Deploying multiple sites & using some software to duplicate the data is the significant investment. Now a days IT professionals  build redundant sites as a backup and manually manage data replication and failover to the secondary site when needed. By virtualizing data center resources at both sites, you can turn non-performing assets into an ongoing available asset.

A better practice is to virtualize your server and application resources-a much more cost effective and a better overall architecture. Instead of deploying that very expensive mid-range system, virtualize multiple, low-cost, high-performance servers with applications and data, so when one server fails you are not impacted. This gives you the opportunity to achieve high availability and performance without breaking the bank.


Tags: , , , ,
Posted in Dedicated Server Hosting, Linux VPS Hosting, VPS hosting, Windows VPS | No Comments »

Change MSSQL 2005 Express ‘SA’ password From Command Prompt

Written by Mike on October 17, 2008 – 2:20 pm -

SA is the administrative login for the MSSQL. To Change the MSSQL SA password please use following steps:

Step 1. Go to the command prompt of the server ( Start >> Run >> Cmd ) and type in command prompt
osql –L
This command will list all the MSSQL servers near you.

list1 Change MSSQL 2005 Express SA password From Command Prompt

Step 2. Copy full name of required MSSQL server and type
osql -S copied_servername –E
By this command you’ll connect to MSSQL server using Server administrator account (Windows Authentication).

enter Change MSSQL 2005 Express SA password From Command Prompt

Step 3. To change sa password you should execute the following query:
1> sp_password NULL,’new_password’,'sa’
2> go

Here the new_password will be the password which you want to set.

change Change MSSQL 2005 Express SA password From Command Prompt

Now try to login to MSSQL using new password.


Tags: ,
Posted in Windows VPS | 3 Comments »
RSS

  • Subscribe Me

  • Tag Cloud

  • Archives