Linux Distribution: (Redhat CentOS release 5.5 (Final))
FreePBX version: (2.7.0)
Hello,
I was attempting to install Cacti yesterday, and it appears I may have done something that has broken my monitoring of recorded calls. The calls are still being recorded to /var/spool/asterisk/monitor but are not being listed in the monitor tab any more. I can still see the recordings from previous to today. I am able to listen to new recordings manually by browsing to the directory.
This has me confused. If it was a rights issue, then I wouldn’t be able to see any of the previous days calls. If it was a failure to record issue, I wouldn’t be able to hear calls made today in the directory. I’m hoping someone on here has some ideas on what may be wrong.
If I do CLI> CDR mysql status I get:
Connected to asteriskcdrdb on socket file default using table cdr for 1 hours, 21 minutes, 32 seconds.
Wrote 26 records since last restart.
If you changed your mysql ( for the asteriskcdr database)password from what it was at the original install of asterisk/freepbx you need to edit your amportal.conf file to coincide with the new mysql/asteriskcdr database password
This explains why your symlinks in voicemail are not happening as well.
Here is a link that explains what you need to do to straighten it out:
I didn’t change the asteriskuser password. That one is still correct in all of those files. The password that I had changed was the mysql password for root. Not sure if that affects anything.
I followed the steps in that page you linked, and those passwords are still correct for the asteriskuser. Still very confused on this issue.
Did you try right now, logging into your asteriskcdr database with the username/password you think you have now for it?
From your very first post in this thread it looks like the asterisk is connecting to your asteriskcdr database correctly.
Why you try one more time to make sure.
Maybe your next step is to try your month old restore.
I am wondering if that will fix your problem ,though.
Do you by chance have Webmin on this particular server?
Also I am sure you have tried restarting asterisk a couple times, if not a hundred since this all started?
-bash-3.2# mysql -u asteriskuser -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 561
Server version: 5.0.77 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> exit
Bye
Yes, I was able to login using the password that has been set on the server since day 1. The only pass I changed was for root for the mysql. I’m not sure what Webmin is.
Yes, I have restarted asterisk many times since this started.
I’m kinda scared to restore from a month ago. I had to restore from a backup from yesterday, and it took me time to repair the damage from doing that. Using yum to update after getting to elastix 2.8 is not a good idea, I’ll tell you from experience.
What happens now if you leave a simple voicemail.
Just mockup leaving a voicemail.Connect two extensions,leave a message at ext #2 then log into this voicemail account. Is this new voicemail ever showing?
Are you able to see this from the recordings interface?
Do you by chance have Webmin installed on this server?
Just an idea, I’d be glad to GUI into it if you did,possibly see something,but don’t expect you to do this it goes without saying. Just a possibility.
I can view the recordings and the voicemail on the same page now, but i have to login with each extension and pass. I used to be able to login to elastix with admin and on the monitor tab i could view everything at once.
I installed cacti using yum. probably should have done some more research when I did it. Now that I think about it, I didn’t know what the root password for mysql was, so I had to shut down the service, and re-create a new root pass for mysql. that may have had something to do with it also.
/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -u root -p
use mysql
update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;
I am not sure on recent default installs of Cacti. I know there are modules for Cacti to monitor Asterisk. This is merely a wild guess. I am wondering if the install of Cacti possibly changed symlinks somehow with the asterisk /spool directory. This could only happen of course if the default install of Cacti installs the Asterisk modules by default.
As last I knew Cacti did not install Asterisk modules by default,so this is probably nothing but hot air,on my part.
I would think the devs at Cacti would have this ironed out to were uninstalling Cacti resets the astersik configs back to original but it is a possibility. Possibly a bug in the version of Cacti you installed? Did you do an rpm install of Cacti or source build Cacti?
there appears to be no symlinks in /var/spool/asterisk/voicemail/device
-bash-3.2# ls -la /var/spool/asterisk/voicemail/device
total 16
drwxrwxrwx 3 asterisk asterisk 4096 Feb 21 15:45 .
drwxrwxr-x 4 asterisk asterisk 4096 Feb 21 15:31 …
drwxrwxrwx 2 asterisk asterisk 4096 Feb 21 15:45 6500
The folder 6500 I added yesterday as part of my testing.
ls -la /var/spool/asterisk/monitor - i didn’t post all of the results, there are over 1500
-rw------- 1 asterisk asterisk 1018284 Feb 21 16:25 OUT6505-20110221-162450-1298330690.422.wav
-rw------- 1 asterisk asterisk 1663084 Feb 21 16:43 OUT6505-20110221-164116-1298331676.430.wav
-rwxrwxr-x 1 asterisk asterisk 1953644 Feb 16 16:57 OUT6510-20110216-165510-1297900510.14295.wav
-rwxrwxr-x 1 asterisk asterisk 10145004 Feb 17 08:49 OUT6510-20110217-083902-1297957142.23.wav
-rwxrwxr-x 1 asterisk asterisk 8624044 Feb 17 10:48 OUT6510-20110217-103900-1297964340.149.wav
-rwxrwxr-x 1 asterisk asterisk 39084 Feb 17 12:53 OUT6510-20110217-125319-1297972399.293.wav
-rwxrwxr-x 1 asterisk asterisk 33004 Feb 17 12:53 OUT6510-20110217-125337-1297972417.294.wav
-rwxrwxr-x 1 asterisk asterisk 39084 Feb 17 12:54 OUT6510-20110217-125419-1297972459.296.wav
-rwxrwxr-x 1 asterisk asterisk 2258604 Feb 17 12:57 OUT6510-20110217-125434-1297972474.297.wav
-rwxrwxr-x 1 asterisk asterisk 31404 Feb 18 12:02 OUT6510-20110218-120249-1298055769.715.wav
-rwxrwxr-x 1 asterisk asterisk 64044 Feb 18 12:03 OUT6510-20110218-120302-1298055782.718.wav
-rwxrwxr-x 1 asterisk asterisk 64044 Feb 18 12:03 OUT6510-20110218-120314-1298055794.721.wav
-rwxrwxr-x 1 asterisk asterisk 867884 Feb 18 12:04 OUT6510-20110218-120355-1298055835.724.wav
-rwxrwxr-x 1 asterisk asterisk 39724 Feb 18 12:05 OUT6510-20110218-120522-1298055922.726.wav
-rwxrwxr-x 1 asterisk asterisk 1094124 Feb 18 12:07 OUT6510-20110218-120613-1298055973.729.wav
-rwxrwxr-x 1 asterisk asterisk 907244 Feb 18 14:34 OUT6510-20110218-143349-1298064829.845.wav
-rw-rw-r-- 1 asterisk asterisk 2948204 Feb 18 16:16 OUT6510-20110218-161308-1298070788.56.wav
-rw------- 1 asterisk asterisk 1707244 Feb 21 11:05 OUT6510-20110221-110325-1298311405.63.wav
-rw------- 1 asterisk asterisk 2514284 Feb 21 12:25 OUT6510-20110221-122240-1298316160.146.wav
-rwxrwxr-x 1 asterisk asterisk 9096044 Feb 16 12:18 OUT6516-20110216-120856-1297883336.13796.wav
-rwxrwxr-x 1 asterisk asterisk 10033964 Feb 16 14:21 OUT6516-20110216-141037-1297890637.13984.wav
-rwxrwxr-x 1 asterisk asterisk 17631084 Feb 16 15:42 OUT6516-20110216-152348-1297895028.14201.wav
Feb 17th is the last date that I can view the recordings in Elastix.
The rights on the latest files in the list appear to be wrong. What would cause that?
-rw------- 1 asterisk asterisk 2514284 Feb 21 12:25 OUT6510-20110221-122240-1298316160.146.wav
Okay, i did chmod -c -R 777 /var/spool/asterisk/monitor, but still unable to see the recordings. What’s weird now is, I now have the recordings tab like the old style CDR… so at this point, I am able to access the recorded calls by going to localhost/recordings. It’s more work, but at least it’s doable. Still very confused by why all of this happened when all I wanted to do was install cacti. I have a backup, but it’s from a month ago, almost tempted to restore it anyway.
I am assuming if you go to your "Recordings tab’, is there were you seen your ‘saved recordings’?, such as "monitored calls’? Reason I ask i have never used the recordings deal.
Is this in the same interface as ‘recordings’ for voicemails?
I am showing my stupidity. I am good at that!
I would assume you can not see at all your voicemails,such as if you log in yourself to your extension number? I can’t imagine you can see anything here without the symlinks as we have went through this previous.
Sorry, I missed that. There is no folder /var/spool/asterisk/voicemail/default/~
there are folders in default with each extension.
-bash-3.2# ls -la /var/spool/asterisk/voicemail/device
total 16
drwxrwxrwx 3 asterisk asterisk 4096 Feb 21 15:45 .
drwxrwxr-x 4 asterisk asterisk 4096 Feb 21 15:31 …
drwxrwxrwx 2 asterisk asterisk 4096 Feb 21 15:45 6500
(this folder was created by me earlier while I was trying to troubleshoot by reading through the error logs.)
-bash-3.2# ls -la /var/spool/asterisk/voicemail/default
total 100
drwxrwxrwx 22 asterisk asterisk 4096 Feb 21 11:57 .
drwxrwxr-x 4 asterisk asterisk 4096 Feb 21 15:31 …
drwxrwxrwx 6 asterisk asterisk 4096 Sep 15 03:49 1234
drwxrwxrwx 6 asterisk asterisk 4096 Dec 22 09:28 6100
drwxrwxrwx 4 asterisk asterisk 4096 Feb 3 09:08 6101
drwxrwxrwx 6 asterisk asterisk 4096 Dec 6 09:53 6110
drwxrwxrwx 4 asterisk asterisk 4096 Jan 5 12:10 6120
drwxrwxrwx 4 asterisk asterisk 4096 Dec 16 09:26 6125
drwxrwxrwx 4 asterisk asterisk 4096 Feb 7 12:55 6130
drwxrwxrwx 6 asterisk asterisk 4096 Feb 4 08:30 6140
drwxrwxrwx 4 asterisk asterisk 4096 Feb 4 08:52 6145
drwxrwxrwx 6 asterisk asterisk 4096 Feb 15 10:38 6500
drwxrwxrwx 6 asterisk asterisk 4096 Nov 18 02:57 6501
drwxrwxrwx 6 asterisk asterisk 4096 Dec 16 15:15 6502
drwxrwxrwx 4 asterisk asterisk 4096 Jan 7 09:10 6503
drwxrwxrwx 6 asterisk asterisk 4096 Jan 19 10:56 6504
drwxrwxrwx 4 asterisk asterisk 4096 Feb 1 12:26 6505
drwxrwxrwx 6 asterisk asterisk 4096 Feb 18 14:30 6510
drwxrwxrwx 6 asterisk asterisk 4096 Jan 21 16:02 6515
drwxrwxrwx 4 asterisk asterisk 4096 Feb 7 13:21 6516
drwxrwxrwx 4 asterisk asterisk 4096 Dec 7 13:25 6525
drwxrwxrwx 4 asterisk asterisk 4096 Sep 20 15:13 6550
Thank you very much for taking the time to assist on this!
You did not mention. In Nautilus do you see the /var/spool/asterisk/voicemail/default/~ directory?
It appears your symlinks are either not there or are broken under FreePBX.
Do the following:
ls -la /var/spool/asterisk/voicemail/device
ls -la /var/spool/asterisk/voicemail/default
You should see an equal number of symlinks to the number of extensions you have entered. ( Even extensions numbers that have been deleted,keep in mind.)
From what you have posted this is most definately your FreePBX problem not showing your CDR’s.
Copy/Paste the returns on the above two commands. I bet we can get your FreePBX to start seeing your CDR reports.
For some reason your FreePBX does not appear to be able to ‘make’ a symlink to the correct /var/spool/asterisk/voicemail/default/#### ?
This is a cludge, but try this.
Okay, I ran chmod on the directory, and that seems to have fixed the voicemail issue on one of the extensions, but I’m still unable to see any recorded messages after around 3pm on the 17th. I’m so very confused by this issue.
I did exactly as you suggested, and I’m not getting any errors messages relating to the CDR. Just to make sure I was looking at the correct file, I tried again to access the Cacti page (which is not functioning) and was able to see those errors.
/bin/ln: creating symbolic link /var/spool/asterisk/voicemail/device/1009' to/var/spool/asterisk/voicemail/default/1009/’: No such file or directory
/bin/ln: creating symbolic link /var/spool/asterisk/voicemail/device/6506' to/var/spool/asterisk/voicemail/default/6506/’: No such file or directory
/bin/ln: creating symbolic link /var/spool/asterisk/voicemail/device/6510' to/var/spool/asterisk/voicemail/default/6510/’: No such file or directory
/bin/ln: creating symbolic link /var/spool/asterisk/voicemail/device/6510' to/var/spool/asterisk/voicemail/default/6510/’: No such file or directory
[Mon Feb 21 14:41:39 2011] [error] [client 192.168.75.189] PHP Warning: include(/usr/share/cacti/include/config.php) [function.include]: failed to open stream: Permission denied in /usr/share/cacti/include/global.php on line 45