入口
benchmarks
  bonnie
    results
  bytebench
comms
  mgetty
    /etc/mail/aliases
  mgetty+sendfax
    pppd サーバを作る mgetty
    設定の概要
    /etc/tty00 --モデム
    /etc/ttys
    mgetty.config, login.config
    まずは login して見る
    /etc/ppp/options
    /etc/ppp/pap-secrets
    確認方法
cross
  i386-mingw32
  ming-w64
    二つの不思議
databases
  mysql-server
    mysql_install_db
    rc.d/mysqld
    mysql_secure_installation
    20050605
      pkg_add
      (err)
      grant
    help
    error
      mysqlcheck
      reset password
      backup
    reset password
    create db
    create user
    grant
    ProFTPD+mysql
    操作
  postgres
  rrdtool
devel
  cvsync
    cvsync.conf
    ソースの取出
    問題
      desired version
  distcc
    url
    distcc って何
    用意するもの
    distccmon-text
    pkg_add
  doxygen
    Doxyfile
    出力を利用する
    1.4.5
    2007/04
  doxygen/gcc
    doxy 1.4.5
  mercurial
  git
font
  設定方法
    mkfontdir
    fontpath
  確認方法
    fontpath
    全ての書体
  intlfonts
    fontpath
  ipa
graphics
  graphviz
  magicpoint
  tgif
    print error
    work around
ham
  hamlog
inputmethod
  anthy
    kinput2
mail
  cyrus-imapd
    url
    説明
    pkg_info -D
    bin/master
    /etc/rc.d/
    認証
    cyrus-saslauthd
    メール box の管理
    着信(MTA)
    問題
    古い cyrus
    sieve
      設定
      .sieve
      操作
      検査
      有効にするには
      問題
        saslauthd
        passwd is asked
  fml
  sendmail
  milter-regex
  smtpfeed
    smtpfeed.mc
    ./Build
    test
    起動準備
  spamassassin
    pkg_add
    sa-learn
    local.cf
  spamass-milter
    メール見出
    設定
    問題
    tuning
  squirrelmail
    url
    設置と設定
    pkg_info -D
    apache
    開始画面例
    文字符号
    課題
    問題
  ja-squirrelmail
    url
    設置と設定
    pkg_info -D
    開始画面例
    文字符号
    課題
    問題
  ctorrent
  urjtag
misc
  ttyrec
multimedia
  mplayer
  gmplayer
  libdvdcss
  xine-ui
net
  bind9
    設定確認
    起動
    必要な機能の分類
    chroot 環境
  TCP/IP と AppleTalk
  netatalk
    AppleTalk と TCP/IP
    版と構成部品
    pkg_info -D
    afpd
    一時的に起動
    認証
    動作確認
    誤り
  mrtg
  net-snmp
    設定
    起動
    log
    mrtg
    snmpget
    snmpwalk
    man pages
    参考
  rsync
  samba
    版
    設定
      smb.conf
      /etc/rc.d
    起動
    add user
    debug
    problem
news
  inn
pkgtools
  pkg_chk
print
  mf
    pktogf + gftodvi
  bibtex
    ごみ
  xpdf
  ja-ptex-bin
    jpbibtex
  ja-ptex
    dvipdfmx
    その他
  pdvipdfmx
personal
  fml
    設定作業の流れ
    pkg_info -D
    fml-system
    ml を作る
      newml
    /etc/mail/aliases
    Generic From
    sendmail.cf
    最初の会員
    自動で送られるメール
    MHonArc
    majordomo
    覚え
      password の設定
      members-admin
      log
      cf を変更した時には
      自動登録
      メールで管理するには
      admin add で welcome
      asymmetric mode って
      debug
      問題
      package 問題
  id-utils
security
  cyrus-sasl
  cy2-crammd5
  openssh
sysutils
  dd_rescue
  mklivecd
      config
  memtester
textproc
  hyperestraier
    更新
    異常停止
wip
  emacs-current
    X11
wip-jp
wm
  fvwm2
www
  apache
    rc.d
    httpd.conf
    start
    mkcert
    startssl
  ap2-auth-pgsql
  cvsweb
    pkgsrc
  firefox
    Fonts
    言語毎設定
    Firmacs
  php4
    mb_string
      Wordpress
    php.ini
  w3m
X11
  qt2
wip
  u-boot

Software 入口 | Hardware | NetBSD 解説 | packages | macppc | TsubaiBSD 絹/software/全文検索

This is under: http://www.ki.nu/software/pkgsrc/

NetBSD/pkgsrc

Last Update: "2010/02/28 13:21:46 makoto"

20050605

