Same problem. I dropped all the tables and ran the above. I also checked the sockets and they are correct. Any other ideas?
<SNIP> I am still stuck on this. </SNIP> Allright, let us do it the easy way. Just copy and run the script below on your Mysql Command line. Lets see how this goes. If you want to use webmin to find what the problem is go to webmin -> servers ->Mysql and check the configuration there. My guess is that there may be some problem with your Mysql Socket which may have been configured for running at /tmp/mysql.sock rather than what ASTCC expects at /var/lib/mysql/mysql.sock If the problem is with the Mysql Socket, them you have to use webmin to redefine the mysql sock file location as /tmp/mysql.sock (first of all find if this is the case). If this is looking for a Mysql Socket at /var/lib/mysql/mysql.sock and infact your socket is /tmp/mysql.sock , then you have to add a symbolic link using the command below: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Seshu Kanuri ------------ ##Create table manually ## use astcc; CREATE TABLE `brands` ( `name` char(40) NOT NULL default '', `language` char(10) default NULL, `publishednum` char(40) default NULL, `did` char(40) default NULL, `markup` int(11) default NULL, `inc` int(11) default NULL, PRIMARY KEY (`name`) ) TYPE=MyISAM; CREATE TABLE `cards` ( `number` char(20) NOT NULL default '', `language` char(10) default NULL, `facevalue` int(11) default NULL, `used` int(11) NOT NULL default '0', `inc` int(11) NOT NULL default '0', `markup` int(11) NOT NULL default '0', `creation` timestamp(14) NOT NULL, `firstuse` timestamp(14) NOT NULL default '00000000000000', `expiration` timestamp(14) NOT NULL default '00000000000000', `inuse` int(11) default NULL, `pin` char(20) NOT NULL default '123456789', PRIMARY KEY (`number`) ) TYPE=MyISAM; CREATE TABLE `cdrs` ( `cardnum` char(40) default NULL, `callerid` char(80) default NULL, `callednum` char(80) default NULL, `trunk` char(40) default NULL, `disposition` char(20) default NULL, `billseconds` int(11) default NULL, `billcost` int(11) default NULL ) TYPE=MyISAM; CREATE TABLE `iaxfriends` ( `name` char(40) NOT NULL default '', `secret` char(40) default NULL, `context` char(40) default NULL, `ipaddr` char(20) default NULL, `port` int(6) default NULL, `regseconds` int(11) NOT NULL default '0', PRIMARY KEY (`name`) ) TYPE=MyISAM; CREATE TABLE `routes` ( `pattern` char(40) NOT NULL default '', `comment` char(80) default NULL, `trunks` char(80) default NULL, `connectcost` int(11) NOT NULL default '0', `includedseconds` int(11) NOT NULL default '0', `cost` int(11) NOT NULL default '0', PRIMARY KEY (`pattern`) ) TYPE=MyISAM; CREATE TABLE `sipfriends` ( `name` char(40) NOT NULL default '', `username` char(40) default NULL, `secret` char(40) NOT NULL default '', `context` char(40) NOT NULL default '', `ipaddr` char(20) NOT NULL default '', `port` int(6) NOT NULL default '0', `regseconds` int(11) default NULL, PRIMARY KEY (`name`) ) TYPE=MyISAM; CREATE TABLE `trunks` ( `name` char(40) NOT NULL default '', `tech` char(10) default NULL, `path` char(40) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -------------------------------------------------------- _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
