Just documenting this issue and how I solved it for future reference on the list, hope it helps someone:
I blew away my primary Asterisk install just because I felt it wasn't as clean as it could be. I wanted to put on the latest AMP 1.0.007 (which, by the way, totally rocks) and everything went fine, except when I opened the call detail reports page PHP gave me a bunch of errors about no fields in asteriskcdrdb. Doing a "show tables from asteriskcdrdb" in mySql yielded nothing. Thinking this was a permissions problem, I fooled around with permissions and repopulated the database with the procedure documented in the install guide: mysql -u root -p asteriskcdrdb < /usr/src/AMP/SQL/cdr_mysql_table.sql I did this several times and every time it kicked back to the command prompt, no problem. But every time, no tables! I was starting to get frustrated, so I put in phpMyAdmin and logged in and browsed the database. Nothing. WTF? I had the brainwave of actually looking at the SQL file, cdr_mysql_table.sql. It was empty! All of the other files were ok. To make sure it wasn't something to do with my box, I un-tar'd from the source again - same thing. To fix it, I downloaded 1.10.006, untar'd it, got the SQL, and executed the SQL manually in phpMyAdmin, and it went fine. Here's the SQL: CREATE TABLE cdr ( calldate datetime NOT NULL default '0000-00-00 00:00:00', clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT NULL default '', dcontext varchar(80) NOT NULL default '', channel varchar(80) NOT NULL default '', dstchannel varchar(80) NOT NULL default '', lastapp varchar(80) NOT NULL default '', lastdata varchar(80) NOT NULL default '', duration int(11) NOT NULL default '0', billsec int(11) NOT NULL default '0', disposition varchar(45) NOT NULL default '', amaflags int(11) NOT NULL default '0', accountcode varchar(20) NOT NULL default '', uniqueid varchar(32) NOT NULL default '', userfield varchar(255) NOT NULL default '' ); So, AMP 1.10.007 from SourceForge seems to have this problem, anyone upgrading won't run into this problem but a new install you will. _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
