Menu
▾
▴
Re: [Rlib-users] Rlib and PHP
|
From: Bob D. <bd...@si...> - 2004-08-04 13:45:14
|
Right now you would have to use MYSQL Groups and use
rlib_add_datasource_mysql_from_group
- bob
On Wed, 2004-08-04 at 14:28 +0200, Vincent Pinget wrote:
> 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
> >
>
>
>
> -------------------------------------------------------
> 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
|
