Schrift
Wiki:Tipp zum Debugging: use Data::Dumper; local $Data::Dumper::Useqq = 1; print Dumper \@var;
Start · Board · Webprogrammierung mit Perl · Perl/CGI
[thread]135[/thread]

brauche dringend hilfe: wer kann mir helfen (Seite 2)

Leser: 2


<< |< 1 2 3 4 5 >| >> 43 Einträge, 5 Seiten
sonnenprinz
 2004-01-07 21:04
#730 #730
User since
2004-01-05
36 Artikel
BenutzerIn
[default_avatar]
hier die einträge der error.log:

[Wed Jan 07 11:43:13 2004] [warn] pid file C:/Programme/Apache Group/Apache2/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Wed Jan 07 11:43:13 2004] [notice] Parent: Created child process 1472
[Wed Jan 07 11:43:14 2004] [notice] Child 1472: Child process is running
[Wed Jan 07 11:43:14 2004] [notice] Child 1472: Acquired the start mutex.
[Wed Jan 07 11:43:14 2004] [notice] Child 1472: Starting 250 worker threads.
[Wed Jan 07 13:45:54 2004] [notice] Parent: Created child process 1020
[Wed Jan 07 13:45:54 2004] [notice] Child 1020: Child process is running
[Wed Jan 07 13:45:55 2004] [notice] Child 1020: Acquired the start mutex.
[Wed Jan 07 13:45:55 2004] [notice] Child 1020: Starting 250 worker threads.
[Wed Jan 07 16:46:35 2004] [error] [client 127.0.0.1] script not found or unable to stat: C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl
[Wed Jan 07 17:06:08 2004] [error] [client 127.0.0.1] C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl is not executable; ensure interpreted scripts have "#!" first line, referer: http://localhost/kunden.html
[Wed Jan 07 17:06:08 2004] [error] [client 127.0.0.1] (9)Bad file descriptor: don't know how to spawn child process: C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 17:06:31 2004] [error] [client 127.0.0.1] C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl is not executable; ensure interpreted scripts have "#!" first line, referer: http://localhost/kunden.html
[Wed Jan 07 17:06:31 2004] [error] [client 127.0.0.1] (9)Bad file descriptor: don't know how to spawn child process: C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 17:10:31 2004] [error] [client 127.0.0.1] C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl is not executable; ensure interpreted scripts have "#!" first line, referer: http://localhost/kunden.html
[Wed Jan 07 17:10:31 2004] [error] [client 127.0.0.1] (9)Bad file descriptor: don't know how to spawn child process: C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 19:06:23 2004] [error] [client 127.0.0.1] C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl is not executable; ensure interpreted scripts have "#!" first line, referer: http://localhost/kunden.html
[Wed Jan 07 19:06:24 2004] [error] [client 127.0.0.1] (9)Bad file descriptor: don't know how to spawn child process: C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 19:16:06 2004] [error] [client 127.0.0.1] C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl is not executable; ensure interpreted scripts have "#!" first line, referer: http://localhost/kunden.html
[Wed Jan 07 19:16:06 2004] [error] [client 127.0.0.1] (9)Bad file descriptor: don't know how to spawn child process: C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl, referer: http://localhost/kunden.html

wie ich schon sagte bin neuling.
kannst du was damit anfangen?
renee
 2004-01-07 21:12
#731 #731
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
jepp, hab' ich ganz übersehen:in kunden.pl
Code: (dl )
#! c:/perl/bin/perl -w
statt
Code: (dl )
#c:\perl\bin\perl -w
\n\n

<!--EDIT|renee|1073502803-->
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/
sonnenprinz
 2004-01-07 21:29
#732 #732
User since
2004-01-05
36 Artikel
BenutzerIn
[default_avatar]
danke renee, aber immer noch die gleiche fehlermeldung.
sonnenprinz
 2004-01-07 21:53
#733 #733
User since
2004-01-05
36 Artikel
BenutzerIn
[default_avatar]
jetzt steht folgendes in der error-log

