Ivorde Unix/Linux/Database/Web/Mail Forum

**Posted:** Tue Nov 22, 2011 4:40 pm

How to select rows from a mysql table containing multiple records, all of them having a datetime column.

Example mysql table:

Code:

mysql> select * from info;
+---------+---------------------+------------+
| id | upload_date    | ip    |
+---------+---------------------+------------+
|       1 | 2011-11-21 21:07:29 | 0123456789 |
|       2 | 2011-11-21 21:15:07 | 0123456789 |
|       3 | 2011-11-22 14:26:49 | 0123456789 |
+---------+---------------------+------------+
3 rows in set (0.00 sec)

Selecting rows with datetime column equal to today's ...

**Posted:** Mon Nov 21, 2011 11:12 pm

Unlike other sql commands, stored procedures need to be called. Therefore the CALL command needs to be used:

Code:

mysql> CALL stored_procedure_name('argument1,'argument2');

**Posted:** Mon Nov 21, 2011 10:57 pm

Mysql command to show stored procedures

Code:

mysql> show procedure status \G;

or to show stored procedure for a specific database:

Code:

mysql> show procedure status where Db = 'database_name' \G;

**Posted:** Thu Nov 10, 2011 1:39 pm

Apache - how to strip down the "Server" field in HTTP response header with ServerTokens

By default, the apache webserver may provide too detailed info in the http response header for your needs. Example:

Code:

HTTP/1.1 404 Not Found
Date: Thu, 10 Nov 2011 10:35:52 GMT
Server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e
Vary: Accept-Encoding
Content-Encoding: gzip
Content-Length: 202
Connection: close
Content-Type: text/html; charset=iso-8859-1

Stripping down the "Server" field in the http response can be done in ...

**Posted:** Tue Nov 01, 2011 4:50 pm

Giving that a system has ntpd up&running, ntpq utility can be used to check system time synchronization:

Code:

# ntpq -pn
     remote           refid      st t when poll reach   delay   offset  jitter
==============================================================================
+80.96.120.251   .PPS.            1 u  984 1024  377   10.723   -0.909   1.437
+80.96.120.252   .PPS.            1 u  851 1024  377   10.800   -0.503   0.476
*80.96.120.253   .PPS.            1 u 1019 1024  377   10.611   -0.698   0.669

Man ntpq quote:

Quote:

NTPQ(8) FreeBSD System Manager's Manual NTPQ(8)

NAME
ntpq -- ...

**Posted:** Mon Oct 31, 2011 2:03 pm

In Bash shell, redirecting output to a existing file is not possible if the "noclobber" bash option is set.

To overcome this, use the ">|" or ">>" redirect operator. The pipe will overwrite the file if you are using single angle bracket and append if you're using double angle brackets.

How to forcely overwrite a file with output from a command:

# cat output
# echo 'output' >output
-bash: output: cannot overwrite existing file ...

**Posted:** Mon Oct 31, 2011 1:54 pm

A little background from bashref:http://www.gnu.org/software/bash/manual/bashref.html

Quote:

3.2.4.3 Grouping Commands

Bash provides two ways to group a list of commands to be executed as a unit. When commands are grouped, redirections may be applied to the entire command list. For example, the output of all the commands in the list may be redirected to a single stream.

()
( list )

Placing a list of commands between parentheses causes a subshell environment to be created (see Command ...

**Posted:** Sun Oct 30, 2011 2:36 pm

After setting up the IPSec tunnel between the two FreeBSD hosts (FreeBSD-A and FreeBSD-B) in part 1 (http://forum.ivorde.ro/freebsd-to-freebsd-ospf-over-gre-over-ipsec-transport-mode-racoon-part-1-t860.html using gre0 interfaces on both nodes, in this part I set up OSPF.

The relevant OSPFD configuration (quagga) on both nodes is simple. This is for FreeBSD-A node:

Code:

!
interface gre0
 ip ospf hello-interval 2
 ip ospf dead-interval 6
!
router ospf
 ospf router-id A2.A2.A2.A2
 redistribute static
 network A2.A2.A2.A2/30 area 0.0.0.0
!

Ospf "hello" packets ...

**Posted:** Mon Oct 17, 2011 4:27 pm

How to check if ssh/http daemon listens on TCP port in FreeBSD using sockstat & lsof & netstat utilities

As compared to Linux, FreeBSD "netstat" doesn't show the process ID, but instead, the "sockstat" utility does.

Checking SSH and Apache TCP ports in Linux and FreeBSD using lsof utility:
# lsof -Pni :22 -i :80
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
httpd 17543 www 3u IPv6 0xc35d3cb0 0t0 TCP *:80 (LISTEN)
sshd ...

**Posted:** Mon Oct 17, 2011 4:17 pm

To show listening sockets in Unix, the "netstat" utility can be used with different arguments, depending on the specific OS.

Man netstat:

Quote:

--numeric , -n
Show numerical addresses instead of trying to determine symbolic host, port or user names.
-e, --extend
Display additional information. Use this option twice for maximum detail.

-p, --program
Show the PID and name of the program to which each socket belongs.

-l, --listening
Show only listening sockets. ...

Ivorde Unix/Linux/Database/Web/Mail Forum

News of Ivorde Unix/Linux/Database/Web/Mail Forum

Site map of Ivorde Unix/Linux/Database/Web/Mail Forum » Forum : Ivorde Unix/Linux/Database/Web/Mail Forum

Last 10 active topics

TCP/IP Networking

Linux & BSD on desktops and Multimedia stations

Virtualization

Mysql

Login

Statistics