perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aaron Ross <r...@mathforum.com>
Subject Re: Help : mod_perl and DBD::Sybase ?!? continued...
Date Mon, 13 Mar 2000 15:10:39 GMT
hi raptor!

 we use sybase w/ mod_perl here without any problems.

	- Apache 1.3.6 statically compiled mod_perl 1.21 and DBD::Sybase .21

 Can you connect and execute commands with isql or sqsh? if not see the link
below about the client libraries and LC_ALL.

 Can you provide the "pure" cgi script that works with no problems? please
try running dbish to test if DBI and DBD::Sybase are setup ok.
	
	% dbish "dbi:Sybase:server=Sybase;database=blah;interfaces=/opt/sybase-11.9.2/interfaces"
"sa" "password"
	% dbish> select 1 /
	COL(1)
	1
	[1 rows of 1 fields returned]

 There are also known problems with Client Libraries see: http://www.mbay.net/~mpeppler/Linux-ASE-FAQ.html#q1.14
These problems can be fixed with a patch to locales.dat available on the same page. Here is
a summary of the problem:

	By default RedHat 6.x (and possibly other distributions) set 
	LC_ALL to a value that combines the country and the language. 
	On my machine this is us_EN (for USA, English). This value is 
	not in the locales.dat file, hence the problem. 
 
 Once you are sure that this is all working, we'll have to look at mod_perl. :)  
HTH, 
	Aaron

> hi again,
> 
> I'm still having problem ?! I changed (RH6.1- apache1.3.9-mod_perl-1.21)
> with new one..(apache-1.3.6 -- mod_perl-1.21 - staticly linked (the link on
> the perl.apache.org)), but now insead of "illegal instruction", I'm getting
> "segmetation fault (11)"  .... When I'm using PURE CGI no problems I'm
> accessing Sybase successfully ?!?
> 
> HOW can get more information exactly what is hapenning ?!?
> 
> 
> Apache::Registry
> ==============
> #!/usr/bin/perl
> print qq{Content-type: text/html\n\n
> 	<HTML><BODY>test connection<BR>};
>   use DBI;
>  @d = DBI->available_drivers;
>  print @d,"<BR>";
>  @d = DBI->data_sources("Sybase");
>  print @d;
> # $dbh =
> DBI->connect("dbi:Sybase:server=Sybase;database=blah;interfaces=/opt/sybase-11.9.2/interfaces",
"sa", "") or die print "ERROR: $!"; 
> # @res = $dbh->selectrow_array("SELECT * FROM test");
> # print @res;
> 
> print qq{</BODY></HTML>};
> 
> 
> Here is the result of data_sources("ExampleP");
> 
> ExampleP
> dbi:ExampleP:dir=.
> 
> works.?!? 
> 
> Just tested with (RH6.0  - apache1.3.6 - mod_perl 1.19) - "illegal instruction
> (4)".
> 
> THIS SEEMS TO BE A MOD_PERL <-> DBD::Sybase problem !!! HOW CAN I FURTHER
> INVESTIGATE THE REASONS FOR THIS ????
> 
> 
> Thanx alot in advance
> =====
> iVAN
> raptor@unacs.bg
> ====

Mime
View raw message