vicidial.org

Hi

I have a probleme

I have goautodial 3.0
Kernel Version 2.6.18-371.6.1.el5 (SMP)
Distro Name CentOS release 5.10.1 (Final)


All is ok but today when i want to search for a lead i dont find the link of recording in RECORDINGS FOR THIS LEAD:, i dont find any thing in this case

When i use a server/recordings/mp3 it s ok but find one recording need hours

Why RECORDINGS FOR THIS LEAD: is empty , yesterday is ok today is empty

i find this message Table './asterisk/recording_log' is marked as crashed and should be repaired

Thanks

and i forget msyql password

what i must do

when i want to have a ,new pâss i receive this

[root@ns204886 ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ns204886 ~]# /etc/init.d/mysql stop -bash: /etc/init.d/mysql: No such file or directory

If you forget msyql password ???
try this.....

Step # 1 : Stop mysql service
# /etc/init.d/mysql stop

Output:
Stopping MySQL database server: mysqld.

Step # 2: Start to MySQL server w/o password:
# mysqld_safe --skip-grant-tables &

Output:

[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started

Step # 3: Connect to mysql server using mysql client:
# mysql -u root

Output:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

Step # 4: Setup new MySQL root user password

mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

Step # 5: Stop MySQL Server:

# /etc/init.d/mysql stop

Output:
Stopping MySQL database server: mysqld
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[6186]: ended
[1]+ Done mysqld_safe --skip-grant-tables


Step # 6: Start MySQL server and test it

# /etc/init.d/mysql start
# mysql -u root -p

Enjoy.!!!!!!!!!!!