Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
MIME-Version: 1.0
In-Reply-To: <f0ccb13b-ee4b-3b37-3529-675e14fc76f8@yahoo.com>
References: <CAEGPDCz63cp-zZrWK6b4636T5zTVHT1gOLK6j30H6X+KCT4=FQ@mail.gmail.com>
 <CAEGPDCyfhpR4SHOtC7dJa=QV7wuohHNKdK-UyBekLPjz1HqYAg@mail.gmail.com>
 <CAEGPDCztzwCuDjcPWchW+MdSOPJHPPEMKtWX7rsa6y=2v4OhTg@mail.gmail.com>
 <CAEGPDCw0t=451tTDEzSYWEK8GMPxVdavTuTHBxb1kSL8AsjZMg@mail.gmail.com>
 <CAEGPDCz-DvxtnOp4bMusXEHo6tnBVq-TJSMxYg11TcbQfoWVhg@mail.gmail.com>
 <604f86c5-ad77-2c47-da7a-739e155295fa@mhsoftware.com> <CAEGPDCy8hpUoQBBoLtTKM_FrRr7y1Q=hjfmTJtX9_fjV26q98Q@mail.gmail.com>
 <CAEGPDCx5gmZU15C6VCr0y9J6c8rrAM86wHVqoTJooSv+BB3a4w@mail.gmail.com>
 <57B428F3.2020405@ice-sa.com> <CAEGPDCznkYD7WmriS-1ETi1M3sY-5+FLqxTOyTOjsnKRbKE2Pw@mail.gmail.com>
 <57B43193.5080808@ice-sa.com> <CAEGPDCx55yW=X=Vk_m7xKxLG2Kpx2F6fcpUZqJEVPDwBug5pBw@mail.gmail.com>
 <CAEGPDCz5acbB+PXuAHzY+RneWJ1Dwq-SP62br8hOS75XyVE=nQ@mail.gmail.com>
 <CAEGPDCw_HBk4Vk+1GSByG+WVg0Kv6x_4Ja6G5SWw9_1gO+_q2A@mail.gmail.com>
 <57B47132.6090504@ice-sa.com> <CAEGPDCy0qBNPqq8c_kgRfYgpo9sk3b9bmVsUdLm616Sc4Fi_yA@mail.gmail.com>
 <f0ccb13b-ee4b-3b37-3529-675e14fc76f8@yahoo.com>
From: Andrew Davis <drsockmonkee@gmail.com>
Date: Wed, 17 Aug 2016 13:17:30 -0500
Message-ID: <CAEGPDCyx48mzBQBGmFeqQkG5s_XYx6k3tbCNv248CdjfitSu+Q@mail.gmail.com>
Subject: Re: Set up postgresql on tomcat7
To: Tomcat Users List <users@tomcat.apache.org>
Content-Type: multipart/alternative; boundary=94eb2c035eb680ef12053a487a33
archived-at: Wed, 17 Aug 2016 18:17:39 -0000

--94eb2c035eb680ef12053a487a33
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Sorry,
I got confused from yesterday and continued the question on my second
machine without realizing .

I have two machines.  The one I started the question with is:
Machine number 1.
Ubuntu 14.04, Tomcat7 as my web server, I have postgreSQl 9.3 installed as
my dbServer.

java version 1.8.9_91

Machine number 2
RHEL 6, Tomcat6 as web server, postgreSQL 9.3 dbServer.
java version 1.7.0_101

I am focusing my effort on the first machine.  (Ubuntu)..

Andy.


On Wed, Aug 17, 2016 at 12:47 PM, Mark Eggers <its_toasted@yahoo.com.invali=
d
> wrote:

