Hi,
Okay, I have added that and will wait and see when it happens again if there
is anything in that log. Just out of interest, does that log show anything
different to the /var/db/mysql/hostnameofunit.err file ?
Cheers
Ian
On Thu, Feb 28, 2008 at 8:44 PM, Vidal Garza <[EMAIL PROTECTED]> wrote:
> Its for test.
> put the log file on my.cnf and tellus what going on
>
> my.cnf
> ...
> log-error=/var/db/mysql/Server_Error.log
>
>
> Ian escribió:
> > Hi,
> >
> > We use the following sh script to start (its the default one when
> installed)
> >
> > cat /usr/local/etc/rc.d/mysql-server.sh
> > #!/bin/sh
> > #
> > # $FreeBSD: ports/databases/mysql50-server/files/mysql-server.sh.in,v
> > 1.32006/03/07 16:25:00 ale Exp $
> > #
> >
> > # PROVIDE: mysql
> > # REQUIRE: LOGIN
> > # KEYWORD: shutdown
> >
> > #
> > # Add the following line to /etc/rc.conf to enable mysql:
> > # mysql_enable (bool): Set to "NO" by default.
> > # Set it to "YES" to enable MySQL.
> > # mysql_limits (bool): Set to "NO" by default.
> > # Set it to yes to run `limits -e -U mysql`
> > # just before mysql starts.
> > # mysql_dbdir (str): Default to "/var/db/mysql"
> > # Base database directory.
> > # mysql_args (str): Custom additional arguments to be passed
> > # to mysqld_safe (default empty).
> > #
> >
> > . /etc/rc.subr
> >
> > name="mysql"
> > rcvar=`set_rcvar`
> >
> > load_rc_config $name
> >
> > : ${mysql_enable="NO"}
> > : ${mysql_limits="NO"}
> > : ${mysql_dbdir="/var/db/mysql"}
> > : ${mysql_args=""}
> >
> > mysql_user="mysql"
> > mysql_limits_args="-e -U ${mysql_user}"
> > pidfile="${mysql_dbdir}/`/bin/hostname`.pid"
> > command="/usr/local/bin/mysqld_safe"
> > command_args="--defaults-extra-file=${mysql_dbdir}/my.cnf
> > --user=${mysql_user} --datadir=${mysql_dbdir} --pid-file=${pidfile}
> > ${mysql_args} > /dev/null &"
> > procname="/usr/local/libexec/mysqld"
> > start_precmd="${name}_prestart"
> > mysql_install_db="/usr/local/bin/mysql_install_db"
> > mysql_install_db_args="--ldata=${mysql_dbdir}"
> >
> > mysql_create_auth_tables()
> > {
> > eval $mysql_install_db $mysql_install_db_args >/dev/null
> > [ $? -eq 0 ] && chown -R ${mysql_user}:${mysql_user}
> ${mysql_dbdir}
> > }
> >
> > mysql_prestart()
> > {
> > if [ ! -d "${mysql_dbdir}/mysql/." ]; then
> > mysql_create_auth_tables || return 1
> > fi
> > if checkyesno mysql_limits; then
> > eval `/usr/bin/limits ${mysql_limits_args}` 2>/dev/null
> > else
> > return 0
> > fi
> > }
> >
> > run_rc_command "$1"
> >
> > In rc.conf we have:
> > mysql_enable="YES"
> > mysql_args="--myisam-recover=BACKUP,FORCE"
> >
> > Here is the ps of it running:
> > # ps -axwww |grep mysql
> > 62025 p0 R+ 0:00.00 grep mysql
> > 78519 p0- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe
> > --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
> > --datadir=/var/db/mysql --pid-file=/var/db/mysql/hostname.pid
> > --myisam-recover=BACKUP,FORCE
> > 78548 p0- S 180:27.77 /usr/local/libexec/mysqld
> > --defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local
> > --datadir=/var/db/mysql --user=mysql
> --pid-file=/var/db/mysql/hostname.pid
> > --port=3306 --socket=/tmp/mysql.sock --myisam-recover=BACKUP,FORCE
> >
> > We could try that, but why would it behave differently to the current sh
> > script?
> >
> > Thanks
> > Ian
> >
> > On Thu, Feb 28, 2008 at 7:43 PM, Vidal Garza <[EMAIL PROTECTED]> wrote:
> >
> >
> >> how do you start up?
> >> you can start up from scrip.
> >>
> >> #!/bin/sh
> >> id="02"
> >> ip="192.168.0.42"
> >>
> >> sockfile="/tmp/mysql$id.sock"
> >> user="mysql"
> >> datdir="/var/db/mysql$id"
> >> port="3306"
> >> /bin/sh /usr/local/bin/mysqld_safe --user=$user --datadir=$datdir
> >> --bind-address=$ip --port=$port --sock=$sockfile &
> >>
> >>
> >>
> >> Ian escribió:
> >>
> >>> Hi,
> >>>
> >>> I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason
> >>> /tmp/mysql.sock keeps on disappearing and we are forced to kill -9
> mysql
> >>>
> >> and
> >>
> >>> restart it causing db corruptions as there is no other way of telling
> it
> >>>
> >> to
> >>
> >>> stop once that file has gone. I have tried to find any reason why this
> >>> happens and there are no errors, no core files, nothing - the file
> just
> >>> disappears.
> >>>
> >>> Here is the error when trying to login:
> >>>
> >>> # mysql -p cache
> >>> Enter password:
> >>>
> >>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> >>> '/tmp/mysql.sock' (61)
> >>>
> >>> Here is my my.cnf file:
> >>> [client]
> >>> port = 3306
> >>> socket = /tmp/mysql.sock
> >>>
> >>> [mysqld]
> >>> port = 3306
> >>> socket = /tmp/mysql.sock
> >>> skip-locking
> >>> key_buffer = 16M
> >>> max_allowed_packet = 1M
> >>> table_cache = 64
> >>> sort_buffer_size = 512K
> >>> net_buffer_length = 8K
> >>> read_buffer_size = 256K
> >>> read_rnd_buffer_size = 512K
> >>> myisam_sort_buffer_size = 8M
> >>> #log-bin
> >>>
> >>> server-id = 1
> >>>
> >>> # Uncomment the following if you are using BDB tables
> >>> #bdb_cache_size = 4M
> >>> #bdb_max_lock = 10000
> >>>
> >>> # Uncomment the following if you are using InnoDB tables
> >>> #innodb_data_home_dir = /var/db/mysql/
> >>> #innodb_data_file_path = ibdata1:10M:autoextend
> >>> #innodb_log_group_home_dir = /var/db/mysql/
> >>> #innodb_log_arch_dir = /var/db/mysql/
> >>> # You can set .._buffer_pool_size up to 50 - 80 %
> >>> # of RAM but beware of setting memory usage too high
> >>> #innodb_buffer_pool_size = 16M
> >>> #innodb_additional_mem_pool_size = 2M
> >>> # Set .._log_file_size to 25 % of buffer pool size
> >>> #innodb_log_file_size = 5M
> >>> #innodb_log_buffer_size = 8M
> >>> #innodb_flush_log_at_trx_commit = 1
> >>> #innodb_lock_wait_timeout = 50
> >>>
> >>> [mysqldump]
> >>> quick
> >>> max_allowed_packet = 16M
> >>>
> >>> [mysql]
> >>> no-auto-rehash
> >>>
> >>> [isamchk]
> >>> key_buffer = 20M
> >>> sort_buffer_size = 20M
> >>> read_buffer = 2M
> >>> write_buffer = 2M
> >>>
> >>> [myisamchk]
> >>> key_buffer = 20M
> >>> sort_buffer_size = 20M
> >>> read_buffer = 2M
> >>> write_buffer = 2M
> >>>
> >>> [mysqlhotcopy]
> >>> interactive-timeout
> >>>
> >>> The machine in question is a dual xeon with 4gig of ram.
> >>>
> >>> Any ideas?
> >>>
> >>> Thanks in advance,
> >>> Ian
> >>>
> >>>
> >>>
> >> --
> >> ====================================================
> >> Ing. Vidal Garza Tirado
> >> Depto. Sistemas
> >> Aduanet S.A. de C.V.
> >> Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
> >> Ave. César López de Lara No. 3603 Int. B Col Jardín.
> >> Nuevo Laredo, Tamaulipas, México.
> >>
> >>
> >>
> >> --
> >> Este mensaje ha sido analizado por MailScanner
> >> en busca de virus y otros contenidos peligrosos,
> >> y se considera que está limpio.
> >> For all your IT requirements visit: http://www.aduanet.net
> >>
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> >> http://lists.mysql.com/[EMAIL PROTECTED]
> >>
> >>
> >>
> >
> >
>
>
> --
> ====================================================
> Ing. Vidal Garza Tirado
> Depto. Sistemas
> Aduanet S.A. de C.V.
> Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
> Ave. César López de Lara No. 3603 Int. B Col Jardín.
> Nuevo Laredo, Tamaulipas, México.
>
>
>
> --
> Este mensaje ha sido analizado por MailScanner
> en busca de virus y otros contenidos peligrosos,
> y se considera que está limpio.
> For all your IT requirements visit: http://www.aduanet.net
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
