From: Alexandru Gari-N. <ale...@ya...> - 2007-08-02 16:43:48
|
Hello,=0AI finally installed RLIB 1.3.7 after solving glib-2.0 dependency p= roblem on a Fedora Core 6 running Apache, PHP & MySQL.=0AWhile trying to ru= n the example.php as per the PDF manual available on http://rlib.sicompos.c= om/ I had encountered the following error messages:=0A=0A=0A=0AWarning: rl= ib_execute() [function.rlib-execute]: report.xml:6: parser error : Input is= not proper UTF-8, indicate encoding !=0ABytes: 0x92 0x6C 0x6F 0x67 in /var= /www/html/rlib.php on line 12=0A=0A=0A=0AWarning: rlib_execute() [function= .rlib-execute]: <Image value=3D"=A2logo.jpg=A2" type=3D"=A2jpeg=A2" width= =3D"50" height=3D"50"/> in /var/www/html/rlib.php on line 12=0A=0A=0A=0AWar= ning: rlib_execute() [function.rlib-execute]: ^ in /var/www/= html/rlib.php on line 12=0A=0A=0A=0AWarning: Cannot modify header informat= ion - headers already sent by (output started at /var/www/html/rlib.php:12)= in /var/www/html/rlib.php on line 13=0A=0A=0ACan anyone try to help me fig= uring out what is missing so I can run the sample report against the MySQL = database?=0A=0AThanks in advance,=0AAlex=0A=0A=0A=0A=0A=0A=0A ________= ___________________________________________________________________________= _=0AShape Yahoo! in your own image. Join our Network Research Panel today!= http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=3D7 =0A=0A |
From: Alexandru Gari-N. <ale...@ya...> - 2007-08-02 17:24:40
|
I have also tried to run example.php which comes with rlib installation pac= kage (b/m is reffering to the example from the pdf user's manual).=0Ait loo= ks like the data is coming from MySQL but still there are some errors:=0A= =0A[root@csct-local ~]# mysql -u rlib -p=0AEnter password:=0AWelcome to the= MySQL monitor. Commands end with ; or \g.=0AYour MySQL connection id is 6= =0AServer version: 5.2.3-falcon-alpha-log MySQL Community Server (GPL)=0A= =0AType 'help;' or '\h' for help. Type '\c' to clear the buffer.=0A=0Amysql= > use rlib=0ADatabase changed=0Amysql> select * from products;=0A+----+----= ---------+--------------------+------+----------+=0A| rn | plunum | na= me | type | category |=0A+----+-------------+----------------= ----+------+----------+=0A| 1 | 10000000006 | NRS | 9999 | = 0 |=0A| 2 | 10000000008 | food sales | 9999 | 0 |=0A= | 3 | 10000000005 | overring | 9999 | 0 |=0A| 4 | 100000= 00007 | refund | 9999 | 0 |=0A| 5 | 10000000010 | gift = cert sales | 9999 | 0 |=0A| 6 | 10000000011 | other sales = | 9999 | 0 |=0A| 7 | 10000000001 | EI Sales | 9999 | = 0 |=0A| 8 | 10000000002 | TO Sales | 9999 | 0 |=0A| = 9 | 10000000003 | DT Sales | 9999 | 0 |=0A| 10 | 100000000= 09 | nonfood sales | 9999 | 0 |=0A| 11 | 10000000013 | credits = issued | 9999 | 0 |=0A| 12 | 10000000014 | promo sales | = 9999 | 0 |=0A| 13 | 10000000015 | gift cert redeemed | 9999 | = 0 |=0A| 14 | 10000000060 | reserved | 9999 | 0 |=0A+----+= -------------+--------------------+------+----------+=0A14 rows in set (0.0= 0 sec)=0A=0A=0Atrying to open example.php in the browser brings the followi= ng error (data from products table is clearly within the error body):=0A=0A= Warning: Header may not contain more than a single header, new line detect= ed. in /var/www/html/rlib/example.php on line 13=0A=0A%PDF-1.3=0A1 0 obj=0A= <<=0A/Type /Pages=0A/Count 1=0A/Kids [ 6 0 R ]=0A>>=0Aendobj=0A2 0 obj=0A<<= =0A/Type /Font=0A/Subtype /Type1=0A/Name /Frpdf0=0A/BaseFont /Courier=0A/En= coding /WinAnsiEncoding=0A>>=0Aendobj=0A3 0 obj=0A<<=0A/Type /Outlines=0A/C= ount 0=0A>>=0Aendobj=0A4 0 obj=0A[/PDF /Text ]=0Aendobj=0A5 0 obj=0A<>=0Ast= ream=0A1.0000 0.0000 0.0000 1.0000 0.0000 792.0000 cm=0A0.0000 -1.0000 1.00= 00 0.0000 0.0 0.0 cm=0ABT=0A/Frpdf0 9.000 Tf=0A1.0000 0.0000 -0.0000 1.0000= 14.4000 16.5600 Tm=0A(Page: 1) Tj=0A/Frpdf0 12.000 Tf=0A1.0000 0.0000 -0= .0000 1.0000 14.4000 579.4800 Tm=0A(Products Report) Tj=0A/Frpdf0 9.000 Tf= =0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0AET=0A14.400 561.600 = 763.200 1.856 re=0Af=0ABT=0A/Frpdf0 11.000 Tf=0A1.0000 0.0000 -0.0000 1.000= 0 14.4000 549.2400 Tm=0A(Products Report \(Page Header\)) Tj=0A/Frpdf0 9.00= 0 Tf=0AET=0A14.400 541.600 763.200 0.856 re=0Af=0A0.8980 0.8980 0.8980 rg= =0A0.8980 0.8980 0.8980 RG=0A14.400 532.600 313.200 8.856 re=0Af=0A0.0000 0= .0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.00= 00 14.4000 534.7600 Tm=0A(Number Name Type C= ategory ) Tj=0AET=0A14.400 531.600 763.200 0.856 re=0Af=0ABT=0A1.0000 0.00= 00 -0.0000 1.0000 14.4000 520.7600 Tm=0A(10000000006 NRS = 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.89= 80 RG=0AET=0A14.400 509.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg= =0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 511.= 7600 Tm=0A(10000000008 food sales 9999 0 ) Tj= =0A1.0000 0.0000 -0.0000 1.0000 14.4000 502.7600 Tm=0A(10000000005 over= ring 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.89= 80 0.8980 0.8980 RG=0AET=0A14.400 491.600 313.200 8.856 re=0Af=0A0.0000 0.0= 000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000= 14.4000 493.7600 Tm=0A(10000000007 refund 9999 0 = ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 484.7600 Tm=0A(100000000= 10 gift cert sales 9999 0 ) Tj=0A0.8980 0.8980 0.898= 0 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 473.600 313.200 8.856 re=0Af= =0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -= 0.0000 1.0000 14.4000 475.7600 Tm=0A(10000000011 other sales 9= 999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 466.7600 Tm= =0A(10000000001 EI Sales 9999 0 ) Tj=0A0.8980= 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 455.600 313.200 8= .856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.00= 00 0.0000 -0.0000 1.0000 14.4000 457.7600 Tm=0A(10000000002 TO Sales = 9999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 = 448.7600 Tm=0A(10000000003 DT Sales 9999 0 ) = Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 437.60= 0 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG= =0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 439.7600 Tm=0A(10000000009 = nonfood sales 9999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0= 000 14.4000 430.7600 Tm=0A(10000000013 credits issued 9999 = 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A1= 4.400 419.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.000= 0 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 421.7600 Tm=0A(1000= 0000014 promo sales 9999 0 ) Tj=0A1.0000 0.0000 = -0.0000 1.0000 14.4000 412.7600 Tm=0A(10000000015 gift cert redeemed = 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 = RG=0AET=0A14.400 401.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0= .0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 403.7600= Tm=0A(10000000060 reserved 9999 0 ) Tj=0AET= =0A=0Aendstream=0Aendobj=0A6 0 obj=0A<<=0A/Type /Page=0A/Parent 1 0 R=0A/Re= sources <<=0A/Font <<=0A/Frpdf0 2 0 R=0A>>=0A/ProcSet 4 0 R >>=0A/MediaBox = [0 0 612 792]=0A/CropBox [0 0 612 792]=0A/Rotate 270=0A/Contents 5 0 R=0A>>= =0Aendobj=0A7 0 obj=0A<<=0A/Creator (RPDF By SICOM Systems)=0A/CreationDate= (D:20070728052005)=0A/Producer (RPDF 1.0)=0A/Author (RPDF)=0A/Title (RLIB = Report)=0A/Subject (None)=0A/Keywords (RPDF)=0A>>=0Aendobj=0A8 0 obj=0A<<= =0A/Type /Catalog=0A/Pages 1 0 R=0A/Outlines 3 0 R=0A>>=0Aendobj=0Axref=0A0= 9=0A0000000000 65535 f =0A0000000009 00000 n =0A0000000068 00000 n =0A0000= 000177 00000 n =0A0000000223 00000 n =0A0000000252 00000 n =0A0000003646 00= 000 n =0A0000003826 00000 n =0A0000004003 00000 n =0Atrailer=0A<<=0A/Size 9= =0A/Root 8 0 R=0A/Info 7 0 R=0A>>=0Astartxref=0A4068=0A%%EOF=0A=0A=0Aagain = appreciate if anyone can help me,=0AAlex=0A=0A----- Original Message ----= =0AFrom: Alexandru Gari-Negut <ale...@ya...>=0ATo: rlib-users@lists.s= ourceforge.net=0ACc: rli...@li...=0ASent: Thursday, August 2, 20= 07 7:43:38 PM=0ASubject: Re: post-install problems with RLIB=0A=0AHello,=0A= I finally installed RLIB 1.3.7 after solving glib-2.0 dependency problem on= a Fedora Core 6 running Apache, PHP & MySQL.=0AWhile trying to run the exa= mple.php as per the PDF manual available on http://rlib.sicompos.com/ I had= encountered the following error messages:=0A=0A=0A=0AWarning: rlib_execut= e() [function.rlib-execute]: report.xml:6: parser error : Input is not prop= er UTF-8, indicate encoding !=0ABytes: 0x92 0x6C 0x6F 0x67 in /var/www/html= /rlib.php on line 12=0A=0A=0A=0AWarning: rlib_execute() [function.rlib-exe= cute]: <Image value=3D"=A2logo.jpg=A2" type=3D"=A2jpeg=A2" width=3D"50" hei= ght=3D"50"/> in /var/www/html/rlib.php on line 12=0A=0A=0A=0AWarning: rlib= _execute() [function.rlib-execute]: ^ in /var/www/html/rlib.p= hp on line 12=0A=0A=0A=0AWarning: Cannot modify header information - heade= rs already sent by (output started at /var/www/html/rlib.php:12) in /var/ww= w/html/rlib.php on line 13=0A=0A=0ACan anyone try to help me figuring out w= hat is missing so I can run the sample report against the MySQL database?= =0A=0AThanks in advance,=0AAlex=0A=0A=0A=0A=0A=0A=0A _________________= ___________________________________________________________________=0AShape= Yahoo! in your own image. Join our Network Research Panel today! http:/= /surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=3D7 =0A=0A=0A=0A=0A=0A= =0A=0A =0A___________________________________________________________= _________________________=0AMoody friends. Drama queens. Your life? Nope! -= their life, your story. Play Sims Stories at Yahoo! Games.=0Ahttp://sims.y= ahoo.com/ |
From: Alexandru Gari-N. <ale...@ya...> - 2007-08-02 18:17:31
|
Hello again,=0A=0AI managed to get the example.php running ok with html or = text format as the output report format.=0AIt looks like the pdf functional= ity caused the problem, see below the configure output. Question is now: do= I need all the missing modules (Postgres, Python, GD and DB2PDF) or just s= ome of them?=0A=0A# ./configure=0Achecking build system type... i686-redhat= -linux-gnu=0A...=0Achecking for mysql_config... /usr/local/mysql-5.2.3-falc= on-alpha-linux-i686-glibc23/bin/mysql_config=0Achecking for pg_config... no= =0A*** WARNING: POSTGRES NOT FOUND IN PATH. RLIB WILL NOT BE COMPILED WITH= SUPPORT FOR IT=0Achecking for ODBC files... configure: WARNING: ODBC input= method is not going to be used=0Achecking for php-config... /usr/local/bin= /php-config=0Achecking for gdlib-config... no=0A*** WARNING: GD NOT FOUND I= N PATH. RLIB WILL NOT BE COMPILED WITH SUPPORT FOR IT=0Achecking for db2pd= f... no=0A*** WARNING: DB2PDF NOT FOUND IN PATH. Sadly the manual won't be= built=0Achecking for a Python interpreter with version >=3D 2.2... python= =0A...=0Achecking for extension module directory... ${exec_prefix}/lib/pyt= hon2.4/site-packages=0A*** WARNING: PYTHON 2.2 NOT FOUND IN PATH. RLIB WIL= L NOT BE COMPILED WITH SUPPORT FOR IT=0A...=0Aconfig.status: creating confi= g.h=0Aconfig.status: executing depfiles commands=0A=0Arlib-1.3.7:=0A=0A p= refix: /usr/local=0A compiler: gcc=0A = Memory debugging: no=0A Warning Fun: no=0A Crash = detection: yes=0A UTF8 disabled: yes=0A WIN32 build= : no=0A Documentation: no=0A=0A INPUTS:=0A M= YSQL: yes=0A POSTGRES: no=0A ODBC: = no=0A=0A COMPRESSION:=0A PDF: ye= s=0A=0A GRAPHING:=0A PDF: Always=0A HTML: = no=0A=0A BINDINGS:=0A PHP: yes=0A = PHP entension dir: /usr/local/lib/php/extensions/no-debug-non-zts-20= 050922=0A PYTHON: no=0A PYTHON version: 2.2= =0A PYTHON entension dir:=0A JAVA: no=0A CSHAR= P: no=0A PERL: yes=0A PERL enten= sion dir: /usr/lib/perl5/5.8.8/i386-linux-thread-multi=0A=0A ** If yo= u like RLIB send a postcard from where you are in the world to:=0A ** Bob= Doan - 4140 Skyron Drive - Doylestown - PA - 18901 - USA=0A=0A Music: = Coldplay / Virgin Radio=0A Having Problems: rli= b-...@li...=0A Want To Contribute: rli...@li...= =0A Commercial License: rli...@si...=0A=0A=0A----- Original= Message ----=0AFrom: Alexandru Gari-Negut <ale...@ya...>=0ATo: rlib-= us...@li...=0ACc: rli...@li...=0ASent: Thursday,= August 2, 2007 8:24:32 PM=0ASubject: Re: post-install problems with RLIB= =0A=0AI have also tried to run example.php which comes with rlib installati= on package (b/m is reffering to the example from the pdf user's manual).=0A= it looks like the data is coming from MySQL but still there are some errors= :=0A=0A[root@csct-local ~]# mysql -u rlib -p=0AEnter password:=0AWelcome to= the MySQL monitor. Commands end with ; or \g.=0AYour MySQL connection id = is 6=0AServer version: 5.2.3-falcon-alpha-log MySQL Community Server (GPL)= =0A=0AType 'help;' or '\h' for help. Type '\c' to clear the buffer.=0A=0Amy= sql> use rlib=0ADatabase changed=0Amysql> select * from products;=0A+----+-= ------------+--------------------+------+----------+=0A| rn | plunum |= name | type | category |=0A+----+-------------+-------------= -------+------+----------+=0A| 1 | 10000000006 | NRS | 9999= | 0 |=0A| 2 | 10000000008 | food sales | 9999 | 0 |= =0A| 3 | 10000000005 | overring | 9999 | 0 |=0A| 4 | 100= 00000007 | refund | 9999 | 0 |=0A| 5 | 10000000010 | gi= ft cert sales | 9999 | 0 |=0A| 6 | 10000000011 | other sales = | 9999 | 0 |=0A| 7 | 10000000001 | EI Sales | 9999 | = 0 |=0A| 8 | 10000000002 | TO Sales | 9999 | 0 |=0A= | 9 | 10000000003 | DT Sales | 9999 | 0 |=0A| 10 | 100000= 00009 | nonfood sales | 9999 | 0 |=0A| 11 | 10000000013 | credi= ts issued | 9999 | 0 |=0A| 12 | 10000000014 | promo sales = | 9999 | 0 |=0A| 13 | 10000000015 | gift cert redeemed | 9999 | = 0 |=0A| 14 | 10000000060 | reserved | 9999 | 0 |=0A+--= --+-------------+--------------------+------+----------+=0A14 rows in set (= 0.00 sec)=0A=0A=0Atrying to open example.php in the browser brings the foll= owing error (data from products table is clearly within the error body):=0A= =0AWarning: Header may not contain more than a single header, new line det= ected. in /var/www/html/rlib/example.php on line 13=0A=0A%PDF-1.3=0A1 0 obj= =0A<<=0A/Type /Pages=0A/Count 1=0A/Kids [ 6 0 R ]=0A>>=0Aendobj=0A2 0 obj= =0A<<=0A/Type /Font=0A/Subtype /Type1=0A/Name /Frpdf0=0A/BaseFont /Courier= =0A/Encoding /WinAnsiEncoding=0A>>=0Aendobj=0A3 0 obj=0A<<=0A/Type /Outline= s=0A/Count 0=0A>>=0Aendobj=0A4 0 obj=0A[/PDF /Text ]=0Aendobj=0A5 0 obj=0A<= >=0Astream=0A1.0000 0.0000 0.0000 1.0000 0.0000 792.0000 cm=0A0.0000 -1.000= 0 1.0000 0.0000 0.0 0.0 cm=0ABT=0A/Frpdf0 9.000 Tf=0A1.0000 0.0000 -0.0000 = 1.0000 14.4000 16.5600 Tm=0A(Page: 1) Tj=0A/Frpdf0 12.000 Tf=0A1.0000 0.0= 000 -0.0000 1.0000 14.4000 579.4800 Tm=0A(Products Report) Tj=0A/Frpdf0 9.0= 00 Tf=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0AET=0A14.400 561= .600 763.200 1.856 re=0Af=0ABT=0A/Frpdf0 11.000 Tf=0A1.0000 0.0000 -0.0000 = 1.0000 14.4000 549.2400 Tm=0A(Products Report \(Page Header\)) Tj=0A/Frpdf0= 9.000 Tf=0AET=0A14.400 541.600 763.200 0.856 re=0Af=0A0.8980 0.8980 0.8980= rg=0A0.8980 0.8980 0.8980 RG=0A14.400 532.600 313.200 8.856 re=0Af=0A0.000= 0 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1= .0000 14.4000 534.7600 Tm=0A(Number Name Type = Category ) Tj=0AET=0A14.400 531.600 763.200 0.856 re=0Af=0ABT=0A1.0000 0= .0000 -0.0000 1.0000 14.4000 520.7600 Tm=0A(10000000006 NRS = 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0= .8980 RG=0AET=0A14.400 509.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 = rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 51= 1.7600 Tm=0A(10000000008 food sales 9999 0 ) Tj= =0A1.0000 0.0000 -0.0000 1.0000 14.4000 502.7600 Tm=0A(10000000005 over= ring 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.89= 80 0.8980 0.8980 RG=0AET=0A14.400 491.600 313.200 8.856 re=0Af=0A0.0000 0.0= 000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000= 14.4000 493.7600 Tm=0A(10000000007 refund 9999 0 = ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 484.7600 Tm=0A(100000000= 10 gift cert sales 9999 0 ) Tj=0A0.8980 0.8980 0.898= 0 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 473.600 313.200 8.856 re=0Af= =0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -= 0.0000 1.0000 14.4000 475.7600 Tm=0A(10000000011 other sales 9= 999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 466.7600 Tm= =0A(10000000001 EI Sales 9999 0 ) Tj=0A0.8980= 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 455.600 313.200 8= .856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG=0ABT=0A1.00= 00 0.0000 -0.0000 1.0000 14.4000 457.7600 Tm=0A(10000000002 TO Sales = 9999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0000 14.4000 = 448.7600 Tm=0A(10000000003 DT Sales 9999 0 ) = Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A14.400 437.60= 0 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.0000 0.0000 RG= =0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 439.7600 Tm=0A(10000000009 = nonfood sales 9999 0 ) Tj=0A1.0000 0.0000 -0.0000 1.0= 000 14.4000 430.7600 Tm=0A(10000000013 credits issued 9999 = 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 RG=0AET=0A1= 4.400 419.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0.0000 0.000= 0 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 421.7600 Tm=0A(1000= 0000014 promo sales 9999 0 ) Tj=0A1.0000 0.0000 = -0.0000 1.0000 14.4000 412.7600 Tm=0A(10000000015 gift cert redeemed = 9999 0 ) Tj=0A0.8980 0.8980 0.8980 rg=0A0.8980 0.8980 0.8980 = RG=0AET=0A14.400 401.600 313.200 8.856 re=0Af=0A0.0000 0.0000 0.0000 rg=0A0= .0000 0.0000 0.0000 RG=0ABT=0A1.0000 0.0000 -0.0000 1.0000 14.4000 403.7600= Tm=0A(10000000060 reserved 9999 0 ) Tj=0AET= =0A=0Aendstream=0Aendobj=0A6 0 obj=0A<<=0A/Type /Page=0A/Parent 1 0 R=0A/Re= sources <<=0A/Font <<=0A/Frpdf0 2 0 R=0A>>=0A/ProcSet 4 0 R >>=0A/MediaBox = [0 0 612 792]=0A/CropBox [0 0 612 792]=0A/Rotate 270=0A/Contents 5 0 R=0A>>= =0Aendobj=0A7 0 obj=0A<<=0A/Creator (RPDF By SICOM Systems)=0A/CreationDate= (D:20070728052005)=0A/Producer (RPDF 1.0)=0A/Author (RPDF)=0A/Title (RLIB = Report)=0A/Subject (None)=0A/Keywords (RPDF)=0A>>=0Aendobj=0A8 0 obj=0A<<= =0A/Type /Catalog=0A/Pages 1 0 R=0A/Outlines 3 0 R=0A>>=0Aendobj=0Axref=0A0= 9=0A0000000000 65535 f =0A0000000009 00000 n =0A0000000068 00000 n =0A0000= 000177 00000 n =0A0000000223 00000 n =0A0000000252 00000 n =0A0000003646 00= 000 n =0A0000003826 00000 n =0A0000004003 00000 n =0Atrailer=0A<<=0A/Size 9= =0A/Root 8 0 R=0A/Info 7 0 R=0A>>=0Astartxref=0A4068=0A%%EOF=0A=0A=0Aagain = appreciate if anyone can help me,=0AAlex=0A=0A----- Original Message ----= =0AFrom: Alexandru Gari-Negut <ale...@ya...>=0ATo: rlib-users@lists.s= ourceforge.net=0ACc: rli...@li...=0ASent: Thursday, August 2, 20= 07 7:43:38 PM=0ASubject: Re: post-install problems with RLIB=0A=0AHello,=0A= I finally installed RLIB 1.3.7 after solving glib-2.0 dependency problem on= a Fedora Core 6 running Apache, PHP & MySQL.=0AWhile trying to run the exa= mple.php as per the PDF manual available on http://rlib.sicompos.com/ I had= encountered the following error messages:=0A=0A=0A=0AWarning: rlib_execut= e() [function.rlib-execute]: report.xml:6: parser error : Input is not prop= er UTF-8, indicate encoding !=0ABytes: 0x92 0x6C 0x6F 0x67 in /var/www/html= /rlib.php on line 12=0A=0A=0A=0AWarning: rlib_execute() [function.rlib-exe= cute]: <Image value=3D"=A2logo.jpg=A2" type=3D"=A2jpeg=A2" width=3D"50" hei= ght=3D"50"/> in /var/www/html/rlib.php on line 12=0A=0A=0A=0AWarning: rlib= _execute() [function.rlib-execute]: ^ in /var/www/html/rlib.p= hp on line 12=0A=0A=0A=0AWarning: Cannot modify header information - heade= rs already sent by (output started at /var/www/html/rlib.php:12) in /var/ww= w/html/rlib.php on line 13=0A=0A=0ACan anyone try to help me figuring out w= hat is missing so I can run the sample report against the MySQL database?= =0A=0AThanks in advance,=0AAlex=0A=0A=0A=0A=0A=0A=0A _________________= ___________________________________________________________________=0AShape= Yahoo! in your own image. Join our Network Research Panel today! http:/= /surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=3D7 =0A=0A=0A=0A=0A=0A= =0A=0A =0A___________________________________________________________= _________________________=0AMoody friends. Drama queens. Your life? Nope! -= their life, your story. Play Sims Stories at Yahoo! Games.=0Ahttp://sims.y= ahoo.com/=0A=0A=0A=0A=0A=0A =0A______________________________________= ______________________________________________=0AYahoo! oneSearch: Finally,= mobile search =0Athat gives answers, not web links. =0Ahttp://mobile.yahoo= .com/mobileweb/onesearch?refer=3D1ONXIC |
From: Bob D. <bd...@si...> - 2007-08-17 20:01:57
|
Hi, You need to do something like: $my_header = split("\n", rlib_get_content_type($rlib)); foreach($my_header as $x) { if($x != '') header($x); } On Thu, 2007-08-02 at 11:17 -0700, Alexandru Gari-Negut wrote: > Hello again, > > I managed to get the example.php running ok with html or text format as the output report format. > It looks like the pdf functionality caused the problem, see below the configure output. Question is now: do I need all the missing modules (Postgres, Python, GD and DB2PDF) or just some of them? > > # ./configure > checking build system type... i686-redhat-linux-gnu > ... > checking for mysql_config... /usr/local/mysql-5.2.3-falcon-alpha-linux-i686-glibc23/bin/mysql_config > checking for pg_config... no > *** WARNING: POSTGRES NOT FOUND IN PATH. RLIB WILL NOT BE COMPILED WITH SUPPORT FOR IT > checking for ODBC files... configure: WARNING: ODBC input method is not going to be used > checking for php-config... /usr/local/bin/php-config > checking for gdlib-config... no > *** WARNING: GD NOT FOUND IN PATH. RLIB WILL NOT BE COMPILED WITH SUPPORT FOR IT > checking for db2pdf... no > *** WARNING: DB2PDF NOT FOUND IN PATH. Sadly the manual won't be built > checking for a Python interpreter with version >= 2.2... python > ... > checking for extension module directory... ${exec_prefix}/lib/python2.4/site-packages > *** WARNING: PYTHON 2.2 NOT FOUND IN PATH. RLIB WILL NOT BE COMPILED WITH SUPPORT FOR IT > ... > config.status: creating config.h > config.status: executing depfiles commands > > rlib-1.3.7: > > prefix: /usr/local > compiler: gcc > Memory debugging: no > Warning Fun: no > Crash detection: yes > UTF8 disabled: yes > WIN32 build: no > Documentation: no > > INPUTS: > MYSQL: yes > POSTGRES: no > ODBC: no > > COMPRESSION: > PDF: yes > > GRAPHING: > PDF: Always > HTML: no > > BINDINGS: > PHP: yes > PHP entension dir: /usr/local/lib/php/extensions/no-debug-non-zts-20050922 > PYTHON: no > PYTHON version: 2.2 > PYTHON entension dir: > JAVA: no > CSHARP: no > PERL: yes > PERL entension dir: /usr/lib/perl5/5.8.8/i386-linux-thread-multi > > ** If you like RLIB send a postcard from where you are in the world to: > ** Bob Doan - 4140 Skyron Drive - Doylestown - PA - 18901 - USA > > Music: Coldplay / Virgin Radio > Having Problems: rli...@li... > Want To Contribute: rli...@li... > Commercial License: rli...@si... > > > ----- Original Message ---- > From: Alexandru Gari-Negut <ale...@ya...> > To: rli...@li... > Cc: rli...@li... > Sent: Thursday, August 2, 2007 8:24:32 PM > Subject: Re: post-install problems with RLIB > > I have also tried to run example.php which comes with rlib installation package (b/m is reffering to the example from the pdf user's manual). > it looks like the data is coming from MySQL but still there are some errors: > > [root@csct-local ~]# mysql -u rlib -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 6 > Server version: 5.2.3-falcon-alpha-log MySQL Community Server (GPL) > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> use rlib > Database changed > mysql> select * from products; > +----+-------------+--------------------+------+----------+ > | rn | plunum | name | type | category | > +----+-------------+--------------------+------+----------+ > | 1 | 10000000006 | NRS | 9999 | 0 | > | 2 | 10000000008 | food sales | 9999 | 0 | > | 3 | 10000000005 | overring | 9999 | 0 | > | 4 | 10000000007 | refund | 9999 | 0 | > | 5 | 10000000010 | gift cert sales | 9999 | 0 | > | 6 | 10000000011 | other sales | 9999 | 0 | > | 7 | 10000000001 | EI Sales | 9999 | 0 | > | 8 | 10000000002 | TO Sales | 9999 | 0 | > | 9 | 10000000003 | DT Sales | 9999 | 0 | > | 10 | 10000000009 | nonfood sales | 9999 | 0 | > | 11 | 10000000013 | credits issued | 9999 | 0 | > | 12 | 10000000014 | promo sales | 9999 | 0 | > | 13 | 10000000015 | gift cert redeemed | 9999 | 0 | > | 14 | 10000000060 | reserved | 9999 | 0 | > +----+-------------+--------------------+------+----------+ > 14 rows in set (0.00 sec) > > > trying to open example.php in the browser brings the following error (data from products table is clearly within the error body): > > Warning: Header may not contain more than a single header, new line detected. in /var/www/html/rlib/example.php on line 13 > > %PDF-1.3 > 1 0 obj > << > /Type /Pages > /Count 1 > /Kids [ 6 0 R ] > >> > endobj > 2 0 obj > << > /Type /Font > /Subtype /Type1 > /Name /Frpdf0 > /BaseFont /Courier > /Encoding /WinAnsiEncoding > >> > endobj > 3 0 obj > << > /Type /Outlines > /Count 0 > >> > endobj > 4 0 obj > [/PDF /Text ] > endobj > 5 0 obj > <> > stream > 1.0000 0.0000 0.0000 1.0000 0.0000 792.0000 cm > 0.0000 -1.0000 1.0000 0.0000 0.0 0.0 cm > BT > /Frpdf0 9.000 Tf > 1.0000 0.0000 -0.0000 1.0000 14.4000 16.5600 Tm > (Page: 1) Tj > /Frpdf0 12.000 Tf > 1.0000 0.0000 -0.0000 1.0000 14.4000 579.4800 Tm > (Products Report) Tj > /Frpdf0 9.000 Tf > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > ET > 14.400 561.600 763.200 1.856 re > f > BT > /Frpdf0 11.000 Tf > 1.0000 0.0000 -0.0000 1.0000 14.4000 549.2400 Tm > (Products Report \(Page Header\)) Tj > /Frpdf0 9.000 Tf > ET > 14.400 541.600 763.200 0.856 re > f > 0.8980 0.8980 0.8980 rg > 0.8980 0.8980 0.8980 RG > 14.400 532.600 313.200 8.856 re > f > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 534.7600 Tm > (Number Name Type Category ) Tj > ET > 14.400 531.600 763.200 0.856 re > f > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 520.7600 Tm > (10000000006 NRS 9999 0 ) Tj > 0.8980 0.8980 0.8980 rg > 0.8980 0.8980 0.8980 RG > ET > 14.400 509.600 313.200 8.856 re > f > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 511.7600 Tm > (10000000008 food sales 9999 0 ) Tj > 1.0000 0.0000 -0.0000 1.0000 14.4000 502.7600 Tm > (10000000005 overring 9999 0 ) Tj > 0.8980 0.8980 0.8980 rg > 0.8980 0.8980 0.8980 RG > ET > 14.400 491.600 313.200 8.856 re > f > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 493.7600 Tm > (10000000007 refund 9999 0 ) Tj > 1.0000 0.0000 -0.0000 1.0000 14.4000 484.7600 Tm > (10000000010 gift cert sales 9999 0 ) Tj > 0.8980 0.8980 0.8980 rg > 0.8980 0.8980 0.8980 RG > ET > 14.400 473.600 313.200 8.856 re > f > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 475.7600 Tm > (10000000011 other sales 9999 0 ) Tj > 1.0000 0.0000 -0.0000 1.0000 14.4000 466.7600 Tm > (10000000001 EI Sales 9999 0 ) Tj > 0.8980 0.8980 0.8980 rg > 0.8980 0.8980 0.8980 RG > ET > 14.400 455.600 313.200 8.856 re > f > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 457.7600 Tm > (10000000002 TO Sales 9999 0 ) Tj > 1.0000 0.0000 -0.0000 1.0000 14.4000 448.7600 Tm > (10000000003 DT Sales 9999 0 ) Tj > 0.8980 0.8980 0.8980 rg > 0.8980 0.8980 0.8980 RG > ET > 14.400 437.600 313.200 8.856 re > f > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 439.7600 Tm > (10000000009 nonfood sales 9999 0 ) Tj > 1.0000 0.0000 -0.0000 1.0000 14.4000 430.7600 Tm > (10000000013 credits issued 9999 0 ) Tj > 0.8980 0.8980 0.8980 rg > 0.8980 0.8980 0.8980 RG > ET > 14.400 419.600 313.200 8.856 re > f > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 421.7600 Tm > (10000000014 promo sales 9999 0 ) Tj > 1.0000 0.0000 -0.0000 1.0000 14.4000 412.7600 Tm > (10000000015 gift cert redeemed 9999 0 ) Tj > 0.8980 0.8980 0.8980 rg > 0.8980 0.8980 0.8980 RG > ET > 14.400 401.600 313.200 8.856 re > f > 0.0000 0.0000 0.0000 rg > 0.0000 0.0000 0.0000 RG > BT > 1.0000 0.0000 -0.0000 1.0000 14.4000 403.7600 Tm > (10000000060 reserved 9999 0 ) Tj > ET > > endstream > endobj > 6 0 obj > << > /Type /Page > /Parent 1 0 R > /Resources << > /Font << > /Frpdf0 2 0 R > >> > /ProcSet 4 0 R >> > /MediaBox [0 0 612 792] > /CropBox [0 0 612 792] > /Rotate 270 > /Contents 5 0 R > >> > endobj > 7 0 obj > << > /Creator (RPDF By SICOM Systems) > /CreationDate (D:20070728052005) > /Producer (RPDF 1.0) > /Author (RPDF) > /Title (RLIB Report) > /Subject (None) > /Keywords (RPDF) > >> > endobj > 8 0 obj > << > /Type /Catalog > /Pages 1 0 R > /Outlines 3 0 R > >> > endobj > xref > 0 9 > 0000000000 65535 f > 0000000009 00000 n > 0000000068 00000 n > 0000000177 00000 n > 0000000223 00000 n > 0000000252 00000 n > 0000003646 00000 n > 0000003826 00000 n > 0000004003 00000 n > trailer > << > /Size 9 > /Root 8 0 R > /Info 7 0 R > >> > startxref > 4068 > %%EOF > > > again appreciate if anyone can help me, > Alex > > ----- Original Message ---- > From: Alexandru Gari-Negut <ale...@ya...> > To: rli...@li... > Cc: rli...@li... > Sent: Thursday, August 2, 2007 7:43:38 PM > Subject: Re: post-install problems with RLIB > > Hello, > I finally installed RLIB 1.3.7 after solving glib-2.0 dependency problem on a Fedora Core 6 running Apache, PHP & MySQL. > While trying to run the example.php as per the PDF manual available on http://rlib.sicompos.com/ I had encountered the following error messages: > > > > Warning: rlib_execute() [function.rlib-execute]: report.xml:6: parser error : Input is not proper UTF-8, indicate encoding ! > Bytes: 0x92 0x6C 0x6F 0x67 in /var/www/html/rlib.php on line 12 > > > > Warning: rlib_execute() [function.rlib-execute]: <Image value="’logo.jpg’" type="’jpeg’" width="50" height="50"/> in /var/www/html/rlib.php on line 12 > > > > Warning: rlib_execute() [function.rlib-execute]: ^ in /var/www/html/rlib.php on line 12 > > > > Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/rlib.php:12) in /var/www/html/rlib.php on line 13 > > > Can anyone try to help me figuring out what is missing so I can run the sample report against the MySQL database? > > Thanks in advance, > Alex > > > > > > > ____________________________________________________________________________________ > Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 > > > > > > > > > ____________________________________________________________________________________ > Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. > http://sims.yahoo.com/ > > > > > > > ____________________________________________________________________________________ > Yahoo! oneSearch: Finally, mobile search > that gives answers, not web links. > http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Rlib-users mailing list > Rli...@li... > https://lists.sourceforge.net/lists/listinfo/rlib-users -- Bob Doan Vice President of Information Technology SICOM Systems bd...@si... 800-547-4266 x217 |