From: Rich <ri...@se...> - 2004-08-19 21:12:53
|
Hi Bob -- Thanks for the help the other day. I was able to get the configure = requirements satisfied and get rlib installed, but when I attempt to = run the example report, I get a "Cannot find server or DNS Error = Internet Explorer" screen . I have also tried Netscape 7.2, but it = gives no output or any indication that it has even tried to load the = page. If I modify the test code to the to the following: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D <? dl ("librlib.so"); $format =3D "pdf"; $sql_host =3D "w032.secureinfoimaging.com"; $sql_users =3D "easyim"; $sql_password =3D "newpenn"; $sql_database =3D "tmp"; print "Init<br>"; $rlib =3D rlib_init(); print "Init<br>"; rlib_add_datasource_mysql($rlib, "mysql", $sql_host, $sql_users, = $sql_password, $sql_database); print "connect<br>"; rlib_add_query_as($rlib, "mysql", "select * from example", "example"); print "query<br>"; rlib_add_report($rlib, "report.xml"); print "report<br>"; rlib_set_output_format_from_text($rlib, $format); print "output1<br>"; print rlib_get_content_type($rlib) . '<br>'; ## rlib_execute($rlib); ## header( rlib_get_content_type($rlib) ); ## rlib_spool($rlib); ## rlib_free($rlib); ?> ......I get this result: Init Init connect query report output1 Content-Type: application/pdf;=20 If I UNCOMMENT the line=20 ## rlib_execute($rlib); ....and reload I immediately get "Cannot find server or DNS Error Internet Explorer", again.=20 I have tried all possible format types with the same result. I checked the apache error log and see a message being generated = everytime the page loads similar to: [Thu Aug 19 11:09:00 2004] [notice] child pid 13702 exit signal Quit (3) = =20 FYI, the mysql table 'example'=20 .....works correctly with IE, using normal php code like:=20 $sql =3D "SELECT * FROM example".$orderByQuery.$limitQuery; $result =3D MYSQL_QUERY($sql); $numberOfRows =3D mysql_Numrows($result); ..... etc. Also, I ran the test1 program from the command prompt using: ./test1 192.168.0.32 userHere passwdHere dbHere >rdf.txt This produced the following message on the screen: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Setting output encoding to ANSI_X3.4-1968encoding is NULL or invalid = [C]... using en_USSetting locale to [C] FAILEDencoding is NULL or = invalid [C]... using en_USSetting locale to [C] FAILEDencoding is NULL = or invalid [C]... using en_USSetting locale to [C] FAILEDencoding is = NULL or invalid [C]... using en_USSetting locale to [C] FAILEDencoding = is NULL or invalid [C]... using en_USSetting locale to [C] = FAILEDencoding is NULL or invalid [C]... using en_USSetting locale to = [C] FAILEDencoding is NULL or invalid [C]... using en_USSetting locale = to [C] FAILEDencoding is NULL or invalid [C]... using en_USSetting = locale to [C] FAILEDencoding is NULL or invalid [C]... using = en_USSetting locale to [C] FAILEDencoding is NULL or invalid [C]... = using en_USSetting locale to [C] FAILEDencoding is NULL or invalid = [C]... using en_USSetting locale to [C] FAILEDencoding is NULL or = invalid [C]... using en_USSetting locale to [C] FAILEDencoding is NULL = or invalid [C]... using en_USSetting locale to [C] FAILEDCPDF version = 2.02-r1-2[root@cc001032 tests]#=20 ....the output {rdf.txt} was as follows: 0.0000 0.0000 0.0000 rg 0.0000 0.0000 0.0000 RG 1.0000 0.0000 -0.0000 1.0000 14.4000 462.7600 Tm (Chips 2 2) Tj 1.0000 0.0000 -0.0000 1.0000 14.4000 453.7600 Tm (Jaquar 3 3) Tj ET 0.8980 0.8980 0.8980 rg 0.8980 0.8980 0.8980 RG 14.400 442.600 253.800 8.856 re f BT 0.0000 0.0000 0.0000 rg 0.0000 0.0000 0.0000 RG 1.0000 0.0000 -0.0000 1.0000 14.4000 444.7600 Tm (Lexus 3 3) Tj 1.0000 0.0000 -0.0000 1.0000 14.4000 435.7600 Tm (Pinto 3 3) Tj /Fcpdf0 11.000 Tf 1.0000 0.0000 -0.0000 1.0000 14.4000 425.2400 Tm (REPORT FOOTER) Tj /Fcpdf0 9.000 Tf ET endstream endobj 7 0 obj << /Type /Font /Subtype /Type1 /Name /Fcpdf0 /BaseFont /Courier >> endobj 8 0 obj << /Creator (A ClibPDF program) /CreationDate (D:20040819112049) /Producer ([ClibPDF Library 2.02-r1-2] NEXTSTEP or OPENSTEP) /Author (User: root [root]) /Title (RLIB Report) /Subject (None) /Keywords (ClibPDF) >> endobj xref 0 9 0000000000 65535 f 0000000033 00000 n 0000000098 00000 n 0000000144 00000 n 0000000203 00000 n 0000000231 00000 n 0000000411 00000 n 0000002875 00000 n 0000002957 00000 n trailer << /Size 9 /Root 1 0 R /Info 8 0 R >> startxref 3186 %%EOF What should I try next? --Rich |