niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
· nixdoc.net · man pages · Linux HOWTOs · FreeBSD Tips · Forums
navigation Forum index » Databases » Sybase
ASE 12.5 stops accepting connections
Post new topic   Reply to topic Page 4 of 5 [64 Posts] View previous topic :: View next topic
Goto page:  Previous  1, 2, 3, 4, 5 Next
Author Message
Michael Peppler
*nix forums Guru Wannabe


Joined: 15 May 2005
Posts: 112

PostPosted: Wed Jun 15, 2005 2:28 pm    Post subject: Re: Sybase sitting on its hands or not publishing new features Reply with quote

On Wed, 15 Jun 2005 12:25:31 -0400, Thomas Gagne wrote:

Quote:
I thought of another - I'd like to be able to use cursors inside
interactive SQL instead of being forced to create procedures when I need a
cursor.

You can.

You just need to create the cursor (or declare it, I forget which) in a
separate batch...

Michael
--
Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
Back to top
Thomas Gagne
*nix forums beginner


Joined: 15 Mar 2005
Posts: 35

PostPosted: Wed Jun 15, 2005 4:54 pm    Post subject: Re: Sybase sitting on its hands or not publishing new features Reply with quote

What do you mean? When I try what I /think/ you mean I get:

tgagne:efinnet 1.1> declare @test int
tgagne:efinnet 1.2> go
tgagne:efinnet 2.1> set @test = 1
tgagne:efinnet 2.2> go
Msg 137, Level 15, State 1
Server 'tgagne', Procedure '', Line 1
Must declare variable '@test'.
Back to top
Michael Peppler
*nix forums Guru Wannabe


Joined: 15 May 2005
Posts: 112

PostPosted: Wed Jun 15, 2005 5:17 pm    Post subject: Re: Sybase sitting on its hands or not publishing new features Reply with quote

On Wed, 15 Jun 2005 14:54:19 -0400, Thomas Gagne wrote:

Quote:
What do you mean? When I try what I /think/ you mean I get:

tgagne:efinnet 1.1> declare @test int tgagne:efinnet 1.2> go
tgagne:efinnet 2.1> set @test = 1
tgagne:efinnet 2.2> go
Msg 137, Level 15, State 1
Server 'tgagne', Procedure '', Line 1 Must declare variable '@test'.

I thought you meant a cursor?

declare cursor ... for select ...
go
declare @foo, etc.
open cursor
while @@sqlstatus = 0
begin
fetch cursor...
end
go

Michael
--
Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
Back to top
Thomas Gagne
*nix forums beginner


Joined: 15 Mar 2005
Posts: 35

PostPosted: Thu Jun 16, 2005 12:03 am    Post subject: Re: Sybase sitting on its hands or not publishing new features Reply with quote

I did but I thought testing it with a regular declare would indicate how
it would work with a cursor. Perhaps not?

How about that! I just tried it and it worked.

A little inconsistent with the way other "declare" statements work but
hey, what the heck!

Michael Peppler wrote:
Quote:
On Wed, 15 Jun 2005 14:54:19 -0400, Thomas Gagne wrote:


What do you mean? When I try what I /think/ you mean I get:

tgagne:efinnet 1.1> declare @test int tgagne:efinnet 1.2> go
tgagne:efinnet 2.1> set @test = 1
tgagne:efinnet 2.2> go
Msg 137, Level 15, State 1
Server 'tgagne', Procedure '', Line 1 Must declare variable '@test'.


I thought you meant a cursor?

declare cursor ... for select ...
go
declare @foo, etc.
open cursor
while @@sqlstatus = 0
begin
fetch cursor...
end
go

Michael
Back to top
Anthony Mandic
*nix forums Guru Wannabe


Joined: 05 Jul 2005
Posts: 164

PostPosted: Thu Jun 16, 2005 12:11 am    Post subject: Re: Sybase sitting on its hands or not publishing new features Reply with quote

Thomas Gagne wrote:
Quote:

I thought of another - I'd like to be able to use cursors inside
interactive SQL instead of being forced to create procedures when I need
a cursor.

Er, you can.

Quote:
Often times I need to create fix scripts that are run-once items.
Creating a procedure, running it, then dropping it doesn't make sense.

So why not create a batch?

Quote:
I would think Sybase engineers would use the database themselves and
would have added some of these features themselves by now. Oh well,
perhaps the ISUG is the only way...

