Return-Path: 
 <users-return-228869-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
X-Original-To: apmail-tomcat-users-archive@www.apache.org
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 256579446
	for <apmail-tomcat-users-archive@www.apache.org>;
 Sun, 23 Oct 2011 18:58:42 +0000 (UTC)
Received: (qmail 96037 invoked by uid 500); 23 Oct 2011 18:58:38 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 95931 invoked by uid 500); 23 Oct 2011 18:58:38 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 95922 invoked by uid 99); 23 Oct 2011 18:58:38 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 23 Oct 2011 18:58:38 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=5.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [184.107.169.10] (HELO iw9.ich-3.com) (184.107.169.10)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 23 Oct 2011 18:58:31 +0000
Received: from bas1-toronto27-1279274342.dsl.bell.ca ([76.64.45.102]
 helo=Magnolia.local)
	by iw9.ich-3.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69)
	(envelope-from <submit@zuka.net>)
	id 1RI3Ed-00053d-98
	for users@tomcat.apache.org; Sun, 23 Oct 2011 14:57:36 -0400
Message-ID: <4EA46395.50407@zuka.net>
Date: Sun, 23 Oct 2011 14:57:25 -0400
From: Dave Filchak <submit@zuka.net>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.5;
 rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re:: tomcat error 404
References: <4EA43ECC.5050004@zuka.net>
In-Reply-To: <4EA43ECC.5050004@zuka.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-AntiAbuse: This header was added to track abuse,
 please include it with any abuse report
X-AntiAbuse: Primary Hostname - iw9.ich-3.com
X-AntiAbuse: Original Domain - tomcat.apache.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - zuka.net
X-Virus-Checked: Checked by ClamAV on apache.org

Alright well, I am having a hell of a time getting this to work. I am 
adding all my pertinent xml files so that maybe someone has some time to 
help me get this straightened out. I know everyone is busy and it is 
Sunday so I'll let it sit after this but at this point, I have pages 
that work but no database connectivity.

My web.xml file @ /home/######/public_html/WEB-INF/

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 
2.2//EN" "http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
<web-app>

<display-name>Mushroom</display-name>
<description>
    Snap Media Mushroom Site
</description>

<context-param>
<param-name>webmaster</param-name>
<param-value>support@######.com</param-value>
<description>
       Please contact Nick should any questions or issues arise about 
this application.
</description>
</context-param>

<context-param>
<param-name>root</param-name>
<param-value>/home/######/public_html</param-value>
<description>
       Path to where the system begins
</description>
</context-param>

<context-param>
<param-name>xmlprops</param-name>
<param-value>/home/######/public_html/WEB-INF/conf/environment.xml</param-value>
<description>
       Used to find path to local XML props file.
</description>
</context-param>

<servlet>
<servlet-name>WebSystemController</servlet-name>
<servlet-class>com.snapmedia.WebSystemController</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>

<servlet-mapping>
<servlet-name>WebSystemController</servlet-name>
<url-pattern>/servlet/WebSystemController</url-pattern>
</servlet-mapping>

<session-config>
<session-timeout>30</session-timeout>
</session-config>

<resource-ref>
<description>Connection Pool</description>
<res-ref-name>jdbc/exodus</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

</web-app>

My environment.xml file @ /home/######/public_html/WEB-INF/conf/

<?xml version="1.0"?>
<mushroom>

<environment>
<systemVersion>2.0</systemVersion>
<systemBuildCode>005523</systemBuildCode>
<systemLastUpdate>April 29, 2005</systemLastUpdate>
<systemIPAddress>127.0.0.1</systemIPAddress>
<SMTPHost>174.122.30.18</SMTPHost> <!-- Used by JavaMail -->
<mailFrom>it-ops@quickplay.com</mailFrom>
<sysAdmin>N. Dingle</sysAdmin>
<debug>true</debug>
</environment>

<!--
       This node contains the paths to "static systems". These should 
always be
       Fully-qualified URLs to the system in question, including domain, 
context
       root and any pertinent subdirectory. If code references any 
system which
       does not exist here, "base" will be used as a default.
    -->
<staticSystems>
<base>http://www.exodusdecoded.com</base>
<admin>http://www.exodusdecoded.com/tools</admin>
</staticSystems>

