Newbie mysql question

>
>
>
> Hello,
>
> Apologies for the newbie questions, but I have searched the user guide, the
> web, and the list archives and not found what I need.  I must be overlooking
> something somewhere because people have been over this ground before.  I
> need to query a mysql database, and I wonder you could point me to a decent
> example of a mysql configuration to get me started.  Also, in my installed
> ops instance, none of my db examples, such as address book and employees,
> work because of the non-existence of the orbeondb.properties file.  I can't
> find any info about that file either, where it goes or what should be in
> it...
>
> Thanks,
>  Paul
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>

> Subject: Re: [ops-users] Newbie mysql question
>
> Hi Paul,
>
> Let's start with your first problem: the database examples
> not working. You say that orbeondb.properties file is
> missing. This file seems to be created by HSQLDB (the
> embedded SQL database we are using) in the "current
> directory". This is typically the Tomcat bin directory if you
> are using Tomcat and starting it from there. What does the
> message say exactly? Can your VM write to the "current directory"?
>
> Alex
>
> On 8/10/06, Paul Warner <[hidden email]> wrote:
> >
> >
> >
> > Hello,
> >
> > Apologies for the newbie questions, but I have searched the user
> > guide, the web, and the list archives and not found what I need.  I
> > must be overlooking something somewhere because people have
> been over
> > this ground before.  I need to query a mysql database, and I wonder
> > you could point me to a decent example of a mysql
> configuration to get
> > me started.  Also, in my installed ops instance, none of my db
> > examples, such as address book and employees, work because of the
> > non-existence of the orbeondb.properties file.  I can't
> find any info
> > about that file either, where it goes or what should be in it...
> >
> > Thanks,
> >  Paul
> >
> > --
> > You receive this message as a subscriber of the
> > [hidden email] mailing list.
> > To unsubscribe: mailto:[hidden email]
> > For general help: mailto:[hidden email]?subject=help
> > ObjectWeb mailing lists service home page:
> > http://www.objectweb.org/wws
> >
> >
> >
>
>
> --
> Blog (XML, Web apps, Open Source):
> http://www.orbeon.com/blog/
>
>

> -----Original Message-----
> From: Paul Warner [mailto:[hidden email]]
> Sent: 11 August 2006 14:27
> To: [hidden email]
> Cc: Nick Mattin
> Subject: RE: [ops-users] Newbie mysql question
>
> Hi Alex,
>
> Thanks very much for your help.  Indeed it is a permission
> denied error.  I've attached the output of my address-book
> page as a zipped html page so you can take a look.  
>
> I have a tomcat5 installation based on a Redhat EL 3 rpm that
> has been installed by my sys admin, who prefers Redhat rpm's
> because it makes updates, etc. easier.
> However, for default configuration of applications which
> assume that all the tomcat stuff can be found in a single
> directory under a default configuration, it creates problems.
>  My tomcat init file is in /etc/rc.d/init.d, and it invokes a
> script in /usr/bin when starting up.  These are definitely
> not the 'startup.sh' or 'shutdown.sh' files you find in
> regular tomcat installs.  And of course, these directories
> are not available to the tomcat user for writing.  The
> tomcat5 bin directory is under /usr/share/tomcat5/.  I
> changed ownership and permissions to allow tomcat to write to
> this directory, but the file didn't appear and the error
> persisted.  CATALINA_HOME = /usr/share/tomcat5, and this is
> definitely writable by the tomcat user, for what it's worth.
>
> I looked at the HSQLDB documentation, and as they suggest,
> read through the current (1.8) version of
> org.hsqldb.Servlet.java.  I changed my ops/WEB-INF/web.xml to
> include a new init-param (hsqldb.server.use_web-inf_path) for
> the hslqdb-servlet, setting it to 'true' (see excerpt below),
> hoping that the orbeondb.properties file would be created in
> my /usr/lib/tomcat5/webapps/ops/WEB-INF directory.  This got
> some results, although not functional ones.  I now have 3
> files under webapps/ops called WEB-INForbeondb.lck
> WEB-INForbeondb.log WEB-INForbeondb.properties
>
> I tried copying the log and properties files into the WEB-INF
> directory as orbeondb.log and orbeondb.properties, but I'm
> still getting the same error when I try to run the
> address-book.  It looks to me like a typo in the
> org.hsqldb.Servlet.java in the orbeon jar file, missing the
> final '/' after WEB-INF.  How can I get the source for that
> so I can experiment and try fixing it?
>
> Thanks again for the help!
>
> Regards,
> Paul
>
>
> <!-- Uncomment this for the SQL examples -->
>     <servlet>
>         <servlet-name>hsqldb-servlet</servlet-name>
>         <servlet-class>org.hsqldb.Servlet</servlet-class>
>         <init-param>
>             <param-name>hsqldb.server.use_web-inf_path</param-name>
>             <param-value>true</param-value>
>         </init-param>
>         <init-param>
>             <param-name> hsqldb.server.database</param-name>
>             <param-value>orbeondb</param-value>
>         </init-param>
>         <load-on-startup>4</load-on-startup>
>     </servlet>
>     <!-- End SQL examples -->
>
>
> > Subject: Re: [ops-users] Newbie mysql question
> >
> > Hi Paul,
> >
> > Let's start with your first problem: the database examples not
> > working. You say that orbeondb.properties file is missing.
> This file
> > seems to be created by HSQLDB (the embedded SQL database we
> are using)
> > in the "current directory". This is typically the Tomcat
> bin directory
> > if you are using Tomcat and starting it from there. What does the
> > message say exactly? Can your VM write to the "current directory"?
> >
> > Alex
> >
> > On 8/10/06, Paul Warner <[hidden email]> wrote:
> > >
> > >
> > >
> > > Hello,
> > >
> > > Apologies for the newbie questions, but I have searched the user
> > > guide, the web, and the list archives and not found what
> I need.  I
> > > must be overlooking something somewhere because people have
> > been over
> > > this ground before.  I need to query a mysql database,
> and I wonder
> > > you could point me to a decent example of a mysql
> > configuration to get
> > > me started.  Also, in my installed ops instance, none of my db
> > > examples, such as address book and employees, work because of the
> > > non-existence of the orbeondb.properties file.  I can't
> > find any info
> > > about that file either, where it goes or what should be in it...
> > >
> > > Thanks,
> > >  Paul
> > >
> > > --
> > > You receive this message as a subscriber of the
> > > [hidden email] mailing list.
> > > To unsubscribe: mailto:[hidden email]
> > > For general help: mailto:[hidden email]?subject=help
> > > ObjectWeb mailing lists service home page:
> > > http://www.objectweb.org/wws
> > >
> > >
> > >
> >
> >
> > --
> > Blog (XML, Web apps, Open Source):
> > http://www.orbeon.com/blog/
> >
> >
>