Enhancements are one thing. Knowing how to code T-SQL is another.

-am 2005
Back to top
Anthony Mandic
*nix forums Guru Wannabe


Joined: 05 Jul 2005
Posts: 164

PostPosted: Thu Jun 16, 2005 12:13 am    Post subject: Re: Sybase sitting on its hands or not publishing new features Reply with quote

Thomas Gagne wrote:
Quote:

What do you mean? When I try what I /think/ you mean I get:

tgagne:efinnet 1.1> declare @test int
tgagne:efinnet 1.2> go
tgagne:efinnet 2.1> set @test = 1
tgagne:efinnet 2.2> go
Msg 137, Level 15, State 1
Server 'tgagne', Procedure '', Line 1
Must declare variable '@test'.

I don't think you understand what the 'go' does.

Try this instead -

declare @test int
set @test = 1
select @test
go

-am 2005
Back to top
Thomas Gagne
*nix forums beginner


Joined: 15 Mar 2005
Posts: 35

PostPosted: Thu Jun 16, 2005 5:07 pm    Post subject: Re: Sybase sitting on its hands or not publishing new features Reply with quote

My point with that example was to show how a variable declared in one
batch is not available in another. I had (wrongly) assumed the same
rule would apply to cursors. The 'go' did exactly what I expected, but
thanks for pointing out I wasn't clear on what the example demonstrated.

Anthony Mandic wrote:
Quote:
Thomas Gagne wrote:

What do you mean? When I try what I /think/ you mean I get:

tgagne:efinnet 1.1> declare @test int
tgagne:efinnet 1.2> go
tgagne:efinnet 2.1> set @test = 1
tgagne:efinnet 2.2> go
Msg 137, Level 15, State 1
Server 'tgagne', Procedure '', Line 1
Must declare variable '@test'.


I don't think you understand what the 'go' does.

Try this instead -

declare @test int
set @test = 1
select @test
go

-am 2005
Back to top
pokerdragon
*nix forums beginner


Joined: 23 May 2005
Posts: 14

PostPosted: Thu Jun 16, 2005 7:41 pm    Post subject: Re: upgrade issues - infected processes Reply with quote

Quote:
OK. Are you using 2PC?

Yes, though non-traditionally... we're using it in a single-dataserver
environment. It's a lousy way of doing things, but that's the way the
consultants made it work a decade ago. We're going to be removing that
logic but it will take time.

Quote:
From your comments, I gather that you are dynamically extending
memory rather than creating it all at once. Is that correct?

Correct.

Quote:
According to the release notes, the ASE 12.5.3 EBFs can only be
installed over ASE 12.5.2 or 12.5.3 for an existing database.
I'm not sure why. The binaries are all selfcontained. Its probably
due to the other things. But I don't know what would affect the
database itself.

We did indeed install 12.5.3 over 12.5.2.

Funny thing is, we've now discovered a bug in 12.5.3 ESD1 that is
causing some applications to fail. The bug (Auxiliary scan
descriptors) is fixed in ESD2, but ESD2 causes this error which breaks
our other applications:

01:00000:00223:2005/06/16 15:52:35.59 server The server is probing the
commit service to determine the status of the Sybase two-phase
transaction: 1645643229.SYB_480.RSAM

This message shows up 4 times, then the application fails with 20010:
Attempt to initiate new SQL Server operation with results pending.
Back to top
Anthony Mandic
*nix forums Guru Wannabe


Joined: 05 Jul 2005
Posts: 164

PostPosted: Thu Jun 16, 2005 11:44 pm    Post subject: Re: upgrade issues - infected processes Reply with quote

pokerdragon wrote:
Quote:

OK. Are you using 2PC?

Yes, though non-traditionally... we're using it in a single-dataserver
environment. It's a lousy way of doing things, but that's the way the
consultants made it work a decade ago. We're going to be removing that
logic but it will take time.

It probably just as well. It sounds very odd to me to use 2PC
with only the one server.

Quote:
From your comments, I gather that you are dynamically extending
memory rather than creating it all at once. Is that correct?

Correct.

That may be the problem. Since that is new to ASE, I would expect
the likelihood of there being bugs in the code to be higher than
in more established code. Since you mentioned that it seems to
happen once it extends, it may be the way its done. I understand
that the memory extend creates a new shared memory segment. It
might be something odd happening at the boundary between two such
segments. Anyway, my contact says they allocate all in one go, so
try that to see if the problem goes away.

