Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006


Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

RH AS4.0 SYBASE12.5 yesterday in a chair, and the successful completion of the installation, but when the final allocation sa password is some small problem : the installation of imported sa suggested that the password dialog box, set point being given a password, so no changes sa passwords; After installation, the reopening SYBASE startserver-f RUN_XXX start with the main program and then to see whether showserver opened, and found two SYBASE process showserver results are as follows :

-bash-3.00$ Showserver
VSZ RSS %CPU %MEM USER PID TTY STAT TIME COMMAND START
Sybase System 4488 0.0 7.3 52176 37808? Ss 04:18 0 : 07 /opt/sybase-12.5/ASE/bin/dataserver -sLINUX -d/opt/sybase-12.5/master.dat -e/opt/sybase-12.5/ASE/install/LINUX.log -c/opt/sybase-12.5/ASE/LINUX.cfg -M/opt/sybase-12.5/ASE
Sybase System 4489 0.0 7.3 52176 37808? S 04:18 0 : 00 /opt/sybase-12.5/ASE/bin/dataserver -sLINUX -d/opt/sybase-12.5/master.dat -e/opt/sybase-12.5/ASE/install/LINUX.log -c/opt/sybase-12.5/ASE/LINUX.cfg -M/opt/sybase-12.5/ASE

Port : 5000 to detect the use of reusable lsof -i, (I ASE is a 50-port services), the order was as follows :


COMMAND PID USER FD TYPE DEVICE SIZE Dalian NAME
Dataserve 4,488 12,245 Sybase System 11u IPv4 TCP LINUX:5000 (LISTEN)
Dataserve 4,489 12,245 Sybase System 11u IPv4 TCP LINUX:5000 (LISTEN)

But this time, with isql -Usa P-S in the local landing to Sybase System, Client not, it is estimated that start with the issue, which prawn to help out! ! ! !

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

Oh, I have this problem.
AS version is actually spent iptable firewall.
Under find in some iptable* etc., there is a configuration file, I do not remember the trails.
Shining example of a 5000 port operations plus access rules on the list.

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

My firewall is a ban, but in the next two iptables /etc document its path were :
/etc/sysconfig/iptables-config
/etc/rc.d/init.d/iptables

I do not know if what changes, please withheld teach me, thank you.

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

Oh, the message should be redirected to the linux版.
Iptables using iptables-V look at what is your version?
I have a gateway in the next /etc/sysconfig documents.
After the increase in the last accept his party. Look like put into port 5000 on the list.

# Firewall configuration written by system-config-securitylevel
# Manual customization of this file is not recommended.
*filter
: INPUT ACCEPT [0]
[0] FORWARD ACCEPT :
: OUTPUT ACCEPT [0]
: RH-Firewall-1-INPUT - [0]
A INPUT -j RH-Firewall-1-INPUT
A FORWARD -j RH-Firewall-1-INPUT
A RH-Firewall-1-INPUT -i lo -j ACCEPT
A RH-Firewall-1-INPUT-p icmp --icmp-type any -j ACCEPT
A 50-p -j ACCEPT RH-Firewall-1-INPUT
A 51-p -j ACCEPT RH-Firewall-1-INPUT
A RH-Firewall-1-INPUT 5353-d-p udp --dport 224.0.0.251 -j ACCEPT
A RH-Firewall-1-INPUT m-p udp udp --dport 631 -j ACCEPT
A --state RH-Firewall-1-INPUT m state ESTABLISHED, RELATED -j ACCEPT
A NEW RH-Firewall-1-INPUT m tcp-p tcp-m state --state --dport 22 -j ACCEPT
A NEW RH-Firewall-1-INPUT m tcp-p tcp-m state --state --dport 80 -j ACCEPT
A NEW RH-Firewall-1-INPUT m tcp-p tcp-m state --state --dport 21 -j ACCEPT
A NEW RH-Firewall-1-INPUT m tcp-p tcp-m state --state --dport 25 -j ACCEPT
A NEW RH-Firewall-1-INPUT m tcp-p tcp-m state --state --dport 5000 -j ACCEPT

