Re: [Rlib-users] Rlib and PHP

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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