Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
yes, mysql compilation into vm2 is broken, see my patch at http://bugs.digium.com/bug_view_page.php?bug_id=441 these patches fix the compilation problem of mysql-vm-routines In voicemail.conf, however, there is no paramter to specify a port (or socket), at least not from what I read here on the list. That is correct; it was never added. Given the licensing problem with MySQL, it is not likely to be added. I can add it, that's not a problem (and I'll do since we use mysql-vm interface). but since that requires that at least the compilation works, I'll not make/release it until the above patches are included. also other settings can be added into mysql... but I see only the auth part as very useful... Matteo. -- Matteo Brancaleoni Espia System Administrator Email : [EMAIL PROTECTED] Web : http://www.espia.it Phone : +39 02 70633354 - ext 911 IAX(2): [EMAIL PROTECTED] - ext 911 Iaxtel: 1-700-56-62458 - ext 911 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
[Asterisk-Users] Anyone got VM2 working with MySQL?
I guess the subject says it all.. :) I am running the CVS from right now.. +- 12:25 GMT MySQL CDR logging is installed and working.. Anyone got any ideas? ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
Hi! MySQL CDR logging is installed and working.. Same question, same situation for me. Can you connect via localhost socket for CDR? That didn't work for me (on two machines), I need to use hostname port. In voicemail.conf, however, there is no paramter to specify a port (or socket), at least not from what I read here on the list. How is this supposed to work anyway - with another #include file, or does Asterisk internally merge mySQL voice mailbox settings and voicemail.conf? When I dial my test setup defined in mySQL then * complains that there is no such entry... :-( By the way: With Voicemail2 and the web interface is forwarding working for you? Appears to be broken... Cheers, Philipp ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
Philipp von Klitzing wrote: Hi! MySQL CDR logging is installed and working.. Same question, same situation for me. Can you connect via localhost socket for CDR? That didn't work for me (on two machines), I need to use hostname port. My MySQL is on another server so I haven't tried localhost.. In voicemail.conf, however, there is no paramter to specify a port (or socket), at least not from what I read here on the list. How is this supposed to work anyway - with another #include file, or does Asterisk internally merge mySQL voice mailbox settings and voicemail.conf? When I dial my test setup defined in mySQL then * complains that there is no such entry... :-( Not sure how its supposed to work, I am just trying it out for the first time now.. By the way: With Voicemail2 and the web interface is forwarding working for you? Appears to be broken... Don't use the web interface.. My bigger problem is that my server is crashing now... trying an older CVS and hopefully I get it up and running again.. Later.. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
I am having the same problem. Here are my findings: In asterisk/messages log file: Oct 25 10:55:11 WARNING[19474]: File app_voicemail2.c, Line 2388 (vm_execmain): Couldn't read username CLI debug output is as follows when accessing the VoiceMailMain2 from extension 8500: Executing VoiceMailMain2(SIP/2205-3df0, ) in new stack -- Playing 'vm-login' -- Playing 'vm-password' -- Incorrect password '1234' for user '0' (context = any) -- Playing 'vm-incorrect' -- Playing 'vm-password' -- Incorrect password '2421' for user '2205' (context = any) -- Playing 'vm-incorrect' I added the context in to my exten Voicemail2 statement in extensions to see if this would help: Voicemail2([EMAIL PROTECTED]) but it did not. John - Original Message - From: Philipp von Klitzing [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 27, 2003 8:11 AM Subject: Re: [Asterisk-Users] Anyone got VM2 working with MySQL? Hi! MySQL CDR logging is installed and working.. Same question, same situation for me. Can you connect via localhost socket for CDR? That didn't work for me (on two machines), I need to use hostname port. In voicemail.conf, however, there is no paramter to specify a port (or socket), at least not from what I read here on the list. How is this supposed to work anyway - with another #include file, or does Asterisk internally merge mySQL voice mailbox settings and voicemail.conf? When I dial my test setup defined in mySQL then * complains that there is no such entry... :-( By the way: With Voicemail2 and the web interface is forwarding working for you? Appears to be broken... Cheers, Philipp ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
On Monday 27 October 2003 07:11, Philipp von Klitzing wrote: MySQL CDR logging is installed and working.. Can you connect via localhost socket for CDR? That didn't work for me (on two machines), I need to use hostname port. In all likelihood, you have an authentication problem. Note that specifying '%' (or a name) for the hostname portion in your GRANT does NOT match 'localhost'. By far this is the most common misperception, which leads people to believe that it doesn't work. If you want to use a local connection (i.e. socket file, skipping TCP), the hostname portion of your GRANT *must* be 'localhost'. In voicemail.conf, however, there is no paramter to specify a port (or socket), at least not from what I read here on the list. That is correct; it was never added. Given the licensing problem with MySQL, it is not likely to be added. How is this supposed to work anyway - with another #include file, or does Asterisk internally merge mySQL voice mailbox settings and voicemail.conf? When I dial my test setup defined in mySQL then * complains that there is no such entry... :-( Asterisk would use the settings in the MySQL database instead of, not in addition to, the voicemail boxes in voicemail.conf. -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
Tilghman Lesher wrote: On Monday 27 October 2003 07:11, Philipp von Klitzing wrote: MySQL CDR logging is installed and working.. Can you connect via localhost socket for CDR? That didn't work for me (on two machines), I need to use hostname port. In all likelihood, you have an authentication problem. Note that specifying '%' (or a name) for the hostname portion in your GRANT does NOT match 'localhost'. By far this is the most common misperception, which leads people to believe that it doesn't work. If you want to use a local connection (i.e. socket file, skipping TCP), the hostname portion of your GRANT *must* be 'localhost'. I am sure my setup did not have permissions issues.. In voicemail.conf, however, there is no paramter to specify a port (or socket), at least not from what I read here on the list. That is correct; it was never added. Given the licensing problem with MySQL, it is not likely to be added. The error in the log says that it is not able to sort out the username in the first place, but as you say there is the licencing issues now so it looks like the feature will probably never be fixed and will eventually be removed.. This is unfortunate because we have a number of MySQL servers but no PGSQL servers.. Look like if I want a DB driven system I am going to have to use PGSQL for VM and MySQL for everything else.. What a PITA!! How is this supposed to work anyway - with another #include file, or does Asterisk internally merge mySQL voice mailbox settings and voicemail.conf? When I dial my test setup defined in mySQL then * complains that there is no such entry... :-( Asterisk would use the settings in the MySQL database instead of, not in addition to, the voicemail boxes in voicemail.conf. Or none at all seeing as no one can get it to work.. :) Later.. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
Hi! Can you connect via localhost socket for CDR? That didn't work for me (on two machines), I need to use hostname port. In all likelihood, you have an authentication problem. Note that specifying '%' (or a name) for the hostname portion in your GRANT does NOT match 'localhost'. That I am aware of, in fact I made four users covering all possibilities (on one machine I need to use the local hostname instead of localhost for some reason); moreover I logged in locally using mysql -u xxx -p and that worked well for the db and table in question. So it must be something else. In voicemail.conf, however, there is no paramter to specify a port (or socket), at least not from what I read here on the list. That is correct; it was never added. Given the licensing problem with MySQL, it is not likely to be added. What does that mean in this case: 1. The port is fixed to 3306, and hostname can be anything, or 2. Voicemail can only work with mySQL on the same box via socket and hostname must always be localhost? Moreover: Do we have to expect mySQL support to be removed completely, and we should thus not spend our time on building on that, including CDR? Or will the db backend be swapped with something else like sqllite or pg? As you see I am a bit puzzled (and I am probably not alone at that). :- How is this supposed to work anyway - with another #include file, or does Asterisk internally merge mySQL voice mailbox settings and voicemail.conf? When I dial my test setup defined in mySQL then * complains that there is no such entry... :-( Asterisk would use the settings in the MySQL database instead of, not in addition to, the voicemail boxes in voicemail.conf. Hm... where would I then define the [general] part and the [zonemessages] part that I currently have in voicemail.conf? I see no room for that in the proposed table structure. Greetings, Philipp ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
On Monday 27 October 2003 12:21, Philipp von Klitzing wrote: In voicemail.conf, however, there is no paramter to specify a port (or socket), at least not from what I read here on the list. That is correct; it was never added. Given the licensing problem with MySQL, it is not likely to be added. What does that mean in this case: 1. The port is fixed to 3306, and hostname can be anything, or 2. Voicemail can only work with mySQL on the same box via socket and hostname must always be localhost? 1. The port is fixed. You should still be able to use 'localhost' as the hostname, to get a socket connection, but you will be unable to use any alternate socket file (could be /tmp/mysql.sock or could be /var/lib/mysql/mysql.sock, depending on how it was compiled). Moreover: Do we have to expect mySQL support to be removed completely, and we should thus not spend our time on building on that, including CDR? Or will the db backend be swapped with something else like sqllite or pg? As you see I am a bit puzzled (and I am probably not alone at that). :- We expect that the MySQL support will not be enhanced. When somebody volunteers to modify the code in such a way as to make another database an option, that will happen then, not before. Any legacy MySQL support will probably be moved at that time to asterisk-addons. There is also certainly a possibility to make the database support in voicemail a little more modular, but that will be up to the individual writing the code. How is this supposed to work anyway - with another #include file, or does Asterisk internally merge mySQL voice mailbox settings and voicemail.conf? When I dial my test setup defined in mySQL then * complains that there is no such entry... :-( Asterisk would use the settings in the MySQL database instead of, not in addition to, the voicemail boxes in voicemail.conf. Hm... where would I then define the [general] part and the [zonemessages] part that I currently have in voicemail.conf? I see no room for that in the proposed table structure. Sorry, tried to be explicit, but it's using MySQL *only* for voicemail box definitions, not for any other settings (i.e. either general or zonemessages). Obviously, the database parameters must be present in voicemail.conf, not in the database, otherwise you have a paradox in the making. ;-) -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Anyone got VM2 working with MySQL?
See mbranca's patch at: http://bugs.digium.com/bug_view_page.php?bug_id=441 On Mon, 27 Oct 2003, WipeOut wrote: I guess the subject says it all.. :) I am running the CVS from right now.. +- 12:25 GMT MySQL CDR logging is installed and working.. Anyone got any ideas? ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users ___ Steve Creel[EMAIL PROTECTED] ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users