Quote:
According to the release notes, the ASE 12.5.3 EBFs can only be
installed over ASE 12.5.2 or 12.5.3 for an existing database.
I'm not sure why. The binaries are all selfcontained. Its probably
due to the other things. But I don't know what would affect the
database itself.

We did indeed install 12.5.3 over 12.5.2.

OK.

Quote:
Funny thing is, we've now discovered a bug in 12.5.3 ESD1 that is
causing some applications to fail. The bug (Auxiliary scan
descriptors) is fixed in ESD2, but ESD2 causes this error which breaks
our other applications:

01:00000:00223:2005/06/16 15:52:35.59 server The server is probing the
commit service to determine the status of the Sybase two-phase
transaction: 1645643229.SYB_480.RSAM

This message shows up 4 times, then the application fails with 20010:
Attempt to initiate new SQL Server operation with results pending.

That last message suggests a bug in your code. It means that
there are results returned from the server that your application
hasn't processed. Basically, you can't start a new transaction
until your client-side code has processed all the results returned
from the server. If you search this newsgroup on Google with
"result pending" as the match, you should find lots of similar
comments in other, old posts. The message you get before that
about the probe isn't an error. But getting rid of the redundant
2PC code will help you.

-am 2005
Back to top
steve
*nix forums addict


Joined: 23 Mar 2005
Posts: 70

PostPosted: Wed Jun 29, 2005 4:35 pm    Post subject: Re: storing passwords in a file Reply with quote

"" wrote:
Quote:
Hi,

I want to store the sa password in a file which I want to read
from a
script file (which will run via cron).

Is there a way to do it so that the unix admin cannot read the
password?

Thanks and regards,
Ashish

Hi ashish....
read ur query..
I just made a script where i get the input (login name and
password) from the user.
I tried by keeping the password in a file and then loggin in .I was
succesful!
Just try this
Quote:
store the password ...for eg..ashish in a file secret
now login as "sa"

isql -Usa -Sase_xxx -w100 -P `cat secret`
....here I have used cat command .
try this

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Sybase-storing-passwords-file-ftopict219204.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=819820
Back to top
Anthony Mandic
*nix forums Guru Wannabe


Joined: 05 Jul 2005
Posts: 164

PostPosted: Thu Jun 30, 2005 5:31 am    Post subject: Re: storing passwords in a file Reply with quote

crazy_monk wrote:
Quote:

"" wrote:

I want to store the sa password in a file which I want to read
from a
script file (which will run via cron).

Is there a way to do it so that the unix admin cannot read the
password?

read ur query..
I just made a script where i get the input (login name and
password) from the user.
I tried by keeping the password in a file and then loggin in .I was
succesful!
Just try this
store the password ...for eg..ashish in a file secret
now login as "sa"

isql -Usa -Sase_xxx -w100 -P `cat secret`
....here I have used cat command .
try this

As was pointed out, the root account on Unix can read any file.

As to your solution, the `cat secret` will end up substituting the
contents of the secret file in that position on the command line.
Which means it will be seen with ps (depending on the version of
Unix). The proper way is to echo it into the command so that it
reads the password from standard input. I.e. " ... | isql -U ... - S ...".
Here, no password is supplied on the command line, so isql prompts
for it and reads it from the pipe.

-am 2005
Back to top
Thomas Gagne
*nix forums beginner


Joined: 15 Mar 2005
Posts: 35

PostPosted: Thu Jun 30, 2005 6:12 pm    Post subject: Re: storing passwords in a file Reply with quote

Using "is", an isql replacement, I can pass username and password as
environment variables, so they won't appear on the command line.
Back to top
steve
*nix forums addict


Joined: 23 Mar 2005
Posts: 70

PostPosted: Sat Jul 02, 2005 1:36 am    Post subject: Re: storing passwords in a file Reply with quote

"" wrote:
Quote:
Hi,

I want to store the sa password in a file which I want to read
from a
script file (which will run via cron).

Is there a way to do it so that the unix admin cannot read the
password?

Thanks and regards,
Ashish

Hi anthony...
i tried the way which u told me to do...
bt am unsuccessful..
but there is no need to pipe the commands...
even with cat u can provide the password .also it is nt visible
with ps command...
kindly throw some more light on this topic...
regards
monk

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Sybase-storing-passwords-file-ftopict219204.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=821444
Back to top
Luc
*nix forums beginner


