Журнал лабораторных работ

Содержание

Журнал

Вторник (12/19/06)

/dev/ttyv1
16:39:19
#make search name="mysql" | less
16:40:43
#cd databases/

16:40:46
#ls
fireprofile                             pear-DB_DataObject_FormBuilder
fpc-ibase                               pear-DB_Pager
fpc-mysql                               pear-DB_QueryTool
fpc-odbc                                pear-DB_Table
fpc-oracle                              pear-DB_ldap
fpc-postgres                            pear-MDB
freetds                                 pear-MDB2
freetds-msdblib                         pear-MDB_QueryTool
gadfly                                  pecl-memcache
gauche-gdbm                             pecl-sqlite
...
p5-DBI-Shell                            wfb2sql
p5-DBIWrapper                           wmjsql
p5-DBIx-AnyDBD                          xbase
p5-DBIx-Browse                          xbsql
p5-DBIx-ContextualFetch                 xmbase-grok
p5-DBIx-DBSchema                        xmysqladmin
p5-DBIx-DataSource                      yasql
p5-DBIx-Ease                            zodb
p5-DBIx-Password                        zodb3
p5-DBIx-Recordset
16:40:46
#cd mysql
mysql++/              mysql323-server/      mysql50-scripts/
mysql-administrator/  mysql40-client/       mysql50-server/
mysql-connector-java/ mysql40-scripts/      mysql_last_value/
mysql-editor/         mysql40-server/       mysqlcc/
mysql-navigator/      mysql41-client/       mysqlcppapi/
mysql2pgsql/          mysql41-scripts/      mysqlman/
mysql323-client/      mysql41-server/       mysqltcl/
mysql323-scripts/     mysql50-client/
16:40:46
#cd mysql50-server/

16:41:07
#ls
Makefile                pkg-descr               pkg-plist.client
distinfo                pkg-install             pkg-plist.scripts
files                   pkg-plist
16:41:10
#cat distinfo
MD5 (mysql-5.0.9-beta.tar.gz) = 8899d591d549d1d8ca61f5741bff490c
SIZE (mysql-5.0.9-beta.tar.gz) = 18615183
16:41:17
#cat pkg-descr
MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server.
WWW: http://www.mysql.com/
- Alex Dupre
ale@FreeBSD.org
16:41:34
#make install clean
===>  mysql-server-5.0.9_1 is marked as broken: MySQL versions mismatch: mysql41-client is installed and wanted version is mysql50-client.
===>  Cleaning for mysql-client-5.0.9_1
===>  Cleaning for libtool-1.5.18
===>  Cleaning for mysql-server-5.0.9_1
16:41:48
#cd ../mysql4
mysql40-client/  mysql40-server/  mysql41-scripts/
mysql40-scripts/ mysql41-client/  mysql41-server/
16:41:48
#cd ../mysql41-client/