> Replies at the end:
>
> Andrew:
>
> On 8/17/2016 7:15 AM, Andrew Davis wrote:
> > Its a redhat ..  i don't think tomcat 7 or later will run on this.
> >
> > On Aug 17, 2016 9:14 AM, "Andr=C3=A9 Warnier (tomcat)" <aw@ice-sa.com>
> > wrote:
> >
> >> On 17.08.2016 16:06, Andrew Davis wrote:
> >>
> >>> Thanks for the prompt..
> >>>
> >>> I have been looking at the doc s and have my .jar file for
> >>> postgres in the lib folder.
> >>>
> >>> I do not understand where the <Context> <Resource
> >>> name=3D"jdbc/postgres..."
> >>>
> >>> Is supposed to go.
> >>>
> >>> Im reading at
> >>> https://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-
> >>> examples-howto.html
> >>>
> >>
> >> If your version is Tomcat 7, then maybe you should look at the
> >> Tomcat 7 documentation, not the v 6 one.
> >>
> >> In any case, even Tomcat 7 is somewhat old now.  Can you upgrade to
> >> a later version ? That might increase your chances of getting help
> >> here.
> >>
> >>
> >>> This author has not had success here...
> >>>
> >>> This doesn't inspire confidence  here,  but that's what the
> >>> documentation shows...
> >>>
> >>>
> >> Sorry, but personally my expertise in these matters is nil, so I
> >> hope someone else here can pick this up now.
> >>
> >> Andy
> >>>
> >>> On Aug 17, 2016 4:43 AM, "Andr=C3=A9 Warnier (tomcat)" <aw@ice-sa.com=
>
> >>> wrote:
> >>>
> >>> On 17.08.2016 11:32, Andrew Davis wrote:
> >>>
> >>> Thanks.
> >>>>
> >>>> I can now deploy my servlets and they work ok, but..
> >>>>
> >>>> I had hoped to just deploy one copy of the postgres jar to my
> >>>> server and then be able to consume it inside multiple
> >>>> applications, instead of having multiple copies of the jar in
> >>>> multiple apps.
> >>>>
> >>>> I've been through the JNDI portion of the docs on Tomcat and
> >>>> found it still somewhat confusing.
> >>>>
> >>>> Andy...
> >>>>
> >>>>
> >>> I am far from an expert on this kind of thing, but have you
> >>> looked at this :
> >>>
> >>> http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html
> >>>
> >>>
> >>>
> Maybe that is the missing link in your understanding ?
> >>>
> >>>
> >>>
> >>>
> >>> On Aug 17, 2016 4:06 AM, "Andr=C3=A9 Warnier (tomcat)" <aw@ice-sa.com=
>
> >>> wrote:
> >>>>
> >>>> Andrew,
> >>>>
> >>>>> this list strips most kinds of attachments, so nobody saw
> >>>>> your screenshots or whatever was in them. You need to
> >>>>> copy/paste that text right into your message to the list
> >>>>> (amd make sure that you send your message as "plain text",
> >>>>> not HTML, otherwise it will be unreadable.
> >>>>>
> >>>>> On 17.08.2016 02:10, Andrew Davis wrote:
> >>>>>
> >>>>> Well,
> >>>>>
> >>>>>> This has not turned out how I wanted it to .
> >>>>>>
> >>>>>> I have 'a solution' but it isnt what I wanted to do.  I
> >>>>>> went back and re added the .jar file to the 'WEB-INF'
> >>>>>> folder and then deployed a new WAR file.
> >>>>>>
> >>>>>> Now things work just 'fine' BUT I suspect that this is not
> >>>>>> what a real coder would do and suspect I am still in the
> >>>>>> realms of hackery..
> >>>>>>
> >>>>>> [image: Inline image 1]
> >>>>>>
> >>>>>> Andy.
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis
> >>>>>> <drsockmonkee@gmail.com> wrote:
> >>>>>>
> >>>>>> I found the following in my logs..
> >>>>>>
> >>>>>>
> >>>>>>> from command line in Putty...
> >>>>>>>
> >>>>>>> cd /var/lib/tomcat7 tail -f logs/catalina.out
> >>>>>>>
> >>>>>>> [image: Inline image 1]
> >>>>>>>
> >>>>>>> I do have the jar file located in the following location
> >>>>>>> on the machine..
> >>>>>>>
> >>>>>>> /usr/share/tomcat7/lib
> >>>>>>>
> >>>>>>> https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt
> >>>>>>>
> >>>>>>>
> o.html#JDBC_Data_Sources  is confusing to me.  It shouldnt but it is..
> >>>>>>> at this point..
> >>>>>>>
> >>>>>>> Andy..
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> On Tue, Aug 16, 2016 at 3:01 PM, George Sexton <
> >>>>>>> georges@mhsoftware.com> wrote:
> >>>>>>>
> >>>>>>> The best place to start would be to look at tomcat's logs
> >>>>>>> for exceptions
> >>>>>>>
> >>>>>>> or errors.
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> On 8/16/2016 12:44 PM, Andrew Davis wrote:
> >>>>>>>>
> >>>>>>>> Hello,
> >>>>>>>>
> >>>>>>>> Im working on getting java servlets to run on my
> >>>>>>>> instance of Ububtu
> >>>>>>>>> with tomcat7.
> >>>>>>>>>
> >>>>>>>>> I write my applications in Eclipse.. when i run my
> >>>>>>>>> apps localhost i see everything just fine.
> >>>>>>>>>
> >>>>>>>>> When i export my WAR files i check the includ source
> >>>>>>>>> files.
> >>>>>>>>>
> >>>>>>>>> I deploy the WAR file through tomcat manager.
> >>>>>>>>>
> >>>>>>>>> I can see the java classes which i use to insert
> >>>>>>>>> records into my postgresql database. However,  there
> >>>>>>>>> is nothing happening.  When i attempt  to run them,
> >>>>>>>>> no joy.
> >>>>>>>>>
> >>>>>>>>> I have the postgresql .jar file installed on my
> >>>>>>>>> headless ubuntu server , but no luck.
> >>>>>>>>>
> >>>>>>>>> Aside from the .jar file is there anything else i
> >>>>>>>>> need to configure?
> >>>>>>>>>
> >>>>>>>>> Any advice is welcome
> >>>>>>>>>
> >>>>>>>>> Andy
>
> AD: Its a redhat ..  i don't think tomcat 7 or later will run on this.
>
> From your first message, I thought that this was Ubuntu? Please note
> that different Linux distributions package Tomcat differently.
>
> AD: I have the postgresql.jar file installed on my headless ubuntu
> server, but no luck.
>
> According to what I just searched for, I believe you can install Tomcat
> 7 via apt-get (depending on your Ubuntu version). Tomcat 8 also appears
> to be available via apt-get - again depending on your Ubuntu version.
>
> If you're running a RedHat 6 variant, it appears that Tomcat 6 is what's
> available.
>
> If you're running a RedHat 7 variant, it appears that Tomcat 7 is what's
> available.
>
> Please note that I install Tomcat manually for all of my systems, the
> above is just a result of searches. YMMV.
>
> AD: I have been looking at the docs and have my .jar file for postgres
> in the lib folder.
>
> Are you sure that you're placing it in the correct directory?
>
> From memory, RedHat - derived distributions set things up so that you
> can run multiple Tomcats (see RUNNING.txt in the standard distribution).
> Sometimes this means placing the JDBC jars in not-quite-so-obvious places=
.
>
> That being said, if you place the JDBC jars in the base Tomcat library
> directory, all running Tomcats (if you're running more than one) should
> pick it up.
>
> In your log, you should have two lines near the top:
>
> INFO: CATALINA_BASE: (some directory path)
> INFO: CATALINA_HOME: (some directory path)
>
> If you could, please grab those lines and paste the text (not an image)
> into your reply.
>
> The libs directory is (should be) a subdirectory of at least
> CATALINA_HOME. If you're running multiple Tomcats, their could be a libs
> directory as a subdirectory of CATALINA_BASE.
>
> The next thing to be concerned with is permissions. Tomcat runs as a
> non-privileged user (usually tomcat). Make sure that the JDBC jar file
> can be read by the user running Tomcat. Typically, this is done by
> changing the group and user ownership to the ones used by the Tomcat
> process, and NOT by making the JDBC jar world-accessible.
>
> Please do an ls -l in the directory where all of the JARS are, and paste
> the results in as text in your reply.
>
> Once all of that is sorted, we can poke around some more.
>
> . . . just my two cents
> /mde/
>
>

--94eb2c035eb680ef12053a487a33--