Re: correct usage of properties to supply database port
> On Mar 12, 2022, at 9:59 AM, Christopher Schultz > wrote: > > Rob, > Chris, Yes I see that. Wasn’t really worried about context at the time of that post. I would argue though that the message is a tad obtuse. I’ll clean up the code generating that context.xml. Luckily it only breaks logging so far. With a proper jdbc url I get a functioning tomcat (again). Thanks to all rjs > It's right here, from your original message: > > Mar 10, 2022 8:34:32 AM org.apache.tomcat.util.digester.Digester > endElement > WARNING: No rules found matching [Context/Context/Valve] > Mar 10, 2022 8:34:32 AM org.apache.tomcat.util.digester.Digester > endElement > WARNING: No rules found matching [Context/Context] > > -chris > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: correct usage of properties to supply database port
Rob, On 3/11/22 9:13 AM, Rob Sargent wrote: On Mar 11, 2022, at 6:50 AM, Mark H. Wood wrote: On Thu, Mar 10, 2022 at 09:40:48AM -0700, Rob Sargent wrote: About context/context/value: I have this context.xml. Is the value correctly inside the outer Context? I don't think you can nest s that way, and I'm not sure what it would mean. I would remove the inner pair. -- Mark H. Wood Lead Technology Analyst Thanks. I’ll take a look at that. I don’t see any related error messages but I’ll check my logging. It's right here, from your original message: Mar 10, 2022 8:34:32 AM org.apache.tomcat.util.digester.Digester endElement WARNING: No rules found matching [Context/Context/Valve] Mar 10, 2022 8:34:32 AM org.apache.tomcat.util.digester.Digester endElement WARNING: No rules found matching [Context/Context] -chris - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
correct usage of properties to supply database port
On 3/11/2022 9:40 AM, Rob Sargent wrote: On Mar 11, 2022, at 8:17 AM, Thomas Hoffmann (Speed4Trade GmbH) wrote: -Ursprüngliche Nachricht- Von: Rob Sargent Gesendet: Freitag, 11. März 2022 15:14 An: Tomcat Users List Betreff: Re: correct usage of properties to supply database port On Mar 11, 2022, at 6:50 AM, Mark H. Wood wrote: On Thu, Mar 10, 2022 at 09:40:48AM -0700, Rob Sargent wrote: About context/context/value: I have this context.xml. Is the value correctly inside the outer Context? I don't think you can nest s that way, and I'm not sure what it would mean. I would remove the inner pair. -- Mark H. Wood Lead Technology Analyst Thanks. I’ll take a look at that. I don’t see any related error messages but I’ll check my logging. Thanks Nesting of Context is not allowed as far as I know. The documentation tells, which parent nodes/Elements are allowed , e.g. valve: https://tomcat.apache.org/tomcat-10.0-doc/config/valve.html only allowed in host, Context or Engine Element. Ok. Thanks for digging in to that. I am not able to investigate (or correct) at the moment Related warnings from your initial post: WARNING: No rules found matching [Context/Context/Valve] WARNING: No rules found matching [Context/Context] -Terence Bandoian - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: correct usage of properties to supply database port
> On Mar 11, 2022, at 8:17 AM, Thomas Hoffmann (Speed4Trade GmbH)
> wrote:
>
>
>
>> -Ursprüngliche Nachricht-
>> Von: Rob Sargent
>> Gesendet: Freitag, 11. März 2022 15:14
>> An: Tomcat Users List
>> Betreff: Re: correct usage of properties to supply database port
>>
>>
>>
>>>> On Mar 11, 2022, at 6:50 AM, Mark H. Wood wrote:
>>>
>>> On Thu, Mar 10, 2022 at 09:40:48AM -0700, Rob Sargent wrote:
>>>> About context/context/value: I have this context.xml. Is the value
>>>> correctly inside the outer Context?
>>>>
>>>>
>>>>
>>>> >>> name="jdbc/sgsdb/tbar"
>>>> url="jdbc:postgresql://localhost:5432:/tbar"
>>>> driverClassName="org.postgresql.Driver"
>>>> type="javax.sql.DataSource"
>>>> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
>>>> testWhileIdle="false"
>>>> testOnBorrow="true"
>>>> testOnReturn="false"
>>>> validationInterval="3"
>>>> validationQuery="select 1"
>>>> timeBetweenEvictionRunsMillis="3"
>>>> maxActive="50"
>>>> initialSize="3"
>>>> maxWait="1"
>>>> removeAbandonedTimeout="3600"
>>>> removeAbandoned="true"
>>>> minEvictableIdleTimeMillis="3"
>>>> minIdle="1"
>>>> maxIdle="5"
>>>> logAbandoned="true"
>>>> username="shoc"
>>>> password="password"
>>>> />
>>>>
>>>>
>>>>>>>className="org.apache.catalina.valves.AccessLogValve"
>>>>prefix="sgs_access"
>>>>directory="${SGSSRVR_AccessLogDir}"
>>>>maxDays="7">
>>>>
>>>>
>>>>
>>>
>>> I don't think you can nest s that way, and I'm not sure what
>>> it would mean. I would remove the inner pair.
>>>
>>> --
>>> Mark H. Wood
>>> Lead Technology Analyst
>>
>> Thanks. I’ll take a look at that. I don’t see any related error messages but
>> I’ll
>> check my logging.
>> Thanks
>>
>>
> Nesting of Context is not allowed as far as I know.
> The documentation tells, which parent nodes/Elements are allowed , e.g. valve:
> https://tomcat.apache.org/tomcat-10.0-doc/config/valve.html
> only allowed in host, Context or Engine Element.
>
>
Ok. Thanks for digging in to that. I am not able to investigate (or correct) at
the moment
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
AW: correct usage of properties to supply database port
> -Ursprüngliche Nachricht-
> Von: Rob Sargent
> Gesendet: Freitag, 11. März 2022 15:14
> An: Tomcat Users List
> Betreff: Re: correct usage of properties to supply database port
>
>
>
> > On Mar 11, 2022, at 6:50 AM, Mark H. Wood wrote:
> >
> > On Thu, Mar 10, 2022 at 09:40:48AM -0700, Rob Sargent wrote:
> >> About context/context/value: I have this context.xml. Is the value
> >> correctly inside the outer Context?
> >>
> >>
> >>
> >>>> name="jdbc/sgsdb/tbar"
> >> url="jdbc:postgresql://localhost:5432:/tbar"
> >> driverClassName="org.postgresql.Driver"
> >> type="javax.sql.DataSource"
> >> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> >> testWhileIdle="false"
> >> testOnBorrow="true"
> >> testOnReturn="false"
> >> validationInterval="3"
> >> validationQuery="select 1"
> >> timeBetweenEvictionRunsMillis="3"
> >> maxActive="50"
> >> initialSize="3"
> >> maxWait="1"
> >> removeAbandonedTimeout="3600"
> >> removeAbandoned="true"
> >> minEvictableIdleTimeMillis="3"
> >> minIdle="1"
> >> maxIdle="5"
> >> logAbandoned="true"
> >> username="shoc"
> >> password="password"
> >> />
> >>
> >>
> >> >> className="org.apache.catalina.valves.AccessLogValve"
> >> prefix="sgs_access"
> >> directory="${SGSSRVR_AccessLogDir}"
> >> maxDays="7">
> >>
> >>
> >>
> >
> > I don't think you can nest s that way, and I'm not sure what
> > it would mean. I would remove the inner pair.
> >
> > --
> > Mark H. Wood
> > Lead Technology Analyst
>
> Thanks. I’ll take a look at that. I don’t see any related error messages but
> I’ll
> check my logging.
> Thanks
>
>
Nesting of Context is not allowed as far as I know.
The documentation tells, which parent nodes/Elements are allowed , e.g. valve:
https://tomcat.apache.org/tomcat-10.0-doc/config/valve.html
only allowed in host, Context or Engine Element.
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
Re: correct usage of properties to supply database port
> On Mar 11, 2022, at 6:50 AM, Mark H. Wood wrote:
>
> On Thu, Mar 10, 2022 at 09:40:48AM -0700, Rob Sargent wrote:
>> About context/context/value: I have this context.xml. Is the value
>> correctly inside the outer Context?
>>
>>
>>
>> > name="jdbc/sgsdb/tbar"
>> url="jdbc:postgresql://localhost:5432:/tbar"
>> driverClassName="org.postgresql.Driver"
>> type="javax.sql.DataSource"
>> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
>> testWhileIdle="false"
>> testOnBorrow="true"
>> testOnReturn="false"
>> validationInterval="3"
>> validationQuery="select 1"
>> timeBetweenEvictionRunsMillis="3"
>> maxActive="50"
>> initialSize="3"
>> maxWait="1"
>> removeAbandonedTimeout="3600"
>> removeAbandoned="true"
>> minEvictableIdleTimeMillis="3"
>> minIdle="1"
>> maxIdle="5"
>> logAbandoned="true"
>> username="shoc"
>> password="password"
>> />
>>
>>
>> > className="org.apache.catalina.valves.AccessLogValve"
>> prefix="sgs_access"
>> directory="${SGSSRVR_AccessLogDir}"
>> maxDays="7">
>>
>>
>>
>
> I don't think you can nest s that way, and I'm not sure what
> it would mean. I would remove the inner pair.
>
> --
> Mark H. Wood
> Lead Technology Analyst
Thanks. I’ll take a look at that. I don’t see any related error messages but
I’ll check my logging.
Thanks
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
Re: correct usage of properties to supply database port
On Thu, Mar 10, 2022 at 09:40:48AM -0700, Rob Sargent wrote:
> About context/context/value: I have this context.xml. Is the value
> correctly inside the outer Context?
>
>
>
> name="jdbc/sgsdb/tbar"
> url="jdbc:postgresql://localhost:5432:/tbar"
> driverClassName="org.postgresql.Driver"
> type="javax.sql.DataSource"
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> testWhileIdle="false"
> testOnBorrow="true"
> testOnReturn="false"
> validationInterval="3"
> validationQuery="select 1"
> timeBetweenEvictionRunsMillis="3"
> maxActive="50"
> initialSize="3"
> maxWait="1"
> removeAbandonedTimeout="3600"
> removeAbandoned="true"
> minEvictableIdleTimeMillis="3"
> minIdle="1"
> maxIdle="5"
> logAbandoned="true"
> username="shoc"
> password="password"
> />
>
>
> className="org.apache.catalina.valves.AccessLogValve"
> prefix="sgs_access"
> directory="${SGSSRVR_AccessLogDir}"
> maxDays="7">
>
>
>
I don't think you can nest s that way, and I'm not sure what
it would mean. I would remove the inner pair.
--
Mark H. Wood
Lead Technology Analyst
University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu
signature.asc
Description: PGP signature
Re: correct usage of properties to supply database port
I think I see the problem: and extra colon has snuck in to the url - localhost:5432*":"*/tbar Sorry for the noise. On 3/10/22 09:40, Rob Sargent wrote: Using tomcat 9.0.58 I have a propertiesfile supplied to my embedded tomcat which includes SGSSRVR_databasePort = 5432 SGSSRVR_databaseHost = localhost
correct usage of properties to supply database port
Using tomcat 9.0.58 I have a propertiesfile supplied to my embedded
tomcat which includes
SGSSRVR_databasePort = 5432
SGSSRVR_databaseHost = localhost
and in my app-specific web.xml I have
databaseHost
${SGSSRVR_databaseHost}
java.lang.String
databasePort
${SGSSRVR_databasePort}
java.lang.Integer
but at tomcat startup several warnings which confuse me and a fatal error:
INFO: Starting service [Tomcat]
Mar 10, 2022 8:34:32 AM org.apache.catalina.core.StandardEngine
startInternal
INFO: Starting Servlet engine: [Apache Tomcat/9.0.59]
Mar 10, 2022 8:34:32 AM org.apache.tomcat.util.digester.Digester
endElement
WARNING: No rules found matching [Context/Context/Valve]
Mar 10, 2022 8:34:32 AM org.apache.tomcat.util.digester.Digester
endElement
WARNING: No rules found matching [Context/Context]
Mar 10, 2022 8:34:32 AM org.apache.catalina.startup.ContextConfig
getDefaultWebXmlFragment
INFO: No global web.xml found
Mar 10, 2022 8:34:33 AM org.postgresql.util.PGPropertyUtil
convertPgPortToInt
WARNING: JDBC URL invalid port number:
Mar 10, 2022 8:34:33 AM org.apache.tomcat.jdbc.pool.ConnectionPool init
SEVERE: Unable to create initial connections of pool.
java.sql.SQLException: Driver:org.postgresql.Driver@1ecfa525
returned null for URL:jdbc:postgresql://localhost:5432:/tbar
The main surprise to me is the "invalid port number". Am I correct in
using the ${property-name} in web.xml? The main() reads the properties
file, for sure.
About context/context/value: I have this context.xml. Is the value
correctly inside the outer Context?