A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited
COMMIT
I was the second increase in the countdown.
Then stop implementing /sbin/service iptables
/sbin/service Iptables start

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

Not ah, withheld, you suggested amending the iptables, the problem is still the same.
Help!

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

Iptables try not to stop.
/sbin/service Iptables stop
Then look at whether the client company;

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

Iptables has stopped, but the problem is still there.
Please save Bamboo brother!

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

I started the process of Sybase System, ah do not know to be able to see the problem? ?
-bash-3.00$ Startserver-f RUN_LINUX
Incorrectly built binary which accesses errno or -bash-3.00$
H_errno directly. Needs to be fixed.

Checked out license ASE_DEV 00:00000:00000:2005/06/02 04:15:48.97 Kernel
00:00000:00000:2005/06/02 04:15:48.99 Kernel Adaptive Server Enterprise Developer Edition.
00:00000:00000:2005/06/02 04:15:49.16 Kernel Using configure area from primary master device.
00:00000:00000:2005/06/02 04:15:49.20 Kernel Internal run-time model set for Linux-Native
00:00000:00000:2005/06/02 04:15:49.21 Kernel Using 1024 file descriptors.
00:00000:00000:2005/06/02 04:15 : 49.21 Kernel Adaptive Server Enterprise/12.5.0.1/EBF IR/P/Linux Intel/Linux 2.4.7-10smp i686/rel12501/1781/32-bit/OPT/Thu Jun 6 14 10292 : 14:09 2002
00:00000:00000:2005/06/02 04:15:49.21 Kernel Confidential property of Sybase, Inc..
00:00000:00000:2005/06/02 04:15:49.21 Kernel Copyright 1987, 2002
00:00000:00000:2005/06/02 04:15:49.21 Kernel Sybase, Inc.. All rights reserved.
00:00000:00000:2005/06/02 04:15:49.21 Kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/06/02 04:15:49.21 Kernel
00:00000:00000:2005/06/02 04:15:49.21 Kernel This software contains confidential and trade secret information of Sybase.
Kernel Inc. 00:00000:00000:2005/06/02 04:15:49.21. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2005/06/02 04:15:49.21 Kernel the U.S. government is subject to restrictions set forth in a license
00:00000:00000:2005/06/02 04:15:49.21 Kernel agreement between the government and Sybase, Inc.. Or other written
00:00000:00000:2005/06/02 04:15:49.21 Kernel agreement specifying the government 's rights to use the software and any
00:00000:00000:2005/06/02 04:15:49.21 Kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/06/02 04:15:49.21 Kernel Sybase, Inc.. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2005/06/02 04:15:49.21 Kernel Using '/opt/sybase-12.5/ASE/LINUX.cfg' for configuration information.
00:00000:00000:2005/06/02 04:15:49.21 Kernel Logging ASE messages in file '/opt/sybase-12.5/ASE/install/LINUX.log'.
00:00000:00000:2005/06/02 04:15:49.40 Kernel kdcl_sess_open : connectivity library supports master/query syntax.
00:00000:00000:2005/06/02 04:15:49.40 Kernel Directory Control Layer (DCL) using directory driver : InterfacesDriver
SSL Plus 00:00000:00000:2005/06/02 04:15:49.41 Kernel v3.0.8 security modules loaded successfully.
00:00000:00000:2005/06/02 04:15:49.41 Kernel Network and device connection limit is 1,014.
00:00000:00000:2005/06/02 04:15:49.51 server Number of blocks left for procedure headers : 3232.
Proc header 00:00000:00000:2005/06/02 04:15:49.52 server memory allocated 1,616 pages for each cache per engine.
Memory allocated for the default server 00:00000:00000:2005/06/02 04:15:49.54 cachelet 1 : 8192 Kb data cache
Size of the 2K server 00:00000:00000:2005/06/02 04:15:49.54 8192 Kb memory pool :
00:00000:00000:2005/06/02 04:15:49.54 Kernel Loading [librt.so.1] for Async disk I/O support.
Kernel : 04:15:49.56 dblkIO_aio_init 00:00000:00000:2005/06/02 mapped at 0xb5ac23f0
Kernel : 04:15:49.56 dblkIO_aio_read 00:00000:00000:2005/06/02 mapped at 0xb5ac2ef0
Kernel : 04:15:49.56 dblkIO_aio_write 00:00000:00000:2005/06/02 mapped at 0xb5ac3350
Kernel : 04:15:49.56 dblkIO_aio_suspend 00:00000:00000:2005/06/02 mapped at 0xb5ac3020
Kernel : 04:15:49.56 dblkIO_aio_return 00:00000:00000:2005/06/02 mapped at 0xb5ac2f30
Kernel : 04:15:49.56 dblkIO_aio_error 00:00000:00000:2005/06/02 mapped at 0xb5ac2f30
Enabling 00:00000:00000:2005/06/02 04:15:49.56 Kernel (RT) Posix asynchronous disk I/O strategy.
00:00000:00000:2005/06/02 04:15:49.56 Kernel Initializing virtual device 0, '/opt/sybase-12.5/master.dat' with dsync 'on'.
Virtual device 00:00000:00000:2005/06/02 04:15:49.56 Kernel started using asynchronous i/o 0.
00:00000:00000:2005/06/02 04:15:49.56 Kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2005/06/02 04:15:49.56 Kernel Either configure the parameter 'use security services' is set to 0. ASE does not support or use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2005/06/02 04:15:49.56 Unix Kernel for sysclk interval timer interrupts enabled.
00:00000:00000:2005/06/02 04:15:49.56 Kernel engine 0, pid 5209 online os
No active server traceflags 00:00000:00000:2005/06/02 04:15:49.58
00:00000:00001:2005/06/02 04:15:49.67 Kernel libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/EBF IR/P/Linux Intel/Linux 2.4.7-10smp i686/rel12501/1781/32-bit/OPT/Thu Jun 6 14 10292 : 14:09 2002 '.
00:00000:00001:2005/06/02 04:15:49.67 Kernel libomni1 - Component Integration Services : using 'Sybase Client-Library/12.5/P-EBF9963/DRV.12.5.0.1/Linux Intel/Linux 2.2.14-5.0smp i686/BUILD125-011/OPT/Mon Dec 3 15 : 14:08 2001 '
Opening Master Database server 00:00000:00001:2005/06/02 04:15:49.67. . .
Loading 00:00000:00001:2005/06/02 04:15:50.03 server SQL Server 's default character set and sort order
00:00000:00001:2005/06/02 04:15:50.05 server Loaded default Unilib conversion handle.
Recovering database server 00:00000:00001:2005/06/02 04:15:50.11 'master'.
00:00000:00001:2005/06/02 04:15:50.18 server Checking external objects.
00:00000:00001:2005/06/02 04:15:50.24 Server Database 'master' is now online.
00:00000:00001:2005/06/02 04:15:50.24 The transaction log in the database server 'master' will use I/O size of 2 Kb.
00:00000:00001:2005/06/02 04:15:50.25 server server name is' Linux '
00:00000:00001:2005/06/02 04:15:50.27 Activating disk server 'sysprocsdev' of the size 125829120 KB.
Initializing virtual device 00:00000:00001:2005/06/02 04:15:50.27 Kernel 1 '/opt/sybase-12.5/sybsystemp.dat' with dsync 'on'.
Virtual device 00:00000:00001:2005/06/02 04:15:50.27 Kernel started using asynchronous i/o 1.
00:00000:00001:2005/06/02 04:15:50.27 Activating disk server 'systemdbdev' of the size 5242880 KB.
Initializing virtual device 00:00000:00001:2005/06/02 04:15:50.27 Kernel 2 '/opt/sybase-12.5/sybsystemdb.dat' with dsync 'on'.
Virtual device 00:00000:00001:2005/06/02 04:15:50.27 Kernel started using asynchronous i/o 2.
Recovering database server 00:00000:00001:2005/06/02 04:15:50.32 'sybsystemdb'.
Count 16 : 04:15:50.33 server 00:00000:00001:2005/06/02 Boot
00:00000:00001:2005/06/02 04:15:50.35 server Checking external objects.
00:00000:00001:2005/06/02 04:15:50.35 The transaction log in the database server 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2005/06/02 04:15:50.36 Server Database 'sybsystemdb' is now online.
00:00000:00001:2005/06/02 04:15:50.39 Recovering database server 'model'.
00:00000:00001:2005/06/02 04:15:50.41 server Checking external objects.
00:00000:00001:2005/06/02 04:15:50.42 The transaction log in the database server 'model' will use I/O size of 2 Kb.
00:00000:00001:2005/06/02 04:15:50.42 Server Database 'model' is now online.
The logical server 00:00000:00001:2005/06/02 04:15:50.42 pagesize of the server is 2 Kb.
00:00000:00001:2005/06/02 04:15:50.42 server 0 dump conditions detected at boot time
00:00000:00001:2005/06/02 04:15:50.43 server Resident Node id : cfdf18fb38b9
00:00000:00001:2005/06/02 04:15:50.43 server Transaction coordinator initialized.
Clearing temperature db server 00:00000:00001:2005/06/02 04:15:50.43
The transaction log 00:00000:00001:2005/06/02 04:15:50.81 server in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/06/02 04:15:50.81 Server Database 'tempdb' is now online.
Recovering database server 00:00000:00001:2005/06/02 04:15:50.85 'sybsystemprocs'.
00:00000:00001:2005/06/02 04:15:50.87 server Checking external objects.
00:00000:00001:2005/06/02 04:15:50.88 The transaction log in the database server 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/06/02 04:15:50.89 Server Database 'sybsystemprocs' is now online.
00:00000:00002:2005/06/02 04:15:50.89 Linux Kernel network name, type ether, port 6000, the filter NONE
00:00000:00001:2005/06/02 04:15:50.91 server Recovery complete.
00:00000:00001:2005/06/02 04:15:50.91 server SQL Server 's default sort order is unicode' binary '.
00:00000:00001:2005/06/02 04:15:50.91 server SQL Server 's default sort order is :
00:00000:00001:2005/06/02 04:15:50.91 server 'nocasepref_cp850' (ID = 43)
00:00000:00001:2005/06/02 04:15:50.91 server on top of default character set :
00:00000:00001:2005/06/02 04:15:50.91 server 'cp850' (ID = 2).
00:00000:00001:2005/06/02 04:15:50.91 server Master device size : 30 megabytes. or 15,360 virtual pages. (A virtual page is 2,048 bytes. )

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