<!--
       This node is recursive so that any paths set here will be 
automatically
       loaded into the environment class. Paths end up being converted into
       Name/Value pairs and are dumped into a Hashtable
    -->
<paths>
<loginJSP>/login.jsp</loginJSP>
<parentControlJSP>/parentControl.jsp</parentControlJSP>

<baseRoot>/home/exodus/public_html/</baseRoot>
<dataRoot>/data</dataRoot>
<instanceFile></instanceFile>
<systemLogFolder>/home/exodus/public_html/WEB-INF/logs/</systemLogFolder>
<systemArchiveFolder>/home/exodus/public_html/WEB-INF/logs/archive/</systemArchiveFolder>
<logFile>/home/exodus/public_html/WEB-INF/logs/codelog.txt</logFile>
<cronLog>/home/exodus/public_html/WEB-INF/logs/scheduler.txt</cronLog>
<broadcastLog>/home/exodus/public_html/WEB-INF/logs/broadcast.txt</broadcastLog>
<memoryLog>/home/exodus/public_html/WEB-INF/logs/memory.txt</memoryLog>
<securityLog>/home/exodus/public_html/WEB-INF/logs/security.txt</securityLog>
<ipmanifestlog>/home/exodus/public_html/WEB-INF/logs/ipmanifest.txt</ipmanifestlog>
<forumArchiveLog>/home/exodus/public_html/WEB-INF/logs/forum.txt</forumArchiveLog>
</paths>

<logging>
<connectionPool>false</connectionPool>
<memoryManager>false</memoryManager>
<cronSystem>true</cronSystem>
<broadcastSystem>false</broadcastSystem>
</logging>

<users>
<UserCookie1>AEFK67897PI30</UserCookie1>
<UserCookie2>AEFK6S897PI50</UserCookie2>
<SessionTimeout>30</SessionTimeout>
<CookieDomain>exodusdecoded.com</CookieDomain>
<MaxHandleLength>25</MaxHandleLength>
<DiskQuota>204800</DiskQuota>
<emailVerifyTimeout>0</emailVerifyTimeout>
</users>

<!-- BELOW, FIND CONFIGURATION FOR MUSHROOM'S SUB-SYSTEMS -->

<CronScheduler>
<enabled>true</enabled>
<instanceSensitive>false</instanceSensitive>
<runForInstance>1</runForInstance>
<scanForJobs>10</scanForJobs>
</CronScheduler>

<BroadcastSystem>
<enabled>true</enabled>
<interval>5</interval>
</BroadcastSystem>

<ParentalGuidance>
<enabled>true</enabled>
<MinRegistrationAge>13</MinRegistrationAge>
</ParentalGuidance>

<MemoryManager>
<enabled>false</enabled>
<frequency>15</frequency>
<warnLevel>450</warnLevel>
<notifyEnabled>true</notifyEnabled>
<notifyGroup>sdeboer@snapmedia.com</notifyGroup>
</MemoryManager>

<BlockedUserManager>
<enabled>true</enabled>
<daysBlocked>3</daysBlocked>
</BlockedUserManager>

<SecurityWatcher>
<enabled>false</enabled>
<rftEnabled>true</rftEnabled>
<rftThreshold>10</rftThreshold>
<rftActionPoint>1500</rftActionPoint>
<rftClearPoint>4000</rftClearPoint>
<rftHoldTime>10</rftHoldTime>
<rftDailyMaxViolations>5</rftDailyMaxViolations>
<autoLogoutEnabled>true</autoLogoutEnabled>
</SecurityWatcher>

<!-- BELOW, FIND CONFIGURATION FOR THE SYSTEM'S DATABASE ## Note that I 
have commented this out in order to try configuring the dB connection 
using methods I found online or in a book that I have - but to no avail -->

<!-- <jdbc-config>
<driver>com.mysql.jdbc.Driver</driver>
<url>jdbc:mysql://www.exodusdecoded.com/exodus_exodus</url>
<user>exodus_exodus</user>
<password>simcha</password>
<max>10</max>
<init>10</init>
<queueQuery>select now()</queueQuery>
<logFile>/home/exodus/public_html/WEB-INF/logs/pool.txt</logFile>
</jdbc-config> -->

</mushroom>

