Re: ODBC text
Bob Doan <bdoan-J0aWFLYJOWhWk0Htik3J/[email protected]>
| Newsgroups | gmane.text.rlib.user |
|---|---|
| Message-ID | <[email protected]> |
Ok.. now I need a stack trace after it crashes you should have core.xxxxx run gdb /usr/bin/php core.xxxxxxxxx when you get to the gdb prompt type: bt then send me the output Thanks! - bob On Wed, 2004-12-08 at 18:32 -0300, Cláudio Fortier wrote: > Hi, Bob. > > Using command line i correct some params errors and now the script has returned the folow: > > #php array_oracle.php > > Setting output encoding to ISO-8859-1 > Setting locale to [LC_CTYPE=pt_BR;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_MESSAGES=C;LC_PAPER=C;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;LC_IDENTIFICATION=C] FAILEDencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... using en_USencoding is NULL or invalid > [C]... using en_US** NUTS.. WE CRASHED > Sair (core dumped) > > ------------------- reply --------------- > > From: bdoan-J0aWFLYJOWhWk0Htik3J/[email protected] > > To: cfortier-Clp0QaBocuhfJ/[email protected] > > Cc: [email protected] > > Subject: Re: [Rlib-users] ODBC text > > Date: 2004-12-08 10:57:46 > > ---------------------------------- > > Can you run it from the command line so I can see the exact error > > messages? > > > > - bob > > > > On Wed, 2004-12-08 at 06:52 -0300, Cláudio Fortier wrote: > > > Of course. There are the scrip and xml files: > > > > > > array_oracle.php > > > <? dl ("librlib.so"); > > > $rlib = rlib_init(); > > > rlib_add_datasource_odbc($rlib, "odbcsusfacil", "u_susfacil", "u_susfacil"); > > > rlib_add_query_as($rlib, "odbcsusfacil", "select * from ten_pac_paciente", "ten_pac_paciente"); > > > rlib_add_report($rlib, "array_oracle.xml", "ten_pac_paciente"); > > > rlib_set_output_format_from_text($rlib, "pdf"); > > > rlib_execute($rlib); > > > header(rlib_get_content_type($rlib)); > > > rlib_spool($rlib); > > > rlib_free($rlib); > > > ?> > > > > > > array_oracle.xml > > > <?xml version="1.0"?> > > > <!DOCTYPE report > > > > <Report fontSize="9" orientation="landscape"> > > > <Alternate> > > > <NoData> > > > <Output> > > > <Line fontSize="12"> > > > <literal>NO DATA</literal> > > > </Line> > > > </Output> > > > </NoData> > > > </Alternate> > > > <ReportHeader> > > > <Output> > > > <Line fontSize="11"> > > > <literal>Test Report (Normal) AND THE REPORT FORMAT IS: </literal> > > > <field value="r.format" width="20"/> > > > <field value="eval('1+2')" width="20"/> > > > </Line> > > > <Line fontSize="11"> > > > <literal bold="yes">Test Report (Bold)</literal> > > > </Line> > > > <Line fontSize="11"> > > > <literal italics="yes">Test Report (Italics)</literal> > > > </Line> > > > <Line fontSize="11"> > > > <literal bold="yes" italics="yes">Test Report (Bold and Italics)</literal> > > > </Line> > > > <HorizontalLine size="4" bgcolor="'white'"/> > > > </Output> > > > </ReportHeader> > > > <Breaks> > > > <Break name="break0" newpage="no" headernewpage="yes"> > > > <BreakHeader> > > > <Output> > > > <Line> > > > <field value="group" width="20" align="left" col="1"/> > > > </Line> > > > </Output> > > > </BreakHeader> > > > <BreakFields> > > > <BreakField value="group"/> > > > </BreakFields> > > > <BreakFooter> > > > <Output> > > > <HorizontalLine size="4" bgcolor="'white'"/> > > > <HorizontalLine size="2" bgcolor="'black'"/> > > > <HorizontalLine size="4" bgcolor="'white'"/> > > > <Line> > > > <field value="group" width="20" align="left" col="1"/> > > > </Line> > > > <HorizontalLine size="4" bgcolor="'white'"/> > > > <HorizontalLine size="2" bgcolor="'black'"/> > > > <HorizontalLine size="4" bgcolor="'white'"/> > > > </Output> > > > </BreakFooter> > > > </Break> > > > </Breaks> > > > <Detail> > > > <FieldHeaders> > > > <Output> > > > <HorizontalLine size="1" bgcolor="'black'"/> > > > <Line bgcolor="'0xe5e5e5'"> > > > <literal width="20" col="1">First Name</literal> > > > <literal width="1"/> > > > <literal width="20" col="2">Last Name</literal> > > > <literal width="1"/> > > > <literal width="20" col="3">Color</literal> > > > </Line> > > > <HorizontalLine size="1" bgcolor="'black'"/> > > > <HorizontalLine size="4" bgcolor="'white'"/> > > > </Output> > > > </FieldHeaders> > > > <FieldDetails> > > > <Output> > > > <Line bgcolor="iif(r.detailcnt%2,'0xe5e5e5','white')"> > > > <field value="PAC_PK_INT_CODIGO" width="20" align="left" col="1"/> > > > <literal width="1"/> > > > <field value="PAC_CHR_NOME" width="20" align="left" col="2"/> > > > <literal width="1"/> > > > <field value="PAC_CHR_TELEFONE" width="20" align="left" col="3"/> > > > </Line> > > > </Output> > > > </FieldDetails> > > > </Detail> > > > > > > <PageFooter> > > > <Output> > > > <Line> > > > <literal>Page: </literal> > > > <field value="r.pageno" width="3" align="right"/> > > > </Line> > > > </Output> > > > </PageFooter> > > > > > > <ReportFooter> > > > </ReportFooter> > > > </Report> > > > > > > > > > ------------------- reply --------------- > > > > From: bdoan-J0aWFLYJOWhWk0Htik3J/[email protected] > > > > To: cfortier-Clp0QaBocuhfJ/[email protected] > > > > Cc: [email protected] > > > > Subject: Re: [Rlib-users] ODBC text > > > > Date: 2004-12-07 18:15:15 > > > > ---------------------------------- > > > > Can I see the php file you created for RLIB causes the error? > > > > > > > > - bob > > > > > > > > On Tue, 2004-12-07 at 17:52 -0300, Cláudio Fortier wrote: > > > > > Hi, Bob. > > > > > > > > > > I'm using Linux RedHat 8. > > > > > > > > > > Yes the PHP standalone ODBC test works. > > > > > > > > > > The PHP RLIB example array.php works too. > > > > > > > > > > There is the RLIB configuration: > > > > > > > > > > > > > > > rlib-1.3.0: > > > > > > > > > > prefix: /usr/local > > > > > compiler: gcc > > > > > Memory debugging: no > > > > > Warning Fun: no > > > > > Crash detection: yes > > > > > UTF8 disabled: no > > > > > > > > > > INPUTS: > > > > > MYSQL: yes > > > > > POSTGRE: yes > > > > > ODBC: yes > > > > > > > > > > OUTPUTS: > > > > > PDF: yes > > > > > HTML: Always > > > > > CSV: Always > > > > > TEXT: Always > > > > > > > > > > BINDINGS: > > > > > PHP: yes > > > > > PHP entension dir: /usr/local/lib/php/extensions/no-debug-non-zts > > > > > -20020429 > > > > > PYTHON: no > > > > > PYTHON version: 2.2 > > > > > PYTHON entension dir: > > > > > JAVA: no > > > > > PERL: no > > > > > PERL entension dir: > > > > > > > > > > Music: Velvet Revolver > > > > > > > > > > Having Problems: rlib-users-TtF/[email protected] > > > > > Want to contribute: rlib-devel-TtF/[email protected] > > > > > > > > > > > > > > > > > > > > ------------------- reply --------------- > > > > > > From: bdoan-J0aWFLYJOWhWk0Htik3J/[email protected] > > > > > > To: cfortier-Clp0QaBocuhfJ/[email protected] > > > > > > Cc: [email protected] > > > > > > Subject: Re: [Rlib-users] ODBC text > > > > > > Date: 2004-12-07 10:52:16 > > > > > > ---------------------------------- > > > > > > > > > > > > So the PHP standalone ODBC test works? > > > > > > > > > > > > Also, when you ./configure rlib there is a screen at the end saying how > > > > > > RLIB is configured. Can you send that to me > > > > > > > > > > > > Also what distro are you using? > > > > > > > > > > > > On Mon, 2004-12-06 at 19:32 -0300, Cláudio Fortier wrote: > > > > > > > Hi Bob, thanks for your response. > > > > > > > > > > > > > > I really need access ORACLE, but rlib have no native access for it. Because this, i'm trying use unixODBC. > > > > > > > > > > > > > > unix ODBC works fine with the folow script: > > > > > > > <html> > > > > > > > <body> > > > > > > > > > > > > > > <?php > > > > > > > $conn=odbc_connect('oracle','u_test','u_test'); > > > > > > > if (!$conn) > > > > > > > { > > > > > > > exit("Connection Failed: " . $conn); > > > > > > > } > > > > > > > $sql="SELECT * FROM TEN_PAC_PACIENTE"; > > > > > > > $rs=odbc_exec($conn,$sql); > > > > > > > if (!$rs) > > > > > > > { > > > > > > > exit("Error in SQL"); > > > > > > > } > > > > > > > echo "<table><tr>"; > > > > > > > echo "<th>Código</th>"; > > > > > > > echo "<th>Nome</th></tr>"; > > > > > > > while (odbc_fetch_row($rs)) > > > > > > > { > > > > > > > $CODIGO=odbc_result($rs,"PAC_PK_INT_CODIGO"); > > > > > > > $NOME=odbc_result($rs,"PAC_CHR_NOME"); > > > > > > > echo "<tr><td>$CODIGO</td>"; > > > > > > > echo "<td>$NOME</td></tr>"; > > > > > > > } > > > > > > > odbc_close($conn); > > > > > > > echo "</table>"; > > > > > > > ?> > > > > > > > > > > > > > > </body> > > > > > > > </html> > > > > > > > > > > > > > > ------------------- reply --------------- > > > > > > > > From: bdoan-J0aWFLYJOWhWk0Htik3J/[email protected] > > > > > > > > To: fortierbr-/E1597aS9LRfJ/[email protected] > > > > > > > > Cc: [email protected] > > > > > > > > Subject: Re: [Rlib-users] ODBC text > > > > > > > > Date: 2004-12-06 14:41:30 > > > > > > > > ---------------------------------- > > > > > > > > I haven't used it since I wrote it > > > > > > > > > > > > > > > > does any other app work w/ the unixodbc?? > > > > > > > > > > > > > > > > - bob > > > > > > > > > > > > > > > > On Mon, 2004-12-06 at 08:41 -0300, Claudio Fortier wrote: > > > > > > > > > Hi, i'm trying use rlib with unixodbc and PHP in linux > > > > > > > > > rh8. Someone has used rlib with unixodbc? I need > > > > > > > > > examples. > > > > > > > > > > > > > > > > > > My tests every returns the message "The connection was > > > > > > > > > refused when attenpting to contact www.localhost.com" > > > > > > > > > > > > > > > > > > Please, help me. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________________ > > > > > > > > > Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra > > > > > > > > > uma conta agora! http://br.info.mail.yahoo.com/ > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > > > > SF email is sponsored by - The IT Product Guide > > > > > > > > > Read honest & candid reviews on hundreds of IT Products from real users. > > > > > > > > > Discover which products truly live up to the hype. Start reading now. > > > > > > > > > http://productguide.itmanagersjournal.com/ > > > > > > > > > _______________________________________________ > > > > > > > > > Rlib-users mailing list > > > > > > > > > [email protected] > > > > > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > > > SF email is sponsored by - The IT Product Guide > > > > > > > > Read honest & candid reviews on hundreds of IT Products from real users. > > > > > > > > Discover which products truly live up to the hype. Start reading now. > > > > > > > > http://productguide.itmanagersjournal.com/ > > > > > > > > _______________________________________________ > > > > > > > > Rlib-users mailing list > > > > > > > > [email protected] > > > > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > SF email is sponsored by - The IT Product Guide > > > > > > Read honest & candid reviews on hundreds of IT Products from real users. > > > > > > Discover which products truly live up to the hype. Start reading now. > > > > > > http://productguide.itmanagersjournal.com/ > > > > > > _______________________________________________ > > > > > > Rlib-users mailing list > > > > > > [email protected] > > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > SF email is sponsored by - The IT Product Guide > > > > Read honest & candid reviews on hundreds of IT Products from real users. > > > > Discover which products truly live up to the hype. Start reading now. > > > > http://productguide.itmanagersjournal.com/ > > > > _______________________________________________ > > > > Rlib-users mailing list > > > > [email protected] > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users > > > > > > > > > > > > > > > ------------------------------------------------------- > > SF email is sponsored by - The IT Product Guide > > Read honest & candid reviews on hundreds of IT Products from real users. > > Discover which products truly live up to the hype. Start reading now. > > http://productguide.itmanagersjournal.com/ > > _______________________________________________ > > Rlib-users mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/rlib-users > > > ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/