Archive for the “Uncategorized” Category

Frontpage- Unable to connect – fp admin

First make sure the domain is pointing to the server.

or trying using the ip address as such

http://ipaddress/_vti_bin/_vti_adm/fpadmdll.dll?page=webadmin.htm

always create the fp user within fp admin and not under computer management

server admin

http://ipaddress:7814/fpadmdll.dll?page=fpadmin.htm

the port can be something different depending on the server

March 16, 2008 Posted Under: Uncategorized   Read More

Plesk – set default domain for a given ip

I. IP ADDRESS MANAGEMENT
The IP Address Management function of Plesk enables the administrator of the server to control the available IP Addresses on system network interfaces. This function is designed specifically for servers that have more than one IP address or more than one network interface.

Here is how you can access the IP Address Management page where you can add and remove IP addresses, refresh the list of IP addresses, and edit the IP address properties:

1. Login to your Plesk Control Panel using admin as “Login” and your dedicated server password as “Password”.

2. Click on Server from the navigation bar on the left.

3. Click the IP Addresses icon.

4. You will now see the list of available IP Addresses on the server.

Here is how to set the default domain for a particular IP Address:

1. At the IP Address Management page, click the number in the Hosting column of the IP Address you’d like to manage.
2. Select a domain from the list using the respective radio button.

3. Finally, click the Set as Default link.

March 15, 2008 Posted Under: Uncategorized   Read More

Plesk SOAP Failed , mail server issue SM4 and SM5

Unable to delete DSMail service for domain: Unable to remove domain mail: mailmng failed: SOAP failed. Failed in sending message
———————- Debug Info ——————————-
0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:153
 psaerror(string ‘Unable to delete DSMail service for domain: Unable to remove domain mail: mailmng failed: SOAP failed. Failed in sending message’)
————————————————–
check the component under server and also make sure the service is running
Using host header as mail.domain.com to port 80 to view smartermail webmail panel.

the solution is in proper host headers (duh) assuming as most of you are running multiple web sites/ip.
Make sure the ‘Default’ pointer is set to the correct port and the host header value is ‘blank’. Mine got screwy trying different ports.
I am also running SM on iis port 9998 & ‘All Unassigned’ now (same as SM server default). Although you can probably choose any port.

incompleted

March 9, 2008 Posted Under: Uncategorized   Read More

Plesk httpd.include files for httpd.conf

Customizable httpd.include per domain

In Plesk each domain has virtual hosts configuration stored in a separate file:

/home/httpd/vhosts/<domain-name>/conf/httpd.include

This file is overwritten each time the virtual host configuration is changed, thus any manual alterations made to the file are discarded. To use custom directives or redefine those inserted by Plesk, you need to create the files vhost.conf and/or vhost_ssl.conf with necessary directives in the directory /home/httpd/vhosts/<domain-name>/conf/

If any (or both) of these files exist by the time the main configuration file is generated, Plesk inserts the appropriate directive Include /home/httpd/vhosts/<domain-name>/conf/vhost.conf or Include /home/httpd/vhosts/<domain-name>/conf/vhost_ssl.conf into the HTTP and/or HTTPS virtual host context respectively.

For security reasons, only root can create the vhost.conf and vhost_ssl.conf files.

For the changes to take effect, you need to run the following: or restart httpd

/usr/local/psa/admin/sbin/websrvmng --reconfigure-vhost --vhost-name=<domain_name>

or windows
In Windows command prompt:
Code:

cd c:\Program Files\SWSoft\Plesk\admin\bin
websrvmng –reconfigure-vhost –vhost-name=domain.com

February 24, 2008 Posted Under: Uncategorized   Read More

sql server 2000 change ownership of tables

DECLARE @old sysname, @new sysname, @sql varchar(1000)

SELECT
  @old = 'OLDUSERNAME'
  , @new = 'dbo'
  , @sql = '
  IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
  WHERE
      QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
      AND TABLE_SCHEMA = ''' + @old + '''
  )
  EXECUTE sp_changeobjectowner ''?'', ''' + @new + ''''

EXECUTE sp_MSforeachtable @sql
======================================
changing stored procs
========================
SELECT 'EXEC(''sp_changeobjectowner @objname = '''''+
  ltrim(u.name) + '.' + ltrim(s.name) + ''''''
  + ', @newowner = dbo'')'
FROM  sysobjects s,
      sysusers u
WHERE s.uid = u.uid
AND   u.name <> 'dbo'
AND   xtype in ('V', 'P', 'U')
AND   u.name not like 'INFORMATION%'
order by s.name
This query finds every view, stored procedure and user table in the database not owned by the dbo and converts ownership to the dbo. The output looks like this:

EXEC('sp_changeobjectowner @objname = ''lname.Authors'', @newowner = dbo')
EXEC('sp_changeobjectowner @objname = ''lname.BANNER_Ads'', @newowner = dbo')
EXEC('sp_changeobjectowner @objname = ''lname.Comments'', @newowner = dbo')

You can simply copy and paste the EXEC statements into Query Analyzer and run it. This might have been overkill for fifteen objects in my database. At work I deal with a database that has over 6,000 stored procedures and approaches like this are a little more appropriate. Enjoy.
Reference 
February 24, 2008 Posted Under: Uncategorized   Read More