Re: Remote SSH login with user other than root takes ages to login - Linux, Apache, MySQL, PHP Discussion Boards

oops... lol, sorry it was for lounge.

Sorted now..

yes, PHP offers the usual for[^] and foreach[^] loop constructs.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

Hi,

Does anybody know why it takes atleast 10 mins to login to the LINUX (RedHat) server with a user other than root...? However root login is instant..!

I tried modifying the sshd_config file and uncommented
Used DNS no

But still no succcess...

Also, new user creation using the useradd xxxx command takes around 10 mins....

Thanks in advance,
Faez

There may be something wrong there... I don't experience any delays when using ssh. I mostly use Ubuntu though, but still doesn't make sense that it would take that long, there may be some sort of database problem.

Btw.. I am using putty to login... Is it related to network problems...?
I am not able to use ftp command also through the windows 'cmd' as the session expires...

Regards,
Faez

modified 8-Feb-12 4:03am.

Sounds like a network issue, I have used Red Hat in the past and never seen such a problem, even logging in from a client that is outside of the server's LAN.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Is the server configured[^] to use networked authentication like LDAP, NIS or Winbind?

Its using LDAP authentication..... Below is the ssh log..

CSS

[faez@SJP2VM0185 ~]$ ssh -vvv ranga@SJP2VM0185
OpenSSH_4.3p2, OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008
debug1: Reading configuration data /etc/ssh/ssh_config
debug1: Applying options for *
debug2: ssh_connect: needpriv 0
debug1: Connecting to SJP2VM0185 [10.102.51.77] port 22.
debug1: Connection established.
debug1: identity file /home/faez/.ssh/identity type -1
debug1: identity file /home/faez/.ssh/id_rsa type -1
debug1: identity file /home/faez/.ssh/id_dsa type -1
debug1: loaded 3 keys
debug1: Remote protocol version 2.0, remote software version OpenSSH_4.3
debug1: match: OpenSSH_4.3 pat OpenSSH*
debug1: Enabling compatibility mode for protocol 2.0
debug1: Local version string SSH-2.0-OpenSSH_4.3
debug2: fd 3 setting O_NONBLOCK
debug1: SSH2_MSG_KEXINIT sent
debug1: SSH2_MSG_KEXINIT received
debug2: kex_parse_kexinit: diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1
debug2: kex_parse_kexinit: ssh-rsa,ssh-dss
debug2: kex_parse_kexinit: aes128-cbc,3des-cbc,blowfish-cbc,cast128-cbc,arcfour128,arcfour256,arcfour,aes192-cbc,aes256-cbc,rijndael-cbc@lysator.liu.se,aes128-ctr,aes192-ctr,aes256-ctr
debug2: kex_parse_kexinit: aes128-cbc,3des-cbc,blowfish-cbc,cast128-cbc,arcfour128,arcfour256,arcfour,aes192-cbc,aes256-cbc,rijndael-cbc@lysator.liu.se,aes128-ctr,aes192-ctr,aes256-ctr
debug2: kex_parse_kexinit: hmac-md5,hmac-sha1,hmac-ripemd160,hmac-ripemd160@openssh.com,hmac-sha1-96,hmac-md5-96
debug2: kex_parse_kexinit: hmac-md5,hmac-sha1,hmac-ripemd160,hmac-ripemd160@openssh.com,hmac-sha1-96,hmac-md5-96
debug2: kex_parse_kexinit: none,zlib@openssh.com,zlib
debug2: kex_parse_kexinit: none,zlib@openssh.com,zlib
debug2: kex_parse_kexinit:
debug2: kex_parse_kexinit:
debug2: kex_parse_kexinit: first_kex_follows 0
debug2: kex_parse_kexinit: reserved 0
debug2: kex_parse_kexinit: diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1
debug2: kex_parse_kexinit: ssh-rsa,ssh-dss
debug2: kex_parse_kexinit: aes128-cbc,3des-cbc,blowfish-cbc,cast128-cbc,arcfour128,arcfour256,arcfour,aes192-cbc,aes256-cbc,rijndael-cbc@lysator.liu.se,aes128-ctr,aes192-ctr,aes256-ctr
debug2: kex_parse_kexinit: aes128-cbc,3des-cbc,blowfish-cbc,cast128-cbc,arcfour128,arcfour256,arcfour,aes192-cbc,aes256-cbc,rijndael-cbc@lysator.liu.se,aes128-ctr,aes192-ctr,aes256-ctr
debug2: kex_parse_kexinit: hmac-md5,hmac-sha1,hmac-ripemd160,hmac-ripemd160@openssh.com,hmac-sha1-96,hmac-md5-96
debug2: kex_parse_kexinit: hmac-md5,hmac-sha1,hmac-ripemd160,hmac-ripemd160@openssh.com,hmac-sha1-96,hmac-md5-96
debug2: kex_parse_kexinit: none,zlib@openssh.com
debug2: kex_parse_kexinit: none,zlib@openssh.com
debug2: kex_parse_kexinit:
debug2: kex_parse_kexinit:
debug2: kex_parse_kexinit: first_kex_follows 0
debug2: kex_parse_kexinit: reserved 0
debug2: mac_init: found hmac-md5
debug1: kex: server->client aes128-cbc hmac-md5 none
debug2: mac_init: found hmac-md5
debug1: kex: client->server aes128-cbc hmac-md5 none
debug1: SSH2_MSG_KEX_DH_GEX_REQUEST(1024<1024<8192) sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_GROUP
debug2: dh_gen_key: priv key bits set: 116/256
debug2: bits set: 490/1024
debug1: SSH2_MSG_KEX_DH_GEX_INIT sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY
debug3: check_host_in_hostfile: filename /home/faez/.ssh/known_hosts
debug3: check_host_in_hostfile: match line 1
debug3: check_host_in_hostfile: filename /home/faez/.ssh/known_hosts
debug3: check_host_in_hostfile: match line 1
debug1: Host 'sjp2vm0185' is known and matches the RSA host key.
debug1: Found key in /home/faez/.ssh/known_hosts:1
debug2: bits set: 489/1024
debug1: ssh_rsa_verify: signature correct
debug2: kex_derive_keys
debug2: set_newkeys: mode 1
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug2: set_newkeys: mode 0
debug1: SSH2_MSG_NEWKEYS received
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug2: service_accept: ssh-userauth
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug2: key: /home/faez/.ssh/identity ((nil))
debug2: key: /home/faez/.ssh/id_rsa ((nil))
debug2: key: /home/faez/.ssh/id_dsa ((nil))
debug1: Authentications that can continue: publickey,gssapi-with-mic,password
debug3: start over, passed a different list publickey,gssapi-with-mic,password
debug3: preferred gssapi-with-mic,publickey,keyboard-interactive,password
debug3: authmethod_lookup gssapi-with-mic
debug3: remaining preferred: publickey,keyboard-interactive,password
debug3: authmethod_is_enabled gssapi-with-mic
debug1: Next authentication method: gssapi-with-mic
debug3: Trying to reverse map address 10.102.51.77.
debug1: Unspecified GSS failure.  Minor code may provide more information
Unknown code krb5 195

