Menu
▾
▴
rlib-users
|
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 |
|
From: Bob D. <bd...@si...> - 2004-08-20 19:10:20
|
What does your apache error log say when you get the IE dns errors?
- bob
On Thu, 2004-08-19 at 14:12 -0700, Rich wrote:
> 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:
> ==================================
> <? dl ("librlib.so");
>
> $format = "pdf";
> $sql_host = "w032.secureinfoimaging.com";
> $sql_users = "easyim";
> $sql_password = "newpenn";
> $sql_database = "tmp";
> print "Init<br>";
>
> $rlib = 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;
>
> If I UNCOMMENT the line
> ## rlib_execute($rlib);
> ....and reload I immediately get
> "Cannot find server or DNS Error Internet Explorer", again.
> 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)
>
> FYI, the mysql table 'example'
> .....works correctly with IE, using normal php code like:
> $sql = "SELECT * FROM example".$orderByQuery.$limitQuery;
> $result = MYSQL_QUERY($sql);
> $numberOfRows = 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:
> ======================================
> 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]#
>
>
> ....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
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X