SOLVED Odd Log

womble1

Guru
Joined
Oct 19, 2008
Messages
632
Reaction score
6
Hi,
I am trying to use click to dial…
and I'm getting this error in httpd error logs…

[Sat Nov 05 22:38:29 2011] [notice] Apache/2.2.3 (CentOS) configured -- resuming normal operations
[Sat Nov 05 22:38:37 2011] [error] [client 192.168.100.43] MySQL Authentication requested but MySQL module not installed!
[Sat Nov 05 22:38:37 2011] [error] [client 192.168.100.43]

any one know why… ?

Purple install (about 6 months ago) asterisk 1.8
all latest updates and fixes...
 

billsimon

Well-Known Member
Joined
Jan 2, 2011
Messages
1,534
Reaction score
727
Install the apache mysql auth module:

yum install mod_auth_mysql
 

womble1

Guru
Joined
Oct 19, 2008
Messages
632
Reaction score
6
THanks do I have to add lines to httpd.conf as well ?
 

womble1

Guru
Joined
Oct 19, 2008
Messages
632
Reaction score
6
hmmm…
still get this

[Sun Nov 06 09:29:35 2011] [error] [client 192.168.100.43] MySQL Authentication requested but MySQL module not installed!
[Sun Nov 06 09:29:35 2011] [error] [client 192.168.100.43]

added a loadmodule line to httpd but…

root@tel:~ $ service httpd start
Starting httpd: [Sun Nov 06 09:28:53 2011] [warn] module mysql_auth_module is already loaded, skipping

so it looks like the module loads ok…
 

billsimon

Well-Known Member
Joined
Jan 2, 2011
Messages
1,534
Reaction score
727
Sorry, that one is beyond me! It looked like a simple apache module missing (mod_auth_mysql isn't installed by default) but I guess there's more to the puzzle than that.
 

siminthecity

New Member
Joined
Feb 2, 2012
Messages
9
Reaction score
0
Hi Womble1

Did you ever get to the bottom of this?

I believe I may be running the same perl script AsteriskC2D from Rho Stuff which I have configured on my setup, installed the relevant perl modules, including;
Code:
Net::Telnet, Data::Dumper, DBD::mysql and DBI
as well as installing for apache
Code:
mod_auth_mysql

The httpd log output was being generated by the script rather than SQL so am inclined to think there may be an error in the script rather than SQL server - but I'm no perl or mySQL guru...

I ended up stripping out the user authentication elements out of AsteriskC2D.pl script to get it running as this SQL authentication issue was killing the script.

Any guidance appreciated.

Cheers
Sean
 

womble1

Guru
Joined
Oct 19, 2008
Messages
632
Reaction score
6
Yep I did indeed.
I'll post back the fix, forgotten… can you believe it.
 

womble1

Guru
Joined
Oct 19, 2008
Messages
632
Reaction score
6
OK here is the fix…
Force a reinstall of MYsql
with
cpan -f Mysql
That does it.
 

siminthecity

New Member
Joined
Feb 2, 2012
Messages
9
Reaction score
0
Thanks. I did a force install of mysql...but still no joy.

I'll try to find some other perl scripts that exercise mySQL to check all is well with the perl modules, before going over the script again.

Cheers
 

womble1

Guru
Joined
Oct 19, 2008
Messages
632
Reaction score
6
did you use that command ?
I tried other ways and it failed.
 

siminthecity

New Member
Joined
Feb 2, 2012
Messages
9
Reaction score
0
First I opened a CPAN shell:
Code:
perl -MCPAN -e shell

then used the force install command:
Code:
force install Bundle::DBD::mysql
 

siminthecity

New Member
Joined
Feb 2, 2012
Messages
9
Reaction score
0
All sorted. I ran the command you suggested verbatim and it works perfectly!

Many thanks I think you have saved me hours of grief!
 

siminthecity

New Member
Joined
Feb 2, 2012
Messages
9
Reaction score
0
All good now. Thanks again Womble, that command to install the (correct) Mysql module did the trick!!

How have you found the performance of AsteriskC2D? On my system (running the client on a relatively newish 2010-model MacBookPro) the initiation sequence takes a little while (I think about 5 to 10 seconds, I'll time it next time) before the call appears on my phone. I have tried with, and as you know, without the SQL user authentication in the perl script. Both ways seems to take a little while - definitely not what you would call snappy.

I guess this is because the C2D client needs call the script which then must (a) run a MySQL search for user authentication and (b) initialise and log-in to the AMI interface before (c) issuing the dial commands. This all adds up.

I have done a back to back comparison with CallControl on the same machine. CallControl maintains an open login/connection to AMI, then simply issues the dial commands as required. The call is initiated pretty much instantaneously.
 

Members online

No members online now.

Forum statistics

Threads
25,778
Messages
167,504
Members
19,199
Latest member
leocipriano
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.
Top