|
From: Vincent P. <vin...@co...> - 2004-08-04 12:29:18
|
Now it is working fine via a web server ---
My script (see below) succes to connect a Mysql via "normal" connection...
Do you know how to specify a Mysql port different thant 3306 ! I saw inside
the source of rlib the notion of mysql.options->port but i didn't know how
to specify it in PHP ....
Thanks again...
<?
dl ("librlib.so");
$format = "html";
$sql_host = "localhost";
$sql_users = "xxxx";
$sql_password = "";
$sql_database = "test";
$rlib = rlib_init();
rlib_add_datasource_mysql($rlib, "mysql", $sql_host,
$sql_users,$sql_password, $sql_database);
rlib_add_query_as($rlib, "mysql", "select * from example", "example");
...
?>
----- Original Message -----
From: "Bob Doan" <bd...@si...>
To: "Vincent Pinget" <vin...@co...>
Cc: "RLIB USERS" <rli...@li...>
Sent: Tuesday, August 03, 2004 4:04 PM
Subject: Re: [Rlib-users] Rlib and PHP
> Ahhh.. Ok
>
> What type of system is this on?
>
> And what prefix did you install rlib in?
>
> It's a prefix apache can't see.
>
> Typically look in /etc/ld.so.conf to see what are the normal LD prefix's
> and if libr-mysql isn't there apache won't know about it. If thats the
> case the easiest thing to do is install rlib in a place where apache can
> find it.
>
> - bob
>
> On Tue, 2004-08-03 at 09:28 +0200, Vincent Pinget wrote:
> > Hi,
> >
> > I tried with all formats but it didn't work via the web server (but all
> > works via the command line)
> >
> > I saw this in the error_log of Apache :
> > Could Not Load MYSQL Input [libr-mysql.so: cannot open shared object
file:
> > No such file or directory]
> > [Tue Aug 3 09:38:37 2004] [notice] child pid 14090 exit signal
Segmentation
> > fault (11)
> >
> > Does it mean something ??
> > The modification I done in the util.h is wrong ??
> >
> > Thanks
> >
> > ----- Original Message -----
> > From: "Bob Doan" <bd...@si...>
> > To: "Vincent Pinget" <vin...@co...>
> > Cc: "RLIB USERS" <rli...@li...>
> > Sent: Monday, August 02, 2004 4:44 PM
> > Subject: Re: [Rlib-users] Rlib and PHP
> >
> >
> > > Try HTML output please.. If that works then try
> > >
> > > http://www.sicompos.com/~bdoan/rlib-1.2.1.tar.gz
> > >
> > > with PDF
> > >
> > > We found a bug w/ content types and IE w/ PDF
> > >
> > > Some versions of IE require a content type of PDF and a content-size
> > >
> > > We will have an official release out the door soon
> > >
> > > -bob
> > >
> > > On Mon, 2004-08-02 at 16:25 +0200, Vincent Pinget wrote:
> > > > No message in the error_log and in the acces_log file i have :
> > > > 192.168.201.2 - - [02/Aug/2004:16:28:10 +0200] "GET /essai.php
HTTP/1.1"
> > 200
> > > > 5
> > > >
> > > > The script used is :
> > > >
> > > > <?
> > > > dl ("librlib.so");
> > > > $format = "html";
> > > >
> > > > $sql_host = "localhost";
> > > > $sql_users = "xxxx";
> > > > $sql_password = "";
> > > > $sql_database = "test";
> > > >
> > > > $rlib = rlib_init();
> > > > rlib_add_datasource_mysql($rlib, "mysql", $sql_host, $sql_users,
> > > > $sql_password, $sql_database);
> > > > rlib_add_query_as($rlib, "mysql", "select * from example",
"example");
> > > > rlib_add_report($rlib, "report.xml");
> > > > rlib_set_output_format_from_text($rlib, $format);
> > > >
> > > > rlib_execute($rlib);
> > > > header( rlib_get_content_type($rlib));
> > > >
> > > > rlib_spool($rlib);
> > > > rlib_free($rlib);
> > > >
> > > > ?>
> > > >
> > > > and nothing append when i called it via Internet Explorer
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Bob Doan" <bd...@si...>
> > > > To: "Vincent Pinget" <vin...@co...>
> > > > Cc: "RLIB USERS" <rli...@li...>
> > > > Sent: Monday, August 02, 2004 3:09 PM
> > > > Subject: Re: [Rlib-users] Rlib and PHP
> > > >
> > > >
> > > > > Hi,
> > > > >
> > > > > What's in your apache error_log/message_log and what web browser
are
> > you
> > > > > testing with?
> > > > >
> > > > > - bob
> > > > >
> > > > > On Mon, 2004-08-02 at 14:22 +0200, Vincent Pinget wrote:
> > > > > > Hi,
> > > > > >
> > > > > > I have compiled Rlib with Mysql, PHP and CPDF.. It was fine and
the
> > > > > > example from the documentation work fine if i lauched it from
the
> > > > > > command line... but i didn't success to lauch in from the
explorer
> > via
> > > > > > website...
> > > > > >
> > > > > > works :
> > > > > > shell > php report.php
> > > > > > and generate a PDF
> > > > > >
> > > > > > DON't WORK
> > > > > > http://serveur/report.php
> > > > > >
> > > > > > Please, could you tell me what is happening...
> > > > > >
> > > > > > More information :
> > > > > > When i lauched via command line, there were always text file - i
> > > > > > looked the source code and i saw the function r_debug ... so i
put
> > at
> > > > > > the begin of the file util.h the line :
> > > > > > #define DISABLERDEBUG 1
> > > > > > to desactive the output from r_debug, but it changed anything to
my
> > > > > > problem...
> > > > > >
> > > > > > Thanks for your help
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > This SF.Net email is sponsored by OSTG. Have you noticed the changes
on
> > > > Linux.com, ITManagersJournal and NewsForge in the past few weeks?
Now,
> > > > one more big change to announce. We are now OSTG- Open Source
Technology
> > > > Group. Come see the changes on the new OSTG site. www.ostg.com
> > > > _______________________________________________
> > > > Rlib-users mailing list
> > > > Rli...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by OSTG. Have you noticed the changes
on
> > > Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> > > one more big change to announce. We are now OSTG- Open Source
Technology
> > > Group. Come see the changes on the new OSTG site. www.ostg.com
> > > _______________________________________________
> > > Rlib-users mailing list
> > > Rli...@li...
> > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by OSTG. Have you noticed the changes on
> > Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> > one more big change to announce. We are now OSTG- Open Source Technology
> > Group. Come see the changes on the new OSTG site. www.ostg.com
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by OSTG. Have you noticed the changes on
> Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> one more big change to announce. We are now OSTG- Open Source Technology
> Group. Come see the changes on the new OSTG site. www.ostg.com
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
>
|