-
[root@freepbx ~]# cat /etc/asterisk/cdr_mysql.conf
;
; Note - if the database server is hosted on the same machine as the
; asterisk server, you can achieve a local Unix socket connection by
; setting hostname = localhost
;
; port and sock are both optional parameters. If hostname is specified
; and is not “localhost”, then cdr_mysql will attempt to connect to the
; port specified or use the default port. If hostname is not specified
; or if hostname is “localhost”, then cdr_mysql will attempt to connect
; to the socket file specified by sock or otherwise use the default socket
; file.
;
[global]
hostname = localhost
dbname=asteriskcdrdb
password =
user = freepbxuser
userfield=1
;port=3306
;sock=/tmp/mysql.sock
2.(i tired many times, with different password, but non of them worked)
[root@freepbx ~]# mysqldump asteriskcdrdb --compact --no-data -u root -p
Enter password:
mysqldump: Got error: 1045: Access denied for user ‘root’@‘localhost’ (using password: YES) when trying to connect
-
[root@freepbx ~]# cat /etc/init.d/mysqld status
#!/bin/bash
mysqld This shell script takes care of starting and stopping
the MySQL subsystem (mysqld).
chkconfig: - 64 36
description: MySQL database server.
processname: mysqld
config: /etc/my.cnf
pidfile: /var/run/mysqld/mysqld.pid
Source function library.
. /etc/rc.d/init.d/functions
Source networking configuration.
. /etc/sysconfig/network
prog=“MySQL”
extract value of a MySQL option from config files
Usage: get_mysql_option SECTION VARNAME DEFAULT
result is returned in $result
We use my_print_defaults which prints all options from multiple files,
with the more specific ones later; hence take the last match.
get_mysql_option(){
result=/usr/bin/my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1
if [ -z “$result” ]; then
# not found, use default
result="$3"
fi
}
get_mysql_option mysqld datadir “/var/lib/mysql"
datadir=”$result"
get_mysql_option mysqld socket “$datadir/mysql.sock"
socketfile=”$result"
get_mysql_option mysqld_safe log-error “/var/log/mysqld.log"
errlogfile=”$result"
get_mysql_option mysqld_safe pid-file “/var/run/mysqld/mysqld.pid"
mypidfile=”$result"
start(){
touch “$errlogfile"
chown mysql:mysql “$errlogfile"
chmod 0640 “$errlogfile”
[ -x /sbin/restorecon ] && /sbin/restorecon “$errlogfile"
if [ ! -d “$datadir/mysql” ] ; then
action $“Initializing MySQL database: " /usr/bin/mysql_install_db --datadir=”$datadir” --user=mysql
ret=$?
chown -R mysql:mysql “$datadir"
if [ $ret -ne 0 ] ; then
return $ret
fi
fi
chown mysql:mysql “$datadir"
chmod 0755 “$datadir”
# Pass all the options determined above, to ensure consistent behavior.
# In many cases mysqld_safe would arrive at the same conclusions anyway
# but we need to be sure.
/usr/bin/mysqld_safe --datadir=”$datadir” --socket=”$socketfile”
–log-error="$errlogfile" --pid-file="$mypidfile"
–user=mysql >/dev/null 2>&1 &
ret=$?
# Spin for a maximum of N seconds waiting for the server to come up.
# Rather than assuming we know a valid username, accept an “access
# denied” response as meaning the server is functioning.
if [ $ret -eq 0 ]; then
STARTTIMEOUT=30
while [ $STARTTIMEOUT -gt 0 ]; do
RESPONSE=/usr/bin/mysqladmin --socket="$socketfile" --user=UNKNOWN_MYSQL_USER ping 2>&1
&& break
echo “$RESPONSE” | grep -q “Access denied for user” && break
sleep 1
let STARTTIMEOUT=${STARTTIMEOUT}-1
done
if [ $STARTTIMEOUT -eq 0 ]; then
echo "Timeout error occurred trying to start MySQL Daemon."
action $"Starting $prog: " /bin/false
ret=1
else
action $"Starting $prog: " /bin/true
fi
else
action $"Starting $prog: " /bin/false
fi
[ $ret -eq 0 ] && touch /var/lock/subsys/mysqld
return $ret
}
stop(){
MYSQLPID=cat "$mypidfile" 2>/dev/null
if [ -n “$MYSQLPID” ]; then
/bin/kill “$MYSQLPID” >/dev/null 2>&1
ret=$?
if [ $ret -eq 0 ]; then
STOPTIMEOUT=60
while [ $STOPTIMEOUT -gt 0 ]; do
/bin/kill -0 “$MYSQLPID” >/dev/null 2>&1 || break
sleep 1
let STOPTIMEOUT=${STOPTIMEOUT}-1
done
if [ $STOPTIMEOUT -eq 0 ]; then
echo "Timeout error occurred trying to stop MySQL Daemon."
ret=1
action $"Stopping $prog: " /bin/false
else
rm -f /var/lock/subsys/mysqld
rm -f "$socketfile"
action $"Stopping $prog: " /bin/true
fi
else
action $"Stopping $prog: " /bin/false
fi
else
ret=1
action $"Stopping $prog: " /bin/false
fi
return $ret
}
restart(){
stop
start
}
condrestart(){
[ -e /var/lock/subsys/mysqld ] && restart || :
}
See how we were called.
case “$1” in
start)
start
;;
stop)
stop
;;
status)
status mysqld
;;
restart)
restart
;;
condrestart)
condrestart
;;
*)
echo $"Usage: $0 {start|stop|status|condrestart|restart}"
exit 1
esac
exit $?
let me know if you need more information.
Really thank you so much for your kind help.
THANKS