06-29-2018
Different connection status between 2 servers
Hello All,
Actually, We have a problem in our server (RHEL 7.1), 1st server is used for payment apps like switch card payment (passthru only), and 2nd server is used for Database transaction.
When high transaction there is different connection between Apps Server and DB server, Apps Server sends connection to DB Server, but sometimes that's connection not ESTABLISHED like low traffic (I checked thru netstat in 2 servers). I have changed value Local_port range, and fin_timeout but it wasn't solve this problem, and I think my current kernel needs to update kernel to latest or stable version to solve this.
current kernel : 3.10.0-229.e17.x86_64
Please give me suggest about our this connection problem.
Thank you
Regards
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
I'm newbie to shell script. I wanted to create a shell script which able to write a result for all the telnet connection status. For example, from this machine I want to test the telnet connection (total 100+ servers) with this machine.
Any idea how to write this shell script?... (16 Replies)
Discussion started by: yhcheong
16 Replies
2. Shell Programming and Scripting
hi,
Say me the command to check the status of server. whether its up or down (11 Replies)
Discussion started by: satheeshkr_cse
11 Replies
3. Red Hat
Hi,
I want to kill TCP connections which have status as TIME_WAIT & no PID
(as per the output of the "netstat - p" command).
Is there any command/utility available to kill connections to a specific port or IP address.
The problem is that these connections don't have process ID (see... (4 Replies)
Discussion started by: Davinder31may
4 Replies
4. Shell Programming and Scripting
Hello,
I am looking for a way for a server to launch a connection command to one of the other servers where the connection command has already embedded in it a server name, user name and a password. (2 Replies)
Discussion started by: LiorAmitai
2 Replies
5. Shell Programming and Scripting
Hi,
I am running a shell script which will spawn the telnet and login.
But sometimes, the telnet session itself is not getting spawned.
My requirement is, if the telnet session is not spawned, the user must be notified that it failed.
Is there any command to capture the status of telnet... (2 Replies)
Discussion started by: merin
2 Replies
6. Solaris
hello all,
i have a question if i have two servers each one run an application i want to make a tunnel channel between the two servers the two application each one has a specific port .
for example server A has port 2001 and server B has port 2002
server A talk to server A using any... (1 Reply)
Discussion started by: maxim42
1 Replies
7. Shell Programming and Scripting
Suppose i have 3 different servers say x,y and z.
Im running some process say ABC and 40 instances for the same is being created.
In load sharing suppose on
server x, 20 instances are running
server y, 10 instances are running
server z, 10 instances are running.
While checking the... (1 Reply)
Discussion started by: ankitknit
1 Replies
8. AIX
Hi Techies,
I have a doubt.
ent0 Available Logical Host Ethernet Port (lp-hea)
ent1 Available Logical Host Ethernet Port (lp-hea)
ent2 Available Logical Host Ethernet Port (lp-hea)
ent3 Available Logical Host Ethernet Port (lp-hea)
ent4 Available... (4 Replies)
Discussion started by: jayadeava
4 Replies
9. Shell Programming and Scripting
Hi All,
We are working on linux with putty terminal for file transferring using SFTP server...
here we want to know /We have Urgent Requirement
If SFTP connection is successfull then we should get .txt log file in target locaton as "Success/Failure"
Please provide batch script for above... (7 Replies)
Discussion started by: sravanreddy
7 Replies
10. UNIX for Dummies Questions & Answers
I'm trying to connect from Server A to Server B to transfer files from A to B. I'm using NUID A1 in Server A and NUID A2 in Server B. I have done the following the steps to setup password-less login.
1. Add the public key of A1 in A to the Authorized keys of A2 in B.
2. Add the public key of... (4 Replies)
Discussion started by: sanchid312
4 Replies
LEARN ABOUT PHP
pdo_sqlsrv-dsn
PDO_SQLSRV-DSN(3) 1 PDO_SQLSRV-DSN(3)
PDO_SQLSRV DSN - Connecting to MS SQL Server and SQL Azure databases
The PDO_SQLSRV Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is sqlsrv:.
o APP - The application name used in tracing.
o ConnectionPooling - Specifies whether the connection is assigned from a connection pool (1 or TRUE) or not (0 or FALSE).
o Database - The name of the database.
o Encrypt - Specifies whether the communication with SQL Server is encrypted (1 or TRUE) or unencrypted (0 or FALSE).
o Failover_Partner - Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary
server is unavailable.
o LoginTimeout - Specifies the number of seconds to wait before failing the connection attempt.
o MultipleActiveResultSets - Disables or explicitly enables support for multiple active Result sets (MARS).
o QuotedId - Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE) or to use legacy Transact-SQL rules (0 or
false).
o Server - The name of the database server.
o TraceFile - Specifies the path for the file used for trace data.
o TraceOn - Specifies whether ODBC tracing is enabled (1 or TRUE) or disabled (0 or FALSE) for the connection being established.
o TransactionIsolation - Specifies the transaction isolation level. The accepted values for this option are PDO::SQL-
SRV_TXN_READ_UNCOMMITTED, PDO::SQLSRV_TXN_READ_COMMITTED, PDO::SQLSRV_TXN_REPEATABLE_READ, PDO::SQLSRV_TXN_SNAPSHOT, and PDO::SQL-
SRV_TXN_SERIALIZABLE.
o TrustServerCertificate - Specifies whether the client should trust (1 or TRUE) or reject (0 or FALSE) a self-signed server cer-
tificate.
o WSID - Specifies the name of the computer for tracing.
Example #1
PDO_SQLSRV DSN examples
The following example shows how to connecto to a specified MS SQL Server database:
$c = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");
The following example shows how to connect to a MS SQL Server database on a specified port:
$c = new PDO("sqlsrv:Server=localhost,1521;Database=testdb", "UserName", "Password");
The following example shows how to connecto to a SQL Azure database with server ID 12345abcde. Note that when you connect to SQL
Azure with PDO, your username will be UserName@12345abcde (UserName@ServerId).
$c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password");
PHP Documentation Group PDO_SQLSRV-DSN(3)