Test that the ODBC driver is working odbcinst -s -qshould result in MySQL-asteriskcdrdb.Check the asterisk odbc file, which Asterisk uses to connect to the CDR DB, contains the follow. Nano /etc/asterisk/resodbcadditional.conf asteriskcdrdbenabled=yesdsn=MySQL-asteriskcdrdbpooling=nolimit=1pre-connect=yesusername=asteriskuserpassword=amp109Using the above information, test that it can can connect to the DB via odbc isql -v MySQL-asteriskcdrdb asteriskuser amp109should result in: +-+ Connected! sql-statement help tablename quit +-+. Lastly create or add the following. Note connection=asteriskcdrdb matches asteriskcdrdb in resodbcadditional.conf. Calldate does not exist any more in cdradaptiveodbc.so.
To have the behaviour the same as standard cdr functions we add the alias start line. Nano /etc/asterisk/cdradaptiveodbc.conf firstconnection=asteriskcdrdbtable=cdralias start = calldateIf cdr-mysql module is enabled at the same time as the cdr odbc you will get double entries in the CDR DB.
Therefore we need to disable cdr-mysql. Mv /etc/asterisk/ cdrmysql.conf /etc/asterisk/cdrmysql.conf.disabledamportal restart- Misc. Optional settingsChange the “uploadmaxfilesize” from 2M to 20M to allow larger music on hold files RHEL 6.
Nano +878 /etc/php.iniEdit Apache web server for GUI access using a port other than 80: nano +134 /etc/httpd/conf/httpd.confchange Listen 80 to Listen 8888 or whatever port you want Change default Apache setting of AllowOverride None to All so that Apache obeys directives in.htaccess files which by default prevents viewing sensitive directories on Freepbx. Nano +338 /etc/httpd/conf/httpd.conf AllowOverride AllAnd restart apache. Service httpd restartInstead of accessing FreePBX by You now access it by http://xxx.xxx.xxx.xxx:8888. Now add the following lines:? #Password protect the Flash Operator Panel Page /var/www/html/admin/modules/fwfopAuthType BasicAuthName 'Restricted Area'AuthUserFile /usr/local/apache/passwd/wwwpasswdRequire user NewUserNameTo delete an Apache user, type in the following and then remove the user from the httpd.conf file. Htpasswd -D /usr/local/apache/passwd/wwwpasswd NewUserNameTo change the password: htpasswd /usr/local/apache/passwd/wwwpasswd NewUserNameThen restart apache. Service httpd restart.
Hello,Hoping someone can shed some light on this for me - I am testing a fresh install of FreePBX with the Schmoozecom iso, and can not seem to get tftp working (or I am really doing something wrong). I am running it in a VM on VMWare Fusion on a mac host, I can get to the web configs, I set up 2 extensions, and loaded some Cisco firmware in the tftpboot directory, but when I set the phone to look at that server it will not pull anything from tftp. I am not sure how to test if tftp is running, can someone please assist? I am trying to upgrade from Trixbox with asterisk 1.4 to use the new Cisco firmware and phones which use SIP over TCP.Thanks!Jon. Discko is right this is a networking issue.trixbox did not use the OS tftp, they used atftpd, the log file was /var/log/atftpd.logYou can change the log file location of tftp in the xinet file just like you could in trixbox.What’s wrong with only using trixbox?
It’s not that something is wrong it’s that it was not a distro, it was a fork. And a lousy one as they screwed everything up including the users. It’s not a wide spectrum of experience.
“all” and I am sure I am forgetting some, of the other distro’s (PBX in a Flash, Elasix, Asterisk Now) use the native tftp package in Linux and not atftpd.I am sure if you ran tftp on the box to itself it would work. Here is an example session, I just grabbed a file in my home directory. The first two commands show you where I am and that the directory was empty to start. root@pioneer scott# pwd/home/scottroot@pioneer scott# lsroot@pioneer scott# tftp 127.0.0.1tftp get aastra.cfgtftp quitroot@pioneer scott# lsaastra.cfgroot@pioneer scott#root@pioneer scott#.
I tried all that and can’t get it working for some reason or anotheryes, it is true I have never used another distro in production other than trixbox, perhaps my “all other distros” comment was not correct. Is it a bad thing that I’ve “only used Trixbox”? I just put my old tb server back in production and every phone came up with no problem. I guess I will have to compare configs from this to the new one. Nothing I seem to do makes any difference, phones all timeout with tftp, and nothing registers, regardless of settings.I appreciate all the help so far but I seem to still be missing something really simple.
I copied the tftpboot directory file for file but that didn’t help either.I can put all the phones and server on one vlan if it would help. Right now the phones are 10.10.50.0/24 and the server is at 10.10.60.6. I would point to that as part of the issue, but again tb works fine with that setup. I am thinking it may be a NAT Issue with the VM and the way it handles networking - For now I have our DHCP server sending the TFTP address so I loaded the 9.3 SIP firmware to the production server, as well as the SEPMAC.cnf.xml file for the phone. It pulled down the firmware OK, and loaded the xml file ok as well. However it sits and says Registering, but nothing ever registers.
I have NAT=Never in the extension, and transport=TCP in the extension as well. Is there something else I need to set somewhere? This is my first foray into the world of TCP SIP phones, and I’d like to get it working since I really need to move from Trixbox. I like the Freepbx/schmoozecom distro so far, and it does support SIP over TCP if I’m not mistaken, so Id like to try and get it working (especially as all newer Cisco SIP loads use TCP).Can anyone shed light on the registration issue? I can post the xml file later if that will help, but I am using the same XML file that worked on the older cisco phones (non TCP).Scott - no, I will not be using the VM in production, it will go on a dedicated box.
Freepbx
Just wanted to test the new feature set with the new phone loads.THanks again all.Jon. Still nothing - I have done a completely fresh install on a new server (dedicated) and again have no tftp service.