[Wed Jan 07 19:16:06 2004] [error] [client 127.0.0.1] (9)Bad file descriptor: don't know how to spawn child process: C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 20:28:30 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 20:28:30 2004] [error] [client 127.0.0.1] Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 5., referer: http://localhost/kunden.html
[Wed Jan 07 20:28:30 2004] [error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 5., referer: http://localhost/kunden.html
renee
 2004-01-07 22:03
#734 #734
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Also für die Beseitigung der zweiten Fehlermeldung musst Du bei Dir das DBI-Modul installieren (bekommst du auf <a href="search.cpan.org/search?query=DBI&mode=all" target="_blank">CPAN</a>). Sollte es dabei Probleme geben, einfach melden...

Für die erste Meldung solltes Du mal überprüfen, ob die httpd.conf vom Apache richtig konfiguriert ist...
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
    DocumentRoot "C:/urlaub-im-ferienpark"
    AddHandler cgi-script .cgi .pl
    ScriptAlias /cgi_urlaub/ "C:/urlaub-im-ferienpark/cgi_urlaub/"
    ScriptAlias /cgi-bin/ "C:/urlaub-im-ferienpark/cgi_urlaub/"
    AddHandler server-parsed shtml
    AddType text/html shtml
    AccessFileName .htaccess

    <Directory "C:/urlaub-im-ferienpark">
        Options Indexes FollowSymLinks MultiViews Includes ExecCGI
        AddHandler server-parsed .shtml
        AddHandler cgi-script .cgi .pl
    </Directory>

    <Directory "C:/urlaub-im-ferienpark/cgi_urlaub/">
        Options ExecCGI
        AddHandler cgi-script .cgi .pl
        AllowOverride None
        Options None
        Order allow,deny
        Allow from all
     </Directory>
die Ordnerangaben müssen natürlich angepasst werden.

Für die dritte Fehlermeldung müsste ich nochmal das Skript in der jetzigen Fassung sehen...
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/
sonnenprinz
 2004-01-07 22:13
#735 #735
User since
2004-01-05
36 Artikel
BenutzerIn
[default_avatar]
ich habe bereits den DBD::ODBC treiber des DBI-Moduls installiert.
hier das script in der jetzigen fassung:

#! c:/perl/bin/perl -w

use strict;
use CGI qw(:standard);
use DBI;

my $dbh = DBI->connect('DBI:ODBC:db1');

my $sqlstatement=qq§SELECT Tabelle1.Adresse, Name, Telefon, Tabelle2.Rechnungsbetrag
FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer§;

my $sth = $dbh->prepare($sqlstatement);
$sth->execute ||
die "Could not execute SQL statement ... maybe invalid?";

print <<HERE_TEXT;
Content-type:text/html

<html>
<head>
<title>Antwort</title>
</head>
<body>
<h3>Treffer</h3>

<hr>
HERE_TEXT

my @row;
while (@row=$sth->fetchrow_array)
{print "<p>@row</p>\n"}

print qq§</body>\n</html>;
renee
 2004-01-07 22:27
#736 #736
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
mach zwischen das Content-type: und dem text/html mal ein Leerzeichen...

und beachte mal die Änderungen, die ich in meiner 1. Antwort gegeben habe...

Du brauchst nicht nur das DBD:Oracle, sondern auch das DBI-Modul...
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/
sonnenprinz
 2004-01-07 23:08
#737 #737
User since
2004-01-05
36 Artikel
BenutzerIn
[default_avatar]
habe das modul installiert und das leerzeichen gesetzt. httpd.conf passt. aber immer noch fehlermeldung.
wie ist das mit der rechnung generieren und der ausgabe in tabellenform. kannst du mir da weiterhelfen.

gruss uwe

bin morgen wieder on
renee
 2004-01-07 23:19
#738 #738
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Auch wenn ich der Meinung bin, dass wir erstmal die anderen Probleme lösen sollten bitte die aktuellsten Meldungen der error.log posten:
für Ausgabe in Tabellenform:
Code: (dl )
1
2
3
4
5
6
7
print '<table>';
while (@row=$sth->fetchrow_array){
  print '<tr>';
  print '<td>',$_,'</td>' for(@row);
  print '</tr>';
}
print '</table>';

Zur Rechnungserstellung:
Willst Du das als .pdf erstellen oder als .txt??
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/
sonnenprinz
 2004-01-07 23:35
#739 #739
User since
2004-01-05
36 Artikel
BenutzerIn
[default_avatar]
als txt.

hier die error-log:
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
[Wed Jan 07 22:02:54 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 22:02:54 2004] [error] [client 127.0.0.1] Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 5., referer: http://localhost/kunden.html
[Wed Jan 07 22:02:54 2004] [error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 5., referer: http://localhost/kunden.html
[Wed Jan 07 22:03:30 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 22:03:30 2004] [error] [client 127.0.0.1] Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 5., referer: http://localhost/kunden.html
[Wed Jan 07 22:03:30 2004] [error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 5., referer: http://localhost/kunden.html
[Wed Jan 07 22:03:33 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 22:03:33 2004] [error] [client 127.0.0.1] Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 5., referer: http://localhost/kunden.html
[Wed Jan 07 22:03:33 2004] [error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 5., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:23 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 22:04:23 2004] [error] [client 127.0.0.1] Bareword found where operator expected at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer&sect", referer: http://localhost/kunden.html
[Wed Jan 07 22:04:23 2004] [error] [client 127.0.0.1]   (Might be a runaway multi-line && string starting on line 9), referer: http://localhost/kunden.html
[Wed Jan 07 22:04:23 2004] [error] [client 127.0.0.1] 	(Do you need to predeclare FROM?), referer: http://localhost/kunden.html
[Wed Jan 07 22:04:23 2004] [error] [client 127.0.0.1] Operator or semicolon missing before &sect at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:23 2004] [error] [client 127.0.0.1] Ambiguous use of & resolved as operator & at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:23 2004] [error] [client 127.0.0.1] syntax error at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer&sect", referer: http://localhost/kunden.html
[Wed Jan 07 22:04:23 2004] [error] [client 127.0.0.1] Can't find string terminator "&" anywhere before EOF at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 33., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:27 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 22:04:27 2004] [error] [client 127.0.0.1] Bareword found where operator expected at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer&sect", referer: http://localhost/kunden.html
[Wed Jan 07 22:04:27 2004] [error] [client 127.0.0.1]   (Might be a runaway multi-line && string starting on line 9), referer: http://localhost/kunden.html
[Wed Jan 07 22:04:27 2004] [error] [client 127.0.0.1] 	(Do you need to predeclare FROM?), referer: http://localhost/kunden.html
[Wed Jan 07 22:04:27 2004] [error] [client 127.0.0.1] Operator or semicolon missing before &sect at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:27 2004] [error] [client 127.0.0.1] Ambiguous use of & resolved as operator & at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:27 2004] [error] [client 127.0.0.1] syntax error at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer&sect", referer: http://localhost/kunden.html
[Wed Jan 07 22:04:27 2004] [error] [client 127.0.0.1] Can't find string terminator "&" anywhere before EOF at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 33., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:45 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 22:04:45 2004] [error] [client 127.0.0.1] Bareword found where operator expected at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer&sect", referer: http://localhost/kunden.html
[Wed Jan 07 22:04:45 2004] [error] [client 127.0.0.1]   (Might be a runaway multi-line && string starting on line 9), referer: http://localhost/kunden.html
[Wed Jan 07 22:04:45 2004] [error] [client 127.0.0.1] 	(Do you need to predeclare FROM?), referer: http://localhost/kunden.html
[Wed Jan 07 22:04:45 2004] [error] [client 127.0.0.1] Operator or semicolon missing before &sect at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:45 2004] [error] [client 127.0.0.1] Ambiguous use of & resolved as operator & at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer: http://localhost/kunden.html
[Wed Jan 07 22:04:45 2004] [error] [client 127.0.0.1] syntax error at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer&sect", referer: http://localhost/kunden.html
[Wed Jan 07 22:04:45 2004] [error] [client 127.0.0.1] Can't find string terminator "&" anywhere before EOF at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 33., referer: http://localhost/kunden.html
[Wed Jan 07 22:05:47 2004] [error] [client 127.0.0.1] Premature end of script headers: kunden.pl, referer: http://localhost/kunden.html
[Wed Jan 07 22:05:48 2004] [error] [client 127.0.0.1] Bareword found where operator expected at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer&sect", referer: http://localhost/kunden.html
[Wed Jan 07 22:05:48 2004] [error] [client 127.0.0.1]   (Might be a runaway multi-line && string starting on line 9), referer: http://localhost/kunden.html
[Wed Jan 07 22:05:48 2004] [error] [client 127.0.0.1] 	(Do you need to predeclare FROM?), referer: http://localhost/kunden.html
[Wed Jan 07 22:05:48 2004] [error] [client 127.0.0.1] Operator or semicolon missing before &sect at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer: http://localhost/kunden.html
[Wed Jan 07 22:05:48 2004] [error] [client 127.0.0.1] Ambiguous use of & resolved as operator & at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10., referer: http://localhost/kunden.html
[Wed Jan 07 22:05:48 2004] [error] [client 127.0.0.1] syntax error at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 10, near "FROM Tabelle1 INNER JOIN Tabelle2 ON Tabelle1.Kundennummer = Tabelle2.Kundennummer&sect", referer: http://localhost/kunden.html
[Wed Jan 07 22:05:48 2004] [error] [client 127.0.0.1] Can't find string terminator "&" anywhere before EOF at C:/Programme/Apache Group/Apache2/cgi-bin/kunden.pl line 33., referer: http://localhost/kunden.html
\n\n

<!--EDIT|renee|1073557680-->
<< |< 1 2 3 4 5 >| >> 43 Einträge, 5 Seiten



View all threads created 2004-01-07 19:34.