Displaying 3 results from an estimated 3 matches for "default_db".
Did you mean:
default_dc
2007 May 02
1
Query about RODBC to access MySQL from Windows
...lts.
i.e. sqlQuery(channel, "show tables") yields 0 rows
when there are close to 500 tables in the database.
Ditto with any other query. It does not cause an
error, but it returns 0 rows.
The USER DSN "mysqldsn" is set up as follows :-
host : zion.xxx.xxx.xxx
default database : default_db
port : 3306
username : uname
password : pwd
Running " use default_db; show tables;" command from
the command prompt on the db server returns 500 rows.
I find this problem while running any query.
Running "select * from tname limit 100" returns 0 rows
whereas tname has around...
2020 Oct 29
2
astdbdir in asterisk.conf has no effect
...6504 214004 ? S<sl 13:56 0:24
/usr/sbin/asterisk -mqC /etc/asterisk/asterisk.conf
Yet it's still running in the old place:
# lsof -n | grep astdb.sqlite | awk '{print $11}' | sort | uniq
/var/lib/asterisk/astdb.sqlite3
I see default.h defines the path with the astdb:
#define DEFAULT_DB "/var/lib/asterisk/astdb"
so I tried astdbdir => /tmp/asterisk/astdb, but no change. It's still
running in /var/lib/asterisk.
I feel like I'm missing something. Any suggestions?
- Jeff
-------------- next part --------------
An HTML attachment was scrubbed...
URL:...
2020 Oct 29
0
astdbdir in asterisk.conf has no effect
.../usr/sbin/asterisk -mqC /etc/asterisk/asterisk.conf
>
> Yet it's still running in the old place:
>
> # lsof -n | grep astdb.sqlite | awk '{print $11}' | sort | uniq
> /var/lib/asterisk/astdb.sqlite3
>
> I see default.h defines the path with the astdb:
> #define DEFAULT_DB "/var/lib/asterisk/astdb"
> so I tried astdbdir => /tmp/asterisk/astdb, but no change. It's still
> running in /var/lib/asterisk.
>
> I feel like I'm missing something. Any suggestions?
>
Have you removed the (!) beside [ general] in asterisk.conf?
--...