Joined: 03 Mar 2005
Posts: 10

PostPosted: Mon Jul 25, 2005 10:36 am    Post subject: Re: ASE 12.5 & ResultSet & JAVA Reply with quote

Quote:
After having estaibilshed a connection with my DB i'm tryng to produce a
resultset and to update my Db. My program runs, and exit without errors,
but i have no output!
this is my problem:

try {
Statement stm = con.createStatement();
res = stm.executeQuery("SELECT * FROM
SCHEMADESCRIPTION");
con.commit();
while (res.next()) {
String Item1 = (String)res.getObject(0);
String Item2 = (String)res.getObject(1);
System.out.println("Values returned");
System.out.println(Item1);
System.out.println(Item2);
}
} catch (SQLException e) {
e.getMessage();
}

The program stops when I try to read the values! In fact I cannot see
System.out.println("Values returned")! The program stops.
Then I modified the program in this way:
int i = 0;
while (res.next()) {
i=i+1;
System.out.println(i);
}

and in this way output returns 52 integers, the numbers of my results!
Connection is established, resultSet are returened, but I cannot read
that values!

My jdbc reference book says that the ColumnIndex passed as parameter
to the getXXX methods start with 1, not 0 as in your example.

If that's not the issue, do the first columns in the table have
char values ? What if you use getString, getInt, or whatever type
the column has ? Perhaps there is a problem with the typecasting.
I don't know where other errors are catched but probably there is
some error that is catched and not reported.

Luc.
Back to top
Webnauta
*nix forums beginner


Joined: 25 Jul 2005
Posts: 5

PostPosted: Mon Jul 25, 2005 11:12 am    Post subject: Re: ASE 12.5 & ResultSet & JAVA Reply with quote

Luc wrote:
Quote:
After having estaibilshed a connection with my DB i'm tryng to produce a
resultset and to update my Db. My program runs, and exit without errors,
but i have no output!

this is my problem:

try {
Statement stm = con.createStatement();
res = stm.executeQuery("SELECT * FROM
SCHEMADESCRIPTION");
con.commit();
while (res.next()) {
String Item1 = (String)res.getObject(0);
String Item2 = (String)res.getObject(1);
System.out.println("Values returned");
System.out.println(Item1);
System.out.println(Item2);
}
} catch (SQLException e) {
e.getMessage();
}

The program stops when I try to read the values! In fact I cannot see
System.out.println("Values returned")! The program stops.
Then I modified the program in this way:
int i = 0;
while (res.next()) {
i=i+1;
System.out.println(i);
}

and in this way output returns 52 integers, the numbers of my results!
Connection is established, resultSet are returened, but I cannot read
that values!


My jdbc reference book says that the ColumnIndex passed as parameter
to the getXXX methods start with 1, not 0 as in your example.

If that's not the issue, do the first columns in the table have
char values ? What if you use getString, getInt, or whatever type
the column has ? Perhaps there is a problem with the typecasting.
I don't know where other errors are catched but probably there is
some error that is catched and not reported.

Luc.




Thanks Luc! Now it runs. The problem was the ColumnIndex! Thanks.
The problem still remains when I try an executeUpdate(). I don't
understand why I cannot catch SQLException! the programlog as sa, so it
should let update and creation of new tables. But my program stops!
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 4 of 5 [64 Posts] Goto page:  Previous  1, 2, 3, 4, 5 Next
View previous topic :: View next topic
The time now is Sat Oct 25, 2014 6:58 am | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Rejecting connections based on IP range. Evil Ernie Exim 2 Thu Jul 20, 2006 8:54 pm
No new posts NULL vs 127.0.0.1 passed to milter for connections from l... April Lorenzen Postfix 2 Sun Jul 16, 2006 4:47 pm
No new posts HTTP-server && connections stuck in TCP state BOUND Matthias Apitz Solaris 0 Thu Jul 13, 2006 9:28 am
No new posts How to make code accepting differet types work? Jim Langston C++ 9 Wed Jul 12, 2006 9:09 am
No new posts Accepting XML input Bill H Perl 3 Thu Jul 06, 2006 7:09 pm

Copyright © 2004-2005 DeniX Solutions SRL
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum |  email marketing service
 
Privacy Policy
[ Time: 0.1344s ][ Queries: 16 (0.0921s) ][ GZIP on - Debug on ]