My server.xml file at /home/#####/public_html/conf/

<?xml version='1.0' encoding='utf-8'?>

<Server port='8105' shutdown='SHUTDOWN' debug='0'>
<Listener className="org.apache.catalina.core.AprLifecycleListener" 
SSLEngine="on" />
<Listener className="org.apache.catalina.core.JasperListener" />
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" />
<Listener 
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />

<GlobalNamingResources>
<Resource name="UserDatabase" auth="Container"
               type="org.apache.catalina.UserDatabase"
               description="User database that can be updated and saved"
               factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
               pathname="conf/tomcat-users.xml" />
</GlobalNamingResources>

<Service name='Catalina'>
<Connector port="8180" protocol="HTTP/1.1"
            maxThreads="150" connectionTimeout="20000"
                redirectPort="8443" address="/home/exodus/public_html" />

<Connector port="8010" protocol="AJP/1.3" redirectPort="8443" 
address="/home/exodus/public_html" />

<Engine name="Catalina" defaultHost="www.exodusdecoded.com">

<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
              resourceName="UserDatabase"/>
<Host name="www.exodusdecoded.com"  appBase="/home/exodus/public_html"
             unpackWARs="true" autoDeploy="true"
             xmlValidation="false" xmlNamespaceAware="false">

<Valve className="org.apache.catalina.valves.AccessLogValve" 
directory="logs"
                prefix="exodus_access" suffix=".log" pattern="common" 
resolveHosts="false"/>
<Logger className='org.apache.catalina.logger.FileLogger'
            directory="logs" prefix="exodus_catalina" suffix=".log" 
timestamp="true" />

<!-- Here I tried to define a context based on information I again fould 
in a book that I have and online -->
<Context path='' docBase='/home/#####/public_html/' debug='0'
<Resource name="jdbc/exodus" auth="Container" type="javax.sql.DataSource"
              username="#####_#####"
              password="#####"
              driverClassName="com.mysql.jdbc.Driver"
              
url="jdbc:mysql://localhost:3306/#####_#####?useUnicode=true&amp;characterEncoding=utf8"
              maxActive="15"
              maxIdle="7"
              defaultTransactionIsolation="READ_COMMITTED"
              validationQuery="Select 1" />
     />
</Host>
</Engine>
</Service>
</Server>

My context file, which I created while again trying to solve why the 
database connection fails at /home/#####/public_html/META-INF/

<Context>
<Resource name="jdbc/exodus"
     auth="Container"
     type=javax.sql.DataSource
     maxActive="10"
     maxIdle="20"
     macWait="10000"
     username="#####_######"
     password="#####"
     driverClassName="com.mysql.jdbc.Driver"
     url="jdbc:mysql://localhost:3306/#####_######?autoReconnect=true"
     removeAbandoned="true"
     removeAbandonedTomeout="120"
     />
</Context>

I know this is probably screwed up now so I appreciate the help I have 
had so far and would seriously appreciate any input as to how to 
straighten this out and get the connection to the database functional. I 
really need to get the site up and running today.

Thanks for your consideration and your time.

Dave

