Hi, I have Asterisk 12.7.1 installed through Asterisk@Home CD. and explicitly I have installed UnixODBC and FREETDS in order to access MS SQL 2000 Database which in on Windows 2003 Server on remote location. I tested connectivity through isql and tsql, both utilities are working fine. I need to access MS SQL 2000 Database through PHP. When I tired to check the connectivity through a Test PHP file I got following results: Fatal error: Call to undefined function: odbc_connect() in /var/www/html/odbctest.php on line 3 By Default PHP was configured with following switches: './configure' '--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db4=/usr' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd=shared' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-ncurses=shared' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-xml' '--with-expat-dir=/usr' '--with-dom=shared,/usr' '--with-dom-xslt=/usr' '--with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mbstring=shared' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mime-magic=/usr/share/file/magic.mime' '--with-apxs2=/usr/sbin/apxs' Please guide me what else should I need to do. Thanks Wazb
Not that this is particularly an Asterisk problem, but make sure unixodbc is listed when you do a phpinfo(); , also, you might want to make sure you have extension=unixodbc.so in your php.ini since you're compiling it as a shared module. Hope that helps a little bit. Wasif wrote:>Hi, > >I have Asterisk 12.7.1 installed through Asterisk@Home CD. and explicitly I >have installed UnixODBC and FREETDS in order to access MS SQL 2000 Database >which in on Windows 2003 Server on remote location. > >I tested connectivity through isql and tsql, both utilities are working >fine. > >I need to access MS SQL 2000 Database through PHP. When I tired to check the >connectivity through a Test PHP file I got following results: > >Fatal error: Call to undefined function: odbc_connect() in >/var/www/html/odbctest.php on line 3 > > >By Default PHP was configured with following switches: >'./configure' '--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu' >'--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' >'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' >'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' >'--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' >'--sharedstatedir=/usr/com' '--mandir=/usr/share/man' >'--infodir=/usr/share/info' '--cache-file=../config.cache' >'--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' >'--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' >'--disable-rpath' '--enable-inline-optimization' '--with-bz2' >'--with-db4=/usr' '--with-curl' '--with-exec-dir=/usr/bin' >'--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd=shared' >'--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' >'--with-ncurses=shared' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' >'--with-openssl' '--with-png' '--with-pspell' '--with-xml' >'--with-expat-dir=/usr' '--with-dom=shared,/usr' '--with-dom-xslt=/usr' >'--with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre-regex=/usr' >'--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' >'--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' >'--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' >'--enable-wddx' '--with-pear=/usr/share/pear' '--with-imap=shared' >'--with-imap-ssl' '--with-kerberos' '--with-ldap=shared' >'--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' >'--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' >'--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' >'--enable-dio' '--enable-mbstring=shared' '--enable-mbstr-enc-trans' >'--enable-mbregex' '--with-mime-magic=/usr/share/file/magic.mime' >'--with-apxs2=/usr/sbin/apxs' > > >Please guide me what else should I need to do. > > >Thanks > >Wazb > >_______________________________________________ >--Bandwidth and Colocation provided by Easynews.com -- > >Asterisk-Users mailing list >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > >!DSPAM:44870975154201497913098! > > > > >-- Derek Fedel Director of Network Development
I used the configure option '--with-mssql' after freeTDS is installed. http://uk.php.net/manual/en/ref.mssql.php> Fatal error: Call to undefined function: odbc_connect() in > /var/www/html/odbctest.php on line 3
Dear If I have an extention 111 and 112 on my system but when the user 111 call the 112 call it through trunk not through local to perform a billing How can I solve it Regards ********************************************* No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. *********************************************