Hi Nicholas, here's an FYI.  I was using SLES 9 with SP3 on an x86
box.  I was able to connect to the MySQL database on the remote server
by upgrading the mysql-client package using this command:
rpm -U MySQL-client-community-5.0.45-0.sles9.i586.rpm

Then, I restarted the MySQL service:
/etc/init.d/mysql restart

After that, I verified I did not get that error anymore about MySQL
client being out of date:
mysql -h dbserverIP -u jasmine -p print

I entered in the password and got in!  However, the printer and CUPS
still says it cant connect to the MySQL database server.  This was in
/var/log/messages:

Nov 15 11:52:25 chpas-lansvcs jasmine[11320]: Warning: Debug mode is
activated, you should turn it off when going to production ! To do so,
set $Debug_Mode to 0 in the /usr/lib64/cups/backend/jasmine perl
script.
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]: ---> Print job started
at Thu Nov 15 11:52:25 2007
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Command line:
/usr/lib64/cups/backend/jasmine
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Arguments: 19691||Test
Page|1||/var/spool/cups/d19691-001
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Environnement:
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - IPP_PORT= 631
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - RIP_MAX_CACHE= 8m
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - CUPS_FONTPATH=
/usr/share/cups/fonts
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - USER= root
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - LANG= en_US
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - PPD=
/etc/cups/ppd/chpaa-3100cna.ppd
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - CHARSET= utf-8
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - CONTENT_TYPE=
application/postscript
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - PRINTER= chpaa-3100cna
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - CUPS_SERVER= localhost
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - CUPS_DATADIR=
/usr/share/cups
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - PATH=
/usr/lib64/cups/filter:/bin:/usr/bin
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - TMPDIR= /var/spool/cups/tmp
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - SOFTWARE= CUPS/1.1
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - DEVICE_URI=
jasmine:socket://192.168.10.69:9100/
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:     - CUPS_SERVERROOT= /etc/cups
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Called with 6 args,
$doc is /var/spool/cups/d19691-001
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Document:
/var/spool/cups/d19691-001
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Analyzer returned: 0
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Analyzing successful !
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Number of pages: 1
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   $real_uri=
socket://192.168.10.69:9100/
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   $real_backend= socket
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Calling backend:
/usr/lib64/cups/backend/socket socket://192.168.10.69:9100/ 19691
Test Page 1  /var/spool/cups/d19691-001
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]: Real backend returned: 0
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]: Printing successful on
socket://192.168.10.69:9100/ !
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]: User '' printed 1 pages
on printer 'chpaa-3100cna'
Nov 15 11:52:25 chpas-lansvcs jasmine[11320]:   Couldn't connect to
the MySQL server !




Thanks.


On Nov 9, 2007 9:26 AM, Chris Harner <[EMAIL PROTECTED]> wrote:
> All of the print servers are the same, unfortunately.  I'll try
> updating MySQL on that box and get back to you.  Thanks for being
> patient Nicolas.
>
>
> On Nov 9, 2007 8:38 AM, Nicolas Costes <[EMAIL PROTECTED]> wrote:
> >
> > Le vendredi 9 novembre 2007, Chris Harner a écrit:
> > > MySQL versions:
> > > DB Server- 5.0.18
> > > Print Server- 4.0.18
> > >
> > > I'm assuming the printer server needs an update.  I hate to mess with
> > > our production PDC.  Thanks Nicolas.
> > > -Harner
> >
> > You could try setting up another small DB server, or installing it on the
> > print server... Well, it's up to you, now.
> >
> > Do not hesitate to tell us the end of the story ;-)
> >
> >
> >
> > Nicolas.
> >
> >
> >
> >
> > --
> > Put JASmine in your Cups !
> >
> > To unsubscribe :
> >   mailto:[EMAIL PROTECTED]
> > List archives :
> >   http://dir.gmane.org/gmane.comp.printing.jasmine.user
> >   http://www.mail-archive.com/jasmine%40ml.free.fr/
> > Web site :
> >   http://jasmine.berlios.de/
> >
> >
> >
> >
>
>
>
>
> --
> Chris Harner  []  Server Engineer  []  Arnold Transportation Services
>



-- 
Chris Harner  []  Server Engineer  []  Arnold Transportation Services

-- 
Put JASmine in your Cups !

To unsubscribe :
  mailto:[EMAIL PROTECTED]
List archives :
  http://dir.gmane.org/gmane.comp.printing.jasmine.user
  http://www.mail-archive.com/jasmine%40ml.free.fr/
Web site :
  http://jasmine.berlios.de/



Reply via email to