rlib-users

[Rlib-users] Rlib and PHP

[Vincent P. <vin...@co...>]

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=20
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

Re: [Rlib-users] Rlib and PHP

[Bob D. <bd...@si...>]

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
>  
>  

Re: [Rlib-users] Rlib and PHP

[Vincent P. <vin...@co...>]

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
> >
> >
>
>

Re: [Rlib-users] Rlib and PHP

[Bob D. <bd...@si...>]

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

Re: [Rlib-users] Rlib and PHP

[Vincent P. <vin...@co...>]

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
>

Re: [Rlib-users] Rlib and PHP

[Bob D. <bd...@si...>]

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

Re: [Rlib-users] Rlib and PHP

[Vincent P. <vin...@co...>]

This is a Linux Red Hat 7.3 with PHP 4.3.8 and MYSQL 4.0.17
You're right : I didn't use the --prefix donc i looked for where was the
file libr-mysql.so and the path wasn't in the file /etc/ld.so.conf ...
So I added the path in /etc/ld.so.conf and launched ldconfig and restart
apache... and it works perfectly now... Great....
Thanks a lot Bob

Vincent (Paris - France)

----- 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
>

Re: [Rlib-users] Rlib and PHP

[Vincent P. <vin...@co...>]

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
>

Re: [Rlib-users] Rlib and PHP

[Bob D. <bd...@si...>]

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

Re: [Rlib-users] Rlib and PHP

[Vincent P. <vin...@co...>]

but how to pass parameters ?
rlib_add_datasource_mysql_from_group($rlib, "mysql", "3306") ?
or
rlib_add_datasource_mysql_from_group($rlib, "mysql", "port:3306") ?

Thks

----- Original Message ----- 
From: "Bob Doan" <bd...@si...>
To: "Vincent Pinget" <vin...@co...>
Cc: "RLIB USERS" <rli...@li...>
Sent: Wednesday, August 04, 2004 3:45 PM
Subject: Re: [Rlib-users] Rlib and PHP


> 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
>
>

Re: [Rlib-users] Rlib and PHP

[Bob D. <bd...@si...>]

Actually you make an entry in a my.cnf file with the user/pw/port

and then you give it the group name.

I'm not 100% sure thats what you are looking for.

Perhaps you would need a new API function that you give it
server and port also??  It would be pretty easy to write

- bob

On Wed, 2004-08-04 at 15:57 +0200, Vincent Pinget wrote:
> but how to pass parameters ?
> rlib_add_datasource_mysql_from_group($rlib, "mysql", "3306") ?
> or
> rlib_add_datasource_mysql_from_group($rlib, "mysql", "port:3306") ?
> 
> Thks
> 
> ----- Original Message ----- 
> From: "Bob Doan" <bd...@si...>
> To: "Vincent Pinget" <vin...@co...>
> Cc: "RLIB USERS" <rli...@li...>
> Sent: Wednesday, August 04, 2004 3:45 PM
> Subject: Re: [Rlib-users] Rlib and PHP
> 
> 
> > 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
> >
> >

Re: [Rlib-users] Rlib and PHP

[Vincent P. <vin...@co...>]

Ok I see what is it the notion of group...

so :

/etc/my.cnf

[newtry]
user    = xxx
password    = ttttt
port    = blabla


and we use :
rlib_add_datasource_mysql_from_group($rlib, "mysql", "newtry")


Ok i try soon
thank Bob






----- Original Message ----- 
From: "Bob Doan" <bd...@si...>
To: "Vincent Pinget" <vin...@co...>
Cc: "RLIB USERS" <rli...@li...>
Sent: Wednesday, August 04, 2004 4:51 PM
Subject: Re: [Rlib-users] Rlib and PHP


> Actually you make an entry in a my.cnf file with the user/pw/port
>
> and then you give it the group name.
>
> I'm not 100% sure thats what you are looking for.
>
> Perhaps you would need a new API function that you give it
> server and port also??  It would be pretty easy to write
>
> - bob
>
> On Wed, 2004-08-04 at 15:57 +0200, Vincent Pinget wrote:
> > but how to pass parameters ?
> > rlib_add_datasource_mysql_from_group($rlib, "mysql", "3306") ?
> > or
> > rlib_add_datasource_mysql_from_group($rlib, "mysql", "port:3306") ?
> >
> > Thks
> >
> > ----- Original Message ----- 
> > From: "Bob Doan" <bd...@si...>
> > To: "Vincent Pinget" <vin...@co...>
> > Cc: "RLIB USERS" <rli...@li...>
> > Sent: Wednesday, August 04, 2004 3:45 PM
> > Subject: Re: [Rlib-users] Rlib and PHP
> >
> >
> > > 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
> > >
> > >
>
>

Re: [Rlib-users] Rlib and PHP

[Bob D. <bd...@si...>]

A semi example

rlib_add_datasource_mysql($rlib, "sql1", "some host", .... );
rlib_add_datasource_mysql($rlib, "sql2", "some port", .... );
rlib_add_query_as($rlib, "sql1", "select * from whatever", "q1");
rlib_add_query_as($rlib, "sql2", "select * from whatever", "q2");
rlib_add_resultset_follower($rlib, "q1", "q2");
rlib_add_report..
execute
spool

However that's not exactly what you are looking for.  The
resuletset_follower is only good when there then number of rows in the
resultsets is the same

What you are probably looking for is what I'm developing now.. the
concept of report parts.. check the archives of the mailing list for my
proposal.  I should have a prototype working with in 2 weeks or so

- bob

On Wed, 2004-08-04 at 16:28 +0200, Vincent Pinget wrote:
> It it possible to have some example with multiple mysql ressources ? In
> fact, I would like to know if it possible to have a main loop and use one of
> field of the result of the main loop in a second loop .. like :
> 
> main loop : select id1, field1, field2 from table1;
> 2nd loop : select ch1, ch2 from table2 where ch3 = id1;
> 
> 
> ----- Original Message ----- 
> From: "Bob Doan" <bd...@si...>
> To: "Vincent Pinget" <vin...@co...>
> Cc: "RLIB USERS" <rli...@li...>
> Sent: Wednesday, August 04, 2004 3:45 PM
> Subject: Re: [Rlib-users] Rlib and PHP
> 
> 
> > 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
> >
> >
> >
> > -------------------------------------------------------
> > 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
> >