Hi,
Okay, ill remove the extra log then.
The problem isnt that the socket doesn't get created, its that it randomly
disappears when mysql has been running for weeks already. So, /tmp's
permissions are correct, and everything works for a undecided amount of
time, then it just disappears and mysql stops working.
Thanks
Ian
On Fri, Feb 29, 2008 at 5:46 PM, Vidal Garza <[EMAIL PROTECTED]> wrote:
> Ian escribió:
> > 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]
> >>
> >>
> >>
> >
> >
> Its the same.
> chek the permissions on /tmp (i know its improbably but who knows)
>
> when you run from the prompt its create the socket?
> and when you run with mysql user its create the socket?
>
> --
> ====================================================
> 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
>
>