On 22/07/64 2:59 PM, Dave Filchak wrote:
> Ok, perhaps this will be more helpful. To follow is the way the db
> connection is set up now, and I am not sure it is correct because, as I
> understand it, you are supposed to add a context to the server.xml file
> defining the db connection through jdbc/mysql ( which I am not sure of
> the format yet ), either in the main system one or the application
> specific one, OR to the META-INF/content.xml file, which I do not have.
> What I do have is this, in my application directory at
> /home/XXXXXX/public_html/WEB-INF/conf/environment.xml:
>
> <jdbc-config>
> <driver>com.mysql.jdbc.Driver</driver>
> <url>jdbc:mysql://###.###.###.###:3306/#######_exodus</url>
> <user>#########_exodus</user>
> <password>#####</password>
> <max>10</max>
> <init>10</init>
> <queueQuery>select now()</queueQuery>
> <logFile>/home/#####/public_html/WEB-INF/logs/pool.txt</logFile>
> </jdbc-config>
>
> When I modify the<url>, it does show up in the error that is generated
> so the app must be reading from this entry while trying to make the
> connection to the database. I do not believe there is any other location
> where a reference to the database is made.
>
> Apparently, you are also supposed
> to add an entry in the</*CONTEXT_HOME*/>/WEB-INF/web.xml and I am not
> sure if this is true but in my/home/#####/public_html/WEB-INF/web.xml
> there is no reference to the database. However, this used to work on the
> old server. So, in a nutshell, the only reference to a database
> connection is in the environment.xml file.
>
> Dave
>
>
>
> On 22/07/64 2:59 PM, Dave Filchak wrote:
>> Hi André,
>>
>> Sorry about the comments. Wasn't thinking. So, I did find that one of
>> the closing comment tags in my web.xml was entered as ==>. Fixing that
>> gave me some progress in that the site's homepage now comes up. However,
>> I now get the following error when clicking on a few links, which
>> obviously refer to a connection to the database:
>>
>> Error initializing sub-systems:
>> Please check the following:
>> 1. That your machine has a valid connection to 
>> jdbc:mysql://localhost/########_exodus Using:
>>     Username: ########_exodus
>>     Password: ######
>>     Driver: com.mysql.jdbc.Driver
>>
>>
>> *DETAILS FOLLOW:*
>> java.lang.Exception: Unable to Initialize Environment:
>> java.lang.NoClassDefFoundError: javax/mail/Address
>>     at com.snapmedia.degrassi.base.BroadcastSystem.(Unknown Source)
>>     at com.snapmedia.degrassi.base.BroadcastSystem.(Unknown Source)
>>     at com.snapmedia.SystemController.init(SystemController.java:86)
>>     at 
>> com.snapmedia.WebSystemController.init(WebSystemController.java:39)
>>     at 
>> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
>>     at 
>> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
>>     at 
>> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3996)
>>     at 
>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4266)
>>     at 
>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
>>     at 
>> org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
>>     at 
>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
>>     at 
>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>>     at 
>> org.apache.catalina.core.StandardService.start(StandardService.java:448)
>>     at 
>> org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
>>     at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at 
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>     at 
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>     at java.lang.reflect.Method.invoke(Method.java:597)
>>     at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at 
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>     at 
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>     at java.lang.reflect.Method.invoke(Method.java:597)
>>     at 
>> org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:219)
>> Caused by: java.lang.ClassNotFoundException: javax.mail.Address
>>     at 
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1438)
>>     at 
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1284)
>>     ... 25 more
>>
>> I have verified that thew username and password are correct by logging
>> into the MySQL server from the command line. Something with the driver?
>>
>> Dave
>>
>>
>>
>> On 22/07/64 2:59 PM, André Warnier wrote:
>>> Hi.
>>>
>>> One thing at a time..
>>>
>>> 1) When you send XML configuration files, please remove everything 
>>> that is a comment.
>>> XML files are already being wrapped by the email program, and are 
>>> difficult to read as it is. Having plenty of comments in them in 
>>> addition makes is really a hassle to figure out what is being used 
>>> or not.
>>> (Note: an XML comment is anything between a pair of <!-- and --> )
>>>
>>> 2) one error message below talks about an invalid XML file.
>>> Inside one of the comments (between a leading <!-- and a trailing 
>>> -->), there is another pair of -- . That is incorrect and causes the 
>>> entire file to be rejected/ignored.
>>> Inspect that file carefully, remove the offending --, and try again.
>>>
>>> (Note: the extra -- may also be due to a previous bad edit of the 
>>> file.  It may have been a <!-- or a --> , where someone tried to 
>>> comment or de-comment something, and either removed too much or 
>>> added not enough.
>>> Remember that everything between a pair of <!-- and --> is a comment 
>>> (normally ignored), and inside of such a comment, you cannot have 
>>> another pair of -- )
>>>
>>> Do this carefully, as it may be the basic cause why the whole thing 
>>> is not working.
>>> Keep a backup of the original, for each file that you start editing.
>>>
>>> (Another note: there exist text editors which can show you if a file 
>>> is correct XML or not.  For a windows PC, look up Notepad++ in Google)
>>>
>>> 3) what happens when, in your browser, you enter the URL :
>>>
>>> http://your-host-name:8180
>>>
>>> ?
>>> (replace your-host-name by .. your real host name (or its IP address))
>>>
>>>
>>>
>>> <snip>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org