debug1: Unspecified GSS failure.  Minor code may provide more information
Unknown code krb5 195

debug1: Unspecified GSS failure.  Minor code may provide more information
Unknown code krb5 195

debug2: we did not send a packet, disable method
debug3: authmethod_lookup publickey
debug3: remaining preferred: keyboard-interactive,password
debug3: authmethod_is_enabled publickey
debug1: Next authentication method: publickey
debug1: Trying private key: /home/faez/.ssh/identity
debug3: no such identity: /home/faez/.ssh/identity
debug1: Trying private key: /home/faez/.ssh/id_rsa
debug3: no such identity: /home/faez/.ssh/id_rsa
debug1: Trying private key: /home/faez/.ssh/id_dsa
debug3: no such identity: /home/faez/.ssh/id_dsa
debug2: we did not send a packet, disable method
debug3: authmethod_lookup password
debug3: remaining preferred: ,password
debug3: authmethod_is_enabled password
debug1: Next authentication method: password
ranga@sjp2vm0185's password:
debug3: packet_send2: adding 64 (len 59 padlen 5 extra_pad 64)
debug2: we sent a password packet, wait for reply
debug1: Authentication succeeded (password).
debug1: channel 0: new [client-session]
debug3: ssh_session2_open: channel_new: 0
debug2: channel 0: send open
debug1: Entering interactive session.