ttyp0:makoto@umax  10:51:01/050605(~)> sudo env mysqld=YES /etc/rc.d/mysqld start
Password:
Starting mysqld.
eval: /usr/pkg/bin/mysqld_safe: not found
実は mysql が入っていなかった。
  1. pkg_add mysql-server
  2. $ echo "mysqld=yes" >> /etc/rc.conf # NetBSD or a system with rc.d
  3. sudo cp -p /usr/pkg/share/examples/rc.d/*mysql* /etc/rc.d/
  4. sudo env mysqld=YES /etc/rc.d/mysqld start
pkg_add
ttyp0:makoto@umax  10:55:25/050605(...3.99.3/All)> sudo pkg_add mysql-server

===========================================================================
$NetBSD: MESSAGE,v 1.1 2004/12/02 00:42:06 xtraeme Exp $

To use the ``mysqlhotcopy'' script, you'll have to install the following
packages:

        devel/p5-File-Temp
        databases/p5-DBD-mysql

===========================================================================

Creating group: mysql
Creating user: mysql

===========================================================================
$NetBSD: MESSAGE,v 1.6 2005/03/08 16:48:11 xtraeme Exp $

You can start the MySQL server doing the following steps:

$ echo "mysqld=yes" >> /etc/rc.conf # NetBSD or a system with rc.d

If you are using PKG_RCD_SCRIPTS=YES, try the following:

$ /etc/rc.d/mysqld start

Otherwise try:

$ /usr/pkg/share/examples/rc.d/mysqld start

After the tables are set up and the MySQL server is running,
please remember to set a password for the MySQL root user!
This is done by running both:

  /usr/pkg/bin/mysqladmin -u root -p password 'new-password'
  /usr/pkg/bin/mysqladmin -h `hostname` -u root -p password 'new-password'

The "Enter password:" prompt is asking for the existing password.
As there is no existing password, just press the Return key.

There is a script distributed with MySQL that can help you lock down
an installation.  This script has been installed to

  /usr/pkg/bin/mysql_secure_installation.

Please see the manual and the MySQL web site for more instructions.

===========================================================================

ttyp0:makoto@umax  10:57:19/050605(...3.99.3/All)> his
ttyp0:makoto@umax  11:04:16/050605(...3.99.3/All)>  /usr/pkg/bin/mysqladmin -u root -p password 'new-passwd'
Enter password: 
/usr/pkg/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
ttyp0:makoto@umax  11:04:51/050605(...3.99.3/All)> ls /tmp/my*
/tmp/mysql.sock=
(err)
起動したはずなのに、起動していない場合には、次のところに何か書いてあります。
 /var/mysql/hostname.err
例えば、このような内容です
050805 11:08:10  Starting mysqld daemon with databases from /var/mysql
050805 11:08:10  mysqld started
050605 11:08:10  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
050805 11:08:10  STOPPING server from pid file /var/mysql/umax.pid
050805 11:08:10  mysqld ended
何故か user が変ってしまっているので
ttyp0:makoto@umax 11:11:31/050605(...3.99.3/All)> ls -l /var/mysql/ total 41066 -rw-rw---- 1 tinyproxy tinyproxy 25088 Apr 19 14:09 ib_arch_log_0000000000 -rw-rw---- 1 tinyproxy tinyproxy 5242880 Apr 19 14:09 ib_logfile0 -rw-rw---- 1 tinyproxy tinyproxy 5242880 Apr 19 14:09 ib_logfile1 -rw-rw---- 1 tinyproxy tinyproxy 10485760 Apr 19 14:09 ibdata1 drwx------ 2 tinyproxy tinyproxy 512 Apr 19 14:07 mysql/ -rw-rw---- 1 mysql tinyproxy 2628 Jun 5 11:08 umax.err ttyp0:makoto@umax 11:11:33/050605(...3.99.3/All)
もう一度設置時に必要なことを実行
   141  11:12   sudo chown -R mysql:mysql /var/mysql
   142  11:12   sudo /usr/pkg/bin/mysql_install_db --user=mysql
ps ax で見ると、今度は動いています
ttyp0:makoto@umax 11:14:20/050605(...3.99.3/All)> ps ax | grep sql 1251 ttyp0 Sa 0:00.79 /usr/pkg/libexec/mysqld --basedir=/usr/pkg --datadir=/var/mysql --user=mysql --pid-file=/var/mysql/umax.pid 18532 ttyp0 S 0:00.04 /bin/sh /usr/pkg/bin/mysqld_safe --user=mysql --datadir=/var/mysql --pid-file=/var/mysql/umax.pid 24203 ttyp0 R+ 0:00.01 grep sql
しかし:
ttyp0:makoto@umax 11:14:45/050605(~)> /usr/pkg/bin/mysqladmin -h `hostname` -u root -p password 'new-password' Enter password: /usr/pkg/bin/mysqladmin: connect to server at 'umax' failed error: 'Host 'umax' is not allowed to connect to this MySQL server'
次のようにする。Enter password: には上で設定した root のパスワードを入れる
ttyp0:makoto@umax 11:41:13/050605(...3.99.3/All)> mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 4.1.11 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> delete from mysql.user where host; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql>
grant
http://www.dream-seed.com/linux/mysql.html
ttyp0:makoto@umax 11:47:05/050605(...3.99.3/All)> mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 to server version: 4.1.11 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant all on your_hostname.* to your_login@localhost identified by 'hogehoge'; Query OK, 0 rows affected (0.02 sec) mysql>
NetBSD解説/pkgsrc
Last Update: Mon, 08 Feb 2016 22:22:20 GMT 1.66 2008/03/08