Dotnetpanel Forums

Hi,

I'm new to DNP and was wondering how you can install an application pack to http://www.domain.com/ instead of http://domain.com/

The Joomla, phpbb and Wordpress installation packs all seem to use absolute links to http://domain.com/ and do not work properly if you only have a DNS record for www.domain.com

I tried creating a subdomain "www" first in the "add new domain" window, but the system does not accept that:

Domain name should not be started from "www."

You don't need to prefix the domain with "www.". The system will do it automatically depending on the place where the domain should be used. Anyway, your web site will be available at both "domain.com" and "www.domain.com" URLs.

 Did not download them seperately. Only tried the ones that are included with Dotnetpanel 2.6.

Which are Joomla, phpBB and Wordpress

(the .asp.net ones do not seem to work yet with SQL server 2008, so that only leaves me with the php/mysql ones)

Need to make some changes to the config files to allow them to work with SQL 2008; I'll need to speak to Feodor about that.

The application packs on the website are more up to date than the ones that come with DNP so give them a try.

 Thanks for the tip.
That seems to work better:


The following application pack downloads seem to work properly under www.domain.com:

- Wordpress
- Joomla
- SMF
- Drupal (as long as you disable notices in php.ini)


phpBB 3 doesn't seem to like MySQL 5.0.67:

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'INSTALL_APPLICATION' task on 'phpBB3' APP_INSTALLER ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` (post_msg_id),
KEY topic_id` (topic_id),
KEY poster_id` (poster_id),
KEY' at line 19

HTTP Error 404.3 - Not Found
The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.

DNP seems to generate a web.config file in the subdirectory that REMOVES php support:

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <security>
            <authentication>
                <basicAuthentication enabled="false" />
            </authentication>
        </security>
        <httpRedirect enabled="false">
            <clear />
        </httpRedirect>
        <handlers>
           <remove name="PHP via FastCGI (*.php)" />
            <remove name="ASPClassic (*.htr)" />
            <remove name="SecurityCertificate" />
            <remove name="ASPClassic (*.cdx)" />
            <remove name="ASPClassic" />
            <remove name="ASPClassic (*.asa)" />
        </handlers>
        <defaultDocument>
            <files>
                <clear />
                <add value="index.php" />
            </files>
        </defaultDocument>
        <httpProtocol>
            <customHeaders>
                <clear />
                <add name="X-Powered-By" value="ASP.NET" />
            </customHeaders>
        </httpProtocol>
    </system.webServer>
</configuration>

Is that a bug, or did I miss a setting somewhere?

I've uploaded a different version of phpBB3 try and download it again.

Same database problem.

The new .zip file only differs a single byte in size with the old one (new size=2.098.099 bytes). Is it supposed to be that way?

You’re getting the 404.3 error because I haven't found away of making the application installer set what version of php to use, if the root website has PHP enabled you shouldn’t have the same issue as the VD uses them settings by default.

In the "website properties", tab "Extensions", it says "PHP:" "5.x"

So I assume it is enabled. Or are there other settings elsewhere that may affect it?

And DNP did generate a web.config that enables php in the wwwroot folder of the domain:

<add name="PHP via FastCGI (*.php)" path="*.php" verb="GET,HEAD,POST,DEBUG" modules="FastCgiModule" scriptProcessor="c:\php\php-cgi.exe" resourceType="File" />

 (which is disabled again, by  the web.config in the subdirectory)

The new DNP version 2.6.0

Installed it yesterday.

Box has Windows 2008 web edition x64, SQL server 2008 express with advanced services, MySQL 5.0.67 and PHP 5.2.6 (FastCGI)

Clean install, no previous control panel, or anything.

We have Windows 2003 and MySQL 5.0.6.7 it could be a 2008 or x64 issue I'm just not sure.

Hi how is the PHP BB3 issue going?

We still need a fix or know how to go aroud it.

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'INSTALL_APPLICATION' task on 'phpBB3' APP_INSTALLER ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` (post_msg_id),
KEY topic_id` (topic_id),
KEY poster_id` (poster_id),
KEY' at line 19
at DotNetPanel.EnterpriseServer.WebApplicationsInstaller.RunScenario(String scenarioPath, InstallationInfo inst, Boolean throwExceptions)

can you go to

DotNetPanel\Enterprise Server\WebApplications\phpBB3

 and copy here content of first "CREATE TABLE .... attachments" from mysql_schema.sql?

Here is the first content of the file 

# Table: 'attachments'
CREATE TABLE `${ObjectQualifierNormalized}attachments` (
 attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 physical_filename varchar(255) DEFAULT '' NOT NULL,
 real_filename varchar(255) DEFAULT '' NOT NULL,
 download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 attach_comment text NOT NULL,
 extension varchar(100) DEFAULT '' NOT NULL,
 mimetype varchar(100) DEFAULT '' NOT NULL,
 filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
 filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
 thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 PRIMARY KEY` (attach_id),
 KEY filetime` (filetime),
 KEY post_msg_id` (post_msg_id),
 KEY topic_id` (topic_id),
 KEY poster_id` (poster_id),
 KEY is_orphan` (is_orphan)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;