********************** HANGS HERE... RESUMES AFTER 10 MINS *********

debug2: callback start
debug2: client_session2_setup: id 0
debug2: channel 0: request pty-req confirm 0
debug3: tty_make_modes: ospeed 38400
debug3: tty_make_modes: ispeed 38400
debug3: tty_make_modes: 1 3
debug3: tty_make_modes: 2 28
debug3: tty_make_modes: 3 127
debug3: tty_make_modes: 4 21
debug3: tty_make_modes: 5 4
debug3: tty_make_modes: 6 0
debug3: tty_make_modes: 7 0
debug3: tty_make_modes: 8 17
debug3: tty_make_modes: 9 19
debug3: tty_make_modes: 10 26
debug3: tty_make_modes: 12 18
debug3: tty_make_modes: 13 23
debug3: tty_make_modes: 14 22
debug3: tty_make_modes: 18 15
debug3: tty_make_modes: 30 0
debug3: tty_make_modes: 31 0
debug3: tty_make_modes: 32 0
debug3: tty_make_modes: 33 0
debug3: tty_make_modes: 34 0
debug3: tty_make_modes: 35 0
debug3: tty_make_modes: 36 1
debug3: tty_make_modes: 37 0
debug3: tty_make_modes: 38 1
debug3: tty_make_modes: 39 0
debug3: tty_make_modes: 40 0
debug3: tty_make_modes: 41 0
debug3: tty_make_modes: 50 1
debug3: tty_make_modes: 51 1
debug3: tty_make_modes: 52 0
debug3: tty_make_modes: 53 1
debug3: tty_make_modes: 54 1
debug3: tty_make_modes: 55 1
debug3: tty_make_modes: 56 0
debug3: tty_make_modes: 57 0
debug3: tty_make_modes: 58 0
debug3: tty_make_modes: 59 1
debug3: tty_make_modes: 60 1
debug3: tty_make_modes: 61 1
debug3: tty_make_modes: 62 0
debug3: tty_make_modes: 70 1
debug3: tty_make_modes: 71 0
debug3: tty_make_modes: 72 1
debug3: tty_make_modes: 73 0
debug3: tty_make_modes: 74 0
debug3: tty_make_modes: 75 0
debug3: tty_make_modes: 90 1
debug3: tty_make_modes: 91 1
debug3: tty_make_modes: 92 0
debug3: tty_make_modes: 93 0
debug1: Sending environment.
debug3: Ignored env HOSTNAME
debug3: Ignored env TERM
debug3: Ignored env SHELL
debug3: Ignored env HISTSIZE
debug3: Ignored env SSH_CLIENT
debug3: Ignored env SSH_TTY
debug3: Ignored env USER
debug3: Ignored env LS_COLORS
debug3: Ignored env MAIL
debug3: Ignored env PATH
debug3: Ignored env INPUTRC
debug3: Ignored env PWD
debug1: Sending env LANG = en_US.UTF-8
debug2: channel 0: request env confirm 0
debug3: Ignored env SSH_ASKPASS
debug3: Ignored env SHLVL
debug3: Ignored env HOME
debug3: Ignored env LOGNAME
debug3: Ignored env CVS_RSH
debug3: Ignored env SSH_CONNECTION
debug3: Ignored env LESSOPEN
debug3: Ignored env G_BROKEN_FILENAMES
debug3: Ignored env _
debug2: channel 0: request shell confirm 0
debug2: fd 3 setting TCP_NODELAY
debug2: callback done
debug2: channel 0: open confirm rwindow 0 rmax 32768
debug2: channel 0: rcvd adjust 2097152
Last login: Thu Feb  9 10:20:37 2012 from 10.102.51.77
[ranga@SJP2VM0185 ~]$

