Re: [Rlib-users] Rlib and PHP

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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