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