Have You Tried Connecting to Your SSH Terminal, with the Debugging Flag?

If Not, Please try Connecting with the Verbose flag and Post the Output (ssh -vvv)

See this[^]?

if there are 2 list boxes and i want related sub-category of products in 2nd list box, whwreas in 1st list box there are categories of product...
how i will implement this ?

Simple suggestion, use AJAX

Anyone can help me with my project... i want to know what is the codes of automatic delete database files/data within an hour using php...because how many tries i do i can't get it...

modified 4-Feb-12 3:02am.

Dude,

->I cannot Get it either, will tell me, what you mean by automatic?

as well as delete database files and also what does it mean with in an hour?

->What is your actual problem?

Are you failing to delete tables?
Are you failing to detect list of tables?

or what?

I know I am coward since the day I know that fortune favors the brave

Your question is quite confusing, but what I understood is, you are trying to delete some data from a table-

Here you go -

SQL

DELETE FROM table_name
WHERE some_column = some_value

thanks!!!

Darkcrab Press is looking for potential authors to write book on any Technologies and Domain. Anyone interested in writing book on any Technologies and Domain please do contact author@darkcrab.com

Although I'm not a noob when it comes to programming, I have zero experience of web services so I'm seeking advice!

For one of our departments at work I have developed a simple CRUD application using Apache, MySQL and PHP on a local network server. This works fine Smile | :)

Due to expansion of the department, the database is to be migrated to the main DB server to which I will not be able to make direct calls from my PHP code due to security. They are happy however to create a webservice that I can use that will in turn access the database. I have total say in how the data will be returned to me for interpretation by my PHP pages and how I send data to the web service.

Which is the recommended way (I hear alot of 'talk' about JSON nowadays) and do you know of any good tutorials that you would recommend?

(I'm posting here as I'm not sure where is best, and from my side of things PHP will be doing all the communication with the service)

Dave

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.
Astonish us. Be exceptional. (Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Hi,

It is better to use XML way, which is more understandable and easy.But JSON is much efficient and fast.

If i correct understand you this help you http://php.net/manual/en/book.json.php[^]
If have another question you can write me in the skype, bloodmoonshard is my id.

I did understand that you would develop the serverside application with PHP

But I didn't understand what would be the client application, Would it be web browser? or are you going to develop Application to extract the reply from HTTP server.

I know I am coward since the day I know that fortune favors the brave

The Client will be a web browser using PHP/Apache on a local server. The local PHP scripts will communicate with the remote web service.

Web Browser <-> Local Apache/PHP <-> Web Service <-> Remote Apache/MySQL/PHP

Dave

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.
Astonish us. Be exceptional. (Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Both will be perfect,

or you just can create a user with permitting only one host ip with the limitation of tables connection. It wont do any herm

I know I am coward since the day I know that fortune favors the brave

Hi,

In ASP.NET, the best way to manage http errors e.g: Error 400.x, 500.x is to specify this in the web.config or globax.asax file.

How do I accomplish the same in php, because I was to get a nicely formatted error page displayed to my users instead of the anoying apache error page.

Please help!

You can configure your Apache server to display custom error pages using the ErrorDocument directive: http://httpd.apache.org/docs/2.2/mod/core.html#errordocument[^]