What is the address for Linux? 127.0.0.1 is not?
Client is the kind of system that isql Times, what is wrong? And whether the characters?

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

At 4:00 is the Internet?

Linux AS 4.0 Client Installation sybase12.5 link! Look at the masters

Halo, the problem was finally resolved, happy ING!
The problem is that the interfaces documents.
The original interfaces
LINUX
Master tcp ether LINUX 6000
Query tcp ether LINUX 6000


LINUX_BAK
Master tcp ether LINUX 6002
Query tcp ether LINUX 6002

Changed


LINUX
Master tcp ether 162.105.156.232 6000
Query tcp ether 162.105.156.232 6000


LINUX_BAK
Master tcp ether 162.105.156.232 6002
Query tcp ether 162.105.156.232 6002

A room


I have started to doubt the etho ip address is not a problem, through ifconfig investigation, there was really only trapped eth0 set a 162.105.156.232, a mindless PING 162.105.156.222 (the original eth0 IP). How could PING通 (not that they get to know this place, the revised IP, why can links. ), it will amend the /etc/sysconfig/network-scripts/ifcfg_eth0 and then reboot. PING162.105.156.222 then, well, not a link, but the link is still not isql, then try their luck, the amended document interfaces, haha Surprisingly get really across the vista!
I remember that in the name mainframe interfaces can be specified in the documents inside.
But back to why this happens, but no one understood. Please experts teach me.



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com