16:42:52
#make deinstall
===>  Deinstalling for databases/mysql41-client
===>   Deinstalling mysql-client-4.1.13
pkg_delete: package 'mysql-client-4.1.13' is required by these other packages
and may not be deinstalled (but I'll delete it anyway):
koffice-1.4.1,1
kde-3.4.2
16:42:57
#make clean
===>  Cleaning for libtool-1.5.18
===>  Cleaning for mysql-client-4.1.13
16:43:03
#cd ../mysql50-server/

16:43:14
#cd ../mysql50-server/

16:43:15
#make install clean
===>  Vulnerability check disabled, database not found
You may use the following build options:
        WITH_CHARSET=charset    Define the primary built-in charset (latin1).
        WITH_XCHARSET=list      Define other built-in charsets (may be 'all').
        WITH_COLLATION=collate  Define default collation (latin1_swedish_ci).
        WITH_OPENSSL=yes        Enable secure connections.
        WITH_LINUXTHREADS=yes   Use the linuxthreads pthread library.
        WITH_PROC_SCOPE_PTH=yes Use process scope threads
                                (try it if you use libpthread).
        BUILD_OPTIMIZED=yes     Enable compiler optimizations
...
=> Attempting to fetch from ftp://ftp.easynet.be/mysql/Downloads/MySQL-5.0/.
fetch: ftp://ftp.easynet.be/mysql/Downloads/MySQL-5.0/mysql-5.0.9-beta.tar.gz: File unavailable (e.g., file not found, no access)
=> Attempting to fetch from ftp://ftp.fi.muni.cz/pub/mysql/Downloads/MySQL-5.0/.
fetch: ftp://ftp.fi.muni.cz/pub/mysql/Downloads/MySQL-5.0/mysql-5.0.9-beta.tar.gz: File unavailable (e.g., file not found, no access)
=> Attempting to fetch from http://mysql.mirrors.cybercity.dk/Downloads/MySQL-5.0/.
fetch: http://mysql.mirrors.cybercity.dk/Downloads/MySQL-5.0/mysql-5.0.9-beta.tar.gz: Not Found
=> Attempting to fetch from ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-5.0/.
fetch: ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-5.0/mysql-5.0.9-beta.tar.gz: File unavailable (e.g., file not found, no access)
=> Attempting to fetch from ftp://ftp.gwdg.de/pub/misc/mysql/Downloads/MySQL-5.0/.
^Cfetch: transfer interrupted
16:43:34
#make clean
===>  Cleaning for mysql-client-5.0.9_1
===>  Cleaning for libtool-1.5.18
===>  Cleaning for mysql-server-5.0.9_1
16:43:49
#pkg_add -r mysql41-server
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6.0-release/Latest/mysql41-server.tbz... Done.
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6.0-release/All/mysql-client-4.1.13.tbz... Done.
Added group "mysql".
Added user "mysql".
16:45:04
#man mysql
16:45:23
#sockstat -4
USER     COMMAND    PID   FD PROTO  LOCAL ADDRESS         FOREIGN ADDRESS
root     sshd       3145  3  tcp4   192.168.15.22:22      192.168.15.254:45380
root     syslog-ng  2309  6  udp4   *:514                 *:*
root     syslog-ng  2309  8  udp4   192.168.15.22:59239   192.168.15.3:514
root     sshd       1844  3  tcp4   192.168.15.22:22      192.168.15.254:44058
root     sendmail   417   3  tcp4   127.0.0.1:25          *:*
root     sshd       411   4  tcp4   *:22                  *:*
16:45:29
#mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
16:45:56
#mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
16:46:10
#less /usr/local/etc/rc.d/mysql-server.sh
16:47:10
#vi /etc/rc.conf
16:47:36
#less /usr/local/etc/rc.d/mysql-server.sh
16:47:52
#/usr/local/etc/rc.d/
000.mysql-client.sh  mdnsd.sh             swatch.sh
001slpd.sh           mdnsresponder.sh     syslog-ng.sh
cups.sh.sample       mysql-server.sh      syslog-ng.sh.sample
genkdmconf.sh        snmpd.sh
kdelibs.sh           snmptrapd.sh
16:47:52
#/usr/local/etc/rc.d/mysql-server.sh start
Starting mysql.
16:48:14
#sockstat -4
USER     COMMAND    PID   FD PROTO  LOCAL ADDRESS         FOREIGN ADDRESS
mysql    mysqld     6582  3  tcp4   *:3306                *:*
root     sshd       3145  3  tcp4   192.168.15.22:22      192.168.15.254:45380
root     syslog-ng  2309  6  udp4   *:514                 *:*
root     syslog-ng  2309  8  udp4   192.168.15.22:59239   192.168.15.3:514
root     sshd       1844  3  tcp4   192.168.15.22:22      192.168.15.254:44058
root     sendmail   417   3  tcp4   127.0.0.1:25          *:*
root     sshd       411   4  tcp4   *:22                  *:*
16:48:19
#mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
16:48:31
#mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.13
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> help
For the complete MySQL Manual online, visit:
   http://www.mysql.com/documentation
For info on technical support from MySQL developers, visit:
   http://www.mysql.com/support
For info on MySQL books, utilities, consultants, etc., visit:
...
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute a SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
For server side help, type 'help contents'
mysql> exit
Bye
16:49:56
#mkfifo /var/log/mysql.pipe

16:50:49
#man mkfifo
16:53:23
#echo 21 > /tmp/pipe

/dev/ttyv2
16:53:41
$startx
cc -DHAVE_CONFIG_H -I. -I/usr/ports/devel/libol/work/libol-0.3.16/src -I. -D_GNU_SOURCE -D_XOPEN_SOURCE_EXTENDED -O2 -fno-strict-aliasing -pipe -MT xalloc.lo -MD -MP -MF .deps/xalloc.Tpo -c xalloc.c -o xalloc.o >/dev/null 2>&1
mv -f .libs/xalloc.lo xalloc.lo
if /bin/sh /usr/local/bin/libtool13 --mode=compile cc -DHAVE_CONFIG_H -I. -I/usr/ports/devel/libol/work/libol-0.3.16/src -I.    -D_GNU_SOURCE -D_XOPEN_SOURCE_EXTENDED  -O2 -fno-strict-aliasing -pipe -MT alist.lo -MD -MP -MF ".deps/alist.Tpo"  -c -o alist.lo `test -f 'alist.c' || echo '/usr/ports/devel/libol/work/libol-0.3.16/src/'`alist.c;  then mv -f ".deps/alist.Tpo" ".deps/alist.Plo";  else rm
rm -f .libs/alist.lo
cc -DHAVE_CONFIG_H -I. -I/usr/ports/devel/libol/work/libol-0.3.16/src -I. -D_GNU_SOURCE -D_XOPEN_SOURCE_EXTENDED -O2 -fno-strict-aliasing -pipe -MT alist.lo -MD -MP -MF .deps/alist.Tpo -c alist.c  -fPIC -DPIC -o .libs/alist.lo
cc -DHAVE_CONFIG_H -I. -I/usr/ports/devel/libol/work/libol-0.3.16/src -I. -D_GNU_SOURCE -D_XOPEN_SOURCE_EXTENDED -O2 -fno-strict-aliasing -pipe -MT alist.lo -MD -MP -MF .deps/alist.Tpo -c alist.c -o alist.o >/dev/null 2>&1
mv -f .libs/alist.lo alist.lo
if /bin/sh /usr/local/bin/libtool13 --mode=compile cc -DHAVE_CONFIG_H -I. -I/usr/ports/devel/libol/work/libol-0.3.16/src -I.    -D_GNU_SOURCE -D_XOPEN_SOURCE_EXTENDED  -O2 -fno-strict-aliasing -pipe -MT stream_buffer.lo -MD -MP -MF ".deps/stream_buffer.Tpo"  -c -o stream_buffer.lo `test -f 'stream_buffer.c' || echo '/usr/ports/devel/libol/work/libol-0.3.16/src/'`stream_buffer.c;  then mv -f ".deps
rm -f .libs/stream_buffer.lo
cc -DHAVE_CONFIG_H -I. -I/usr/ports/devel/libol/work/libol-0.3.16/src -I. -D_GNU_SOURCE -D_XOPEN_SOURCE_EXTENDED -O2 -fno-strict-aliasing -pipe -MT stream_buffer.lo -MD -MP -MF .deps/stream_buffer.Tpo -c stream_buffer.c  -fPIC -DPIC -o .libs/stream_buffer.lo
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 16:53:45 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
16:53:45
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 16:53:53 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
16:53:53
$sudo bash
Password:
16:54:06
#startx
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 16:54:09 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
16:54:09
#exit
exit
/dev/ttyv1
16:56:09
#xorgcfg
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
        (++) from command line, (!!) notice, (II) informational,
        (WW) warning, (EE) error, (NI) not implemented, (??) unknown.
(==) Log file: "/var/log/Xorg.8.log", Time: Mon Dec 19 16:57:28 2005
(++) Using config file: "/home/user/xorg.conf.new"
(EE) R128(0): No DFP detected
FreeFontPath: FPE "/usr/X11R6/lib/X11/fonts/misc/" refcount is 2, should be 1; fixing.
Cannot connect to X server.
/dev/ttyv2
16:57:03
$startx
xauth:  /home/user/.Xauthority not writable, changes will be ignored
xauth:  error in locking authority file /home/user/.Xauthority
xauth:  error in locking authority file /home/user/.Xauthority
xauth:  error in locking authority file /home/user/.Xauthority
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
...
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
xauth:  error in locking authority file /home/user/.Xauthority
16:57:06
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 16:58:40 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
/dev/ttyv1
16:57:34
#vi /root/xorg.conf.new
16:57:57
#vi /etc/X11/xorg.conf
16:58:32
#vi /etc/X11/xorg.conf
/dev/ttyv2
16:58:40
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 16:59:17 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
16:59:17
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 16:59:44 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
/dev/ttyv1
16:59:28
#cp /root/xorg.conf.new /etc/X11/xorg.conf

16:59:41
#xorgcfg
        compiled for 6.8.2, module version = 1.0.0
Unloading /usr/X11R6/lib/modules/drivers/apm_drv.o
Loading /usr/X11R6/lib/modules/drivers/ark_drv.o
Module ark: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 0.5.0
Unloading /usr/X11R6/lib/modules/drivers/ark_drv.o
Loading /usr/X11R6/lib/modules/drivers/ati_drv.o
Module ati: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 6.5.6
  ERROR SIGBUS caught!
...
Module via: vendor="X.Org Foundation"
        compiled for 4.3.99.902, module version = 4.1.30
Unloading /usr/X11R6/lib/modules/drivers/via_drv.o
Loading /usr/X11R6/lib/modules/drivers/vmware_drv.o
Module vmware: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 10.10.2
Module vmware already in list!
Unloading /usr/X11R6/lib/modules/drivers/vmware_drv.o
X connection to :8.0 broken (explicit kill or server shutdown).
FreeFontPath: FPE "/usr/X11R6/lib/X11/fonts/misc/" refcount is 2, should be 1; fixing.
/dev/ttyv2
16:59:44
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 17:01:43 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
/dev/ttyv1
17:00:08
#xorgconfig
First specify a mouse protocol type. Choose one from the following list:
 1.  Auto
 2.  SysMouse
 3.  MouseSystems
 4.  PS/2
 5.  Microsoft
 6.  Busmouse
 7.  AceCad
 8.  GlidePoint
 9.  IntelliMouse
10.  Logitech
11.  MMHitTab
12.  MMSeries
13.  MouseMan
14.  ThinkingMouse
The recommended protocol is Auto. If you have a very old mouse
or don't want OS support or auto detection, and you have a two-button
or three-button serial mouse, it is most likely of type Microsoft.
Enter a protocol number: ^C
17:00:19
#xorgconfig --help
This program will create a basic xorg.conf file, based on menu selections you
make.
The xorg.conf file usually resides in /usr/X11R6/etc/X11 or /etc/X11. A sample
xorg.conf file is supplied with Xorg; it is configured for a standard
VGA card and monitor with 640x480 resolution. This program will ask for a
pathname when it is ready to write the file.
You can either take the sample xorg.conf as a base and edit it for your
configuration, or let this program produce a base xorg.conf file for your
configuration and fine-tune it.
Before continuing with this program, make sure you know what video card
you have, and preferably also the chipset it uses and the amount of video
memory on your video card. SuperProbe may be able to help with this.
Press enter to continue, or ctrl-c to abort.^C
17:00:30
#xorgconfig -help
This program will create a basic xorg.conf file, based on menu selections you
make.
The xorg.conf file usually resides in /usr/X11R6/etc/X11 or /etc/X11. A sample
xorg.conf file is supplied with Xorg; it is configured for a standard
VGA card and monitor with 640x480 resolution. This program will ask for a
pathname when it is ready to write the file.
You can either take the sample xorg.conf as a base and edit it for your
configuration, or let this program produce a base xorg.conf file for your
configuration and fine-tune it.
Before continuing with this program, make sure you know what video card
you have, and preferably also the chipset it uses and the amount of video
memory on your video card. SuperProbe may be able to help with this.
Press enter to continue, or ctrl-c to abort.^C
17:00:34
#xorgcfg -help
Usage:
   xorgcfg [-option ...]
Options:
   -config <xorg.conf>   Alternate configuration file.
   -modulepath <module-path>  Xorg modules location.
   -serverpath <server-path>  X server to start (if $DISPLAY is not defined).
   -fontpath   <font-path>    Font path for fonts.
   -rgbpath    <rgb-path>     Where the rgb.txt file is located.
   -textmode                  Use this option for the text only interface.
   -nomodules                 Use this option if xorgcfg is slow to start.
   -verbose <number>          Verbosity used in the loader (default 1).
   -verify                    Verify modules/options integrity.
17:00:38
#xorgcfg -textmode
Loading /usr/X11R6/lib/modules/drivers/apm_drv.o
Module apm: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 1.0.0
Unloading /usr/X11R6/lib/modules/drivers/apm_drv.o
Loading /usr/X11R6/lib/modules/drivers/ark_drv.o
Module ark: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 0.5.0
Unloading /usr/X11R6/lib/modules/drivers/ark_drv.o
Loading /usr/X11R6/lib/modules/drivers/ati_drv.o
Module ati: vendor="X.Org Foundation"
...
Unloading /usr/X11R6/lib/modules/drivers/vga_drv.o
Loading /usr/X11R6/lib/modules/drivers/via_drv.o
Module via: vendor="X.Org Foundation"
        compiled for 4.3.99.902, module version = 4.1.30
Unloading /usr/X11R6/lib/modules/drivers/via_drv.o
Loading /usr/X11R6/lib/modules/drivers/vmware_drv.o
Module vmware: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 10.10.2
Module vmware already in list!
Unloading /usr/X11R6/lib/modules/drivers/vmware_drv.o
/dev/ttyv2
17:01:44
$startx
xauth:  error in locking authority file /home/user/.Xauthority
xauth:  error in locking authority file /home/user/.Xauthority
xauth:  error in locking authority file /home/user/.Xauthority
xauth:  error in locking authority file /home/user/.Xauthority
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
...
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
xauth:  error in locking authority file /home/user/.Xauthority
17:01:55
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 17:01:58 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
17:01:58
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 17:02:55 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
/dev/ttyv1
17:02:00
#xorgcfg -textmode
Loading /usr/X11R6/lib/modules/drivers/apm_drv.o
Module apm: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 1.0.0
Unloading /usr/X11R6/lib/modules/drivers/apm_drv.o
Loading /usr/X11R6/lib/modules/drivers/ark_drv.o
Module ark: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 0.5.0
Unloading /usr/X11R6/lib/modules/drivers/ark_drv.o
Loading /usr/X11R6/lib/modules/drivers/ati_drv.o
Module ati: vendor="X.Org Foundation"
...
Unloading /usr/X11R6/lib/modules/drivers/vga_drv.o
Loading /usr/X11R6/lib/modules/drivers/via_drv.o
Module via: vendor="X.Org Foundation"
        compiled for 4.3.99.902, module version = 4.1.30
Unloading /usr/X11R6/lib/modules/drivers/via_drv.o
Loading /usr/X11R6/lib/modules/drivers/vmware_drv.o
Module vmware: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 10.10.2
Module vmware already in list!
Unloading /usr/X11R6/lib/modules/drivers/vmware_drv.o
/dev/ttyv2
17:02:55
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 17:04:04 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
/dev/ttyv1
17:03:04
#vi /etc/X11/xorg.conf
47,48c47,48
< #	HorizSync    30.0 - 70.0
< #	VertRefresh  50.0 - 90.0
---
> 	HorizSync    30.0 - 70.0
> 	VertRefresh  50.0 - 90.0
17:03:58
#vi /etc/X11/xorg.conf
/dev/ttyv2
17:04:04
$less /var/log/Xorg.log
17:04:37
$less /var/log/Xorg.0.log
17:05:44
$!
bash: syntax error near unexpected token `newline'
17:05:45
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 17:05:48 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
17:05:48
$less /var/log/Xorg.0.log
/dev/ttyv1
17:06:10
#vi /etc/X11/xorg.conf
75c75
< 	BusID       "PCI:01:00:0"
---
> 	BusID       "PCI 01:00:0"
17:07:00
#vi /etc/X11/xorg.conf
17:07:09
#vi /etc/X11/xorg.conf
/dev/ttyv2
17:07:12
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 17:07:13 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
17:07:13
$less /var/log/Xorg.0.log
17:09:43
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
(==) Log file: "/var/log/Xorg.0.log", Time: Mon Dec 19 17:09:45 2005
(==) Using config file: "/etc/X11/xorg.conf"
(EE) No devices detected.
Fatal server error:
no screens found
Please consult the The X.Org Foundation support
         at http://wiki.X.Org
 for help.
Please also check the log file at "/var/log/Xorg.0.log" for additional information.
X connection to :0.0 broken (explicit kill or server shutdown).
17:09:45
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
KDE is unable to start.
startkde: Could not start ksmserver. Check your installation.
ERROR: Couldn't attach to DCOP server!
startkde: Shutting down...
Warning: connect() failed: : No such file or directory
Error: Can't contact kdeinit!
unix_connect: can't connect to server (unix:/tmp/mcop-user/fbsd2_linux_nt-0903-43a67ccd)
startkde: Running shutdown scripts...
startkde: Done.
waiting for X server to shut down FreeFontPath: FPE "/usr/X11R6/lib/X11/fonts/misc/" refcount is 2, should be 1; fixing.
/dev/ttyv1
17:09:54
#mv /etc/X11/xorg.conf{,.bak}

17:10:12
#xorgcfg
        compiled for 6.8.2, module version = 1.0.0
Unloading /usr/X11R6/lib/modules/drivers/apm_drv.o
Loading /usr/X11R6/lib/modules/drivers/ark_drv.o
Module ark: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 0.5.0
Unloading /usr/X11R6/lib/modules/drivers/ark_drv.o
Loading /usr/X11R6/lib/modules/drivers/ati_drv.o
Module ati: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 6.5.6
  ERROR SIGBUS caught!
...
Module via: vendor="X.Org Foundation"
        compiled for 4.3.99.902, module version = 4.1.30
Unloading /usr/X11R6/lib/modules/drivers/via_drv.o
Loading /usr/X11R6/lib/modules/drivers/vmware_drv.o
Module vmware: vendor="X.Org Foundation"
        compiled for 6.8.2, module version = 10.10.2
Module vmware already in list!
Unloading /usr/X11R6/lib/modules/drivers/vmware_drv.o
X connection to :8.0 broken (explicit kill or server shutdown).
FreeFontPath: FPE "/usr/X11R6/lib/X11/fonts/misc/" refcount is 2, should be 1; fixing.
17:10:38
#vi /etc/X11/xorg.conf
17:10:45
#less ~/xorg.conf.new
17:11:20
#mv /etc/X11/xorg.conf{.bak,}

17:11:26
#vi /etc/X11/xorg.conf
72c72
< 	Driver      "i810"
---
> 	Driver      "ati"
75c75
< 	BusID       "PCI 01:00:0"
---
> 	BusID       "PCI:01:00:0"
17:11:50
#chown -R user /home/user

/dev/ttyv2
17:13:02
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
KDE is unable to start.
startkde: Could not start ksmserver. Check your installation.
ERROR: Couldn't attach to DCOP server!
startkde: Shutting down...
Warning: connect() failed: : No such file or directory
Error: Can't contact kdeinit!
unix_connect: can't connect to server (unix:/tmp/mcop-user/fbsd2_linux_nt-0903-43a67ccd)
startkde: Running shutdown scripts...
startkde: Done.
waiting for X server to shut down FreeFontPath: FPE "/usr/X11R6/lib/X11/fonts/misc/" refcount is 2, should be 1; fixing.
17:13:32
$ls
Desktop         nohup.out       xorg.conf.new
17:13:34
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
KDE is unable to start.
startkde: Could not start ksmserver. Check your installation.
ERROR: Couldn't attach to DCOP server!
startkde: Shutting down...
Warning: connect() failed: : No such file or directory
Error: Can't contact kdeinit!
unix_connect: can't connect to server (unix:/tmp/mcop-user/fbsd2_linux_nt-0903-43a67ccd)
startkde: Running shutdown scripts...
startkde: Done.
waiting for X server to shut down FreeFontPath: FPE "/usr/X11R6/lib/X11/fonts/misc/" refcount is 2, should be 1; fixing.
17:13:59
$xinit
X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: FreeBSD 6.0 i386 [ELF]
Current Operating System: FreeBSD fbsd2.linux.nt 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov  3 09:36:13 UTC 2005     root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
Build Date: 12 October 2005
        Before reporting problems, check http://wiki.X.Org
        to make sure that you have the latest version.
Module Loader present
Markers: (--) probed, (**) from config file, (==) default setting,
...
X Error: BadWindow (invalid Window parameter) 3
  Major opcode:  6
  Minor opcode:  0
  Resource id:  0x180000b
startkde: Shutting down...
klauncher: Exiting on signal 1
DCOP Cleaning up dead connections.
startkde: Running shutdown scripts...
startkde: Done.
waiting for X server to shut down FreeFontPath: FPE "/usr/X11R6/lib/X11/fonts/misc/" refcount is 2, should be 1; fixing.
/dev/ttyv1
17:14:42
#exit
exit
/dev/ttyp5
17:15:19
$w
 5:15PM  up  3:18, 4 users, load averages: 0.10, 0.12, 0.05
USER             TTY      FROM              LOGIN@  IDLE WHAT
user             v2       -                 4:57PM     1 script -t 0 -q /home/u
root             p1       linux.nt          2:23PM    20 script -t 0 -q /root/.
root             p3       linux.nt          3:18PM    32 script -t 0 -q /root/.
user             p5       :0                5:15PM     - script -t 0 -q /home/u
17:15:59
$ps -waux
USER    PID %CPU %MEM   VSZ   RSS  TT  STAT STARTED      TIME COMMAND
root     11 92.3  0.0     0     8  ??  RL    1:57PM 195:36.91 [idle]
root   8118  0.7  6.2 58652 48196  p0  R     5:14PM   0:04.43 X :0 (Xorg)
root      0  0.0  0.0     0     0  ??  WLs   1:57PM   0:00.00 [swapper]
root      1  0.0  0.0   724   356  ??  ILs   1:57PM   0:00.02 /sbin/init --
root      2  0.0  0.0     0     8  ??  DL    1:57PM   0:00.50 [g_event]
root      3  0.0  0.0     0     8  ??  DL    1:57PM   0:01.09 [g_up]
root      4  0.0  0.0     0     8  ??  DL    1:57PM   0:01.29 [g_down]
root      5  0.0  0.0     0     8  ??  DL    1:57PM   0:00.00 [thread taskq]
root      6  0.0  0.0     0     8  ??  DL    1:57PM   0:00.00 [kqueue taskq]
...
user   8167  0.0  0.1  1304   872  p0  S     5:14PM   0:00.01 kwrapper ksmserver
root   1846  0.0  0.1  1260   820  p1  Is+   2:23PM   0:00.06 script -t 0 -q /root/.lilalo/ttyp1-1846.script
root   1882  0.0  0.3  3168  2092  p2  Is+   2:23PM   0:00.05 /usr/local/bin/bash -i
mysql  6554  0.0  0.2  1644  1264  p5- I     4:48PM   0:00.02 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysq
mysql  6582  0.0  3.5 55816 27476  p5- S     4:48PM   0:01.94 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf
user   8260  0.0  0.1  1260   820  p5  Ss+   5:15PM   0:00.08 script -t 0 -q /home/user/.lilalo/ttyp5-8260.script
root   3147  0.0  0.1  1260   820  p3  Is+   3:18PM   0:00.32 script -t 0 -q /root/.lilalo/ttyp3-3147.script
root   3183  0.0  0.3  3176  2112  p4  Is+   3:18PM   0:00.36 /usr/local/bin/bash -i
user   8292  0.0  0.3  3176  2196  p7  Ss    5:15PM   0:00.03 /usr/local/bin/bash -i
user   8324  0.0  0.1  1432   956  p7  R+    5:16PM   0:00.00 ps -waux
17:16:50
$clear

17:16:52
$pwd
/home/user
17:16:56
$sudo bash
Password:
17:17:38
#vi /usr/local/etc/syslog-ng/syslog-ng.conf
/dev/ttyp8
17:17:56
$vi /usr/local/etc/syslog-ng/syslog-ng.conf
/dev/ttyp5
17:20:34
#exit
exit
/dev/ttyp8
17:20:46
$sudo bash
exit
Password:
/dev/ttyp5
17:20:54
$cd /usr/local/share/
aclocal/                   libtool13/
applications/              libtool15/
applnk/                    locale/
apps/                      mime/
aspell/                    mimelnk/
autostart/                 misc/
bash/                      mysql/
config/                    nls/
config.kcfg/               octave/
cups/                      openldap/
...
glib-2.0/                  sounds/
gnome/                     subversion/
gnupg/                     t1lib/
guile/                     templates/
howl/                      vim/
icons/                     wallpapers/
idl/                       xgnokii/
intltool/                  xml/
jack-audio-connection-kit/ xsl/
java/
17:20:54
$cd /usr/local/share/phpsyslogng/phpsyslogng-2.6/
CHANGELOG  README     css/       index.php
LICENSE    config/    includes/  scripts/
17:20:54
$cd /usr/local/share/phpsyslogng/phpsyslogng-2.6/

/dev/ttyp8
17:21:01
#clear

17:21:03
#vi /usr/local/etc/syslog-ng/syslog-ng.conf
17:22:07
#mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.13
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql>
mysql>
mysql>
mysql>
mysql> CREATE DATABASE syslog;
...
    -> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql>
mysql>
mysql>
mysql> CREATE TABLE logs (
    -> host varchar(32) default NULL,
    -> facility varchar(10) default NULL,
    -> priority varchar(10) default NULL,
    -> Aborted
17:26:12
#mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.1.13
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> use syslog
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> help
...
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute a SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
For server side help, type 'help contents'
mysql> select * from syslog
    -> Aborted

Файлы

  • distinfo
  • pkg-descr
  • distinfo
    >
    MD5 (mysql-5.0.9-beta.tar.gz) = 8899d591d549d1d8ca61f5741bff490c
    SIZE (mysql-5.0.9-beta.tar.gz) = 18615183
    
    pkg-descr
    >
    MySQL is a very fast, multi-threaded, multi-user and robust SQL
    (Structured Query Language) database server.
    WWW: http://www.mysql.com/
    - Alex Dupre
    ale@FreeBSD.org
    

    Статистика

    Время первой команды журнала16:39:19 2006-12-19
    Время последней команды журнала17:26:12 2006-12-19
    Количество командных строк в журнале101
    Процент команд с ненулевым кодом завершения, %23.76
    Процент синтаксически неверно набранных команд, % 0.00
    Суммарное время работы с терминалом *, час 0.78
    Количество командных строк в единицу времени, команда/мин 2.15
    Частота использования команд
    xinit15|==============| 14.15%
    vi14|=============| 13.21%
    cd10|=========| 9.43%
    less8|=======| 7.55%
    xorgcfg6|=====| 5.66%
    mysql6|=====| 5.66%
    make6|=====| 5.66%
    startx4|===| 3.77%
    sudo3|==| 2.83%
    xorgconfig3|==| 2.83%
    bash3|==| 2.83%
    ls3|==| 2.83%
    exit3|==| 2.83%
    sockstat2|=| 1.89%
    man2|=| 1.89%
    cat2|=| 1.89%
    mv2|=| 1.89%
    clear2|=| 1.89%
    ps1|| 0.94%
    pwd1|| 0.94%
    chown1|| 0.94%
    cp1|| 0.94%
    !1|| 0.94%
    mkfifo1|| 0.94%
    echo1|| 0.94%
    /usr/local/etc/rc.d/mysql-server.sh1|| 0.94%
    pkg_add1|| 0.94%
    pipe1|| 0.94%
    /usr/local/etc/rc.d/1|| 0.94%
    w1|| 0.94%
    ____
    *) Интервалы неактивности длительностью 30 минут и более не учитываются

    Справка

    Для того чтобы использовать LiLaLo, не нужно знать ничего особенного: всё происходит само собой. Однако, чтобы ведение и последующее использование журналов было как можно более эффективным, желательно иметь в виду следующее:
    1. В журнал автоматически попадают все команды, данные в любом терминале системы.

    2. Для того чтобы убедиться, что журнал на текущем терминале ведётся, и команды записываются, дайте команду w. В поле WHAT, соответствующем текущему терминалу, должна быть указана программа script.

    3. Команды, при наборе которых были допущены синтаксические ошибки, выводятся перечёркнутым текстом:
      $ l s-l
      bash: l: command not found
      

    4. Если код завершения команды равен нулю, команда была выполнена без ошибок. Команды, код завершения которых отличен от нуля, выделяются цветом.
      $ test 5 -lt 4
      Обратите внимание на то, что код завершения команды может быть отличен от нуля не только в тех случаях, когда команда была выполнена с ошибкой. Многие команды используют код завершения, например, для того чтобы показать результаты проверки

    5. Команды, ход выполнения которых был прерван пользователем, выделяются цветом.
      $ find / -name abc
      find: /home/devi-orig/.gnome2: Keine Berechtigung
      find: /home/devi-orig/.gnome2_private: Keine Berechtigung
      find: /home/devi-orig/.nautilus/metafiles: Keine Berechtigung
      find: /home/devi-orig/.metacity: Keine Berechtigung
      find: /home/devi-orig/.inkscape: Keine Berechtigung
      ^C
      

    6. Команды, выполненные с привилегиями суперпользователя, выделяются слева красной чертой.
      # id
      uid=0(root) gid=0(root) Gruppen=0(root)
      

    7. Изменения, внесённые в текстовый файл с помощью редактора, запоминаются и показываются в журнале в формате ed. Строки, начинающиеся символом "<", удалены, а строки, начинающиеся символом ">" -- добавлены.
      $ vi ~/.bashrc
      2a3,5
      >    if [ -f /usr/local/etc/bash_completion ]; then
      >         . /usr/local/etc/bash_completion
      >        fi
      

    8. Для того чтобы изменить файл в соответствии с показанными в диффшоте изменениями, можно воспользоваться командой patch. Нужно скопировать изменения, запустить программу patch, указав в качестве её аргумента файл, к которому применяются изменения, и всавить скопированный текст:
      $ patch ~/.bashrc
      В данном случае изменения применяются к файлу ~/.bashrc

    9. Для того чтобы получить краткую справочную информацию о команде, нужно подвести к ней мышь. Во всплывающей подсказке появится краткое описание команды.

      Если справочная информация о команде есть, команда выделяется голубым фоном, например: vi. Если справочная информация отсутствует, команда выделяется розовым фоном, например: notepad.exe. Справочная информация может отсутствовать в том случае, если (1) команда введена неверно; (2) если распознавание команды LiLaLo выполнено неверно; (3) если информация о команде неизвестна LiLaLo. Последнее возможно для редких команд.

    10. Большие, в особенности многострочные, всплывающие подсказки лучше всего показываются браузерами KDE Konqueror, Apple Safari и Microsoft Internet Explorer. В браузерах Mozilla и Firefox они отображаются не полностью, а вместо перевода строки выводится специальный символ.

    11. Время ввода команды, показанное в журнале, соответствует времени начала ввода командной строки, которое равно тому моменту, когда на терминале появилось приглашение интерпретатора

    12. Имя терминала, на котором была введена команда, показано в специальном блоке. Этот блок показывается только в том случае, если терминал текущей команды отличается от терминала предыдущей.

    13. Вывод не интересующих вас в настоящий момент элементов журнала, таких как время, имя терминала и других, можно отключить. Для этого нужно воспользоваться формой управления журналом вверху страницы.

    14. Небольшие комментарии к командам можно вставлять прямо из командной строки. Комментарий вводится прямо в командную строку, после символов #^ или #v. Символы ^ и v показывают направление выбора команды, к которой относится комментарий: ^ - к предыдущей, v - к следующей. Например, если в командной строке было введено:

      $ whoami
      
      user
      
      $ #^ Интересно, кто я?
      
      в журнале это будет выглядеть так:
      $ whoami
      
      user
      
      Интересно, кто я?

    15. Если комментарий содержит несколько строк, его можно вставить в журнал следующим образом:

      $ whoami
      
      user
      
      $ cat > /dev/null #^ Интересно, кто я?
      
      Программа whoami выводит имя пользователя, под которым 
      мы зарегистрировались в системе.
      -
      Она не может ответить на вопрос о нашем назначении 
      в этом мире.
      
      В журнале это будет выглядеть так:
      $ whoami
      user
      
      Интересно, кто я?
      Программа whoami выводит имя пользователя, под которым
      мы зарегистрировались в системе.

      Она не может ответить на вопрос о нашем назначении
      в этом мире.
      Для разделения нескольких абзацев между собой используйте символ "-", один в строке.

    16. Комментарии, не относящиеся непосредственно ни к какой из команд, добавляются точно таким же способом, только вместо симолов #^ или #v нужно использовать символы #=

    17. Содержимое файла может быть показано в журнале. Для этого его нужно вывести с помощью программы cat. Если вывод команды отметить симоволами #!, содержимое файла будет показано в журнале в специально отведённой для этого секции.
    18. Для того чтобы вставить скриншот интересующего вас окна в журнал, нужно воспользоваться командой l3shot. После того как команда вызвана, нужно с помощью мыши выбрать окно, которое должно быть в журнале.
    19. Команды в журнале расположены в хронологическом порядке. Если две команды давались одна за другой, но на разных терминалах, в журнале они будут рядом, даже если они не имеют друг к другу никакого отношения.
      1
          2
      3   
          4
      
      Группы команд, выполненных на разных терминалах, разделяются специальной линией. Под этой линией в правом углу показано имя терминала, на котором выполнялись команды. Для того чтобы посмотреть команды только одного сенса, нужно щёкнуть по этому названию.

    О программе

    LiLaLo (L3) расшифровывается как Live Lab Log.
    Программа разработана для повышения эффективности обучения Unix/Linux-системам.
    (c) Игорь Чубин, 2004-2008

    $Id$