Can't login agent after using separate mysql server

Asterisk Asterisk Support
1

Hi everyone! I have embarked on a project to separate mysql from an asterisk 1.2.30 server box on to another mysql server. I wanted to keep freePBX capability on the asterisk server, so I edited the following configs replacing the localhost for any instance of mysql:

a2billing.conf
cdr_mysql.conf
extensions_custom.conf
res_mysql.conf

We shut off mysql shut off on the main asterisk server as a test.

Now, agents are not able to receive calls. We get the “agent logged in” voice message, but “show agents” does not show that they are logged in. Is there something that I’ve missed?

2

Here’s another question - what conditions have to be met in order to get the following?

6519 (Nerdy) available at ‘8002@from-internal’ (musiconhold is ‘default’)

Also, here’s a “Verbose 15” log of this:

asterisk1CLI> set verbose 15
Verbosity was 1 and is now 15
– Executing NoOp(“SIP/9012-b7944470”, “agent login “device” <9012>| 9012”) in new stack
– Executing Macro(“SIP/9012-b7944470”, “agent_login|“device” <9012>|9012”) in new stack
– Executing Set(“SIP/9012-b7944470”, “agent=”) in new stack
– Executing GotoIf(“SIP/9012-b7944470”, “?104:9”) in new stack
– Goto (macro-agent_login,s,9)
– Executing NoOp(“SIP/9012-b7944470”, "Agent: ") in new stack
– Executing Set(“SIP/9012-b7944470”, “DB(agent/)=”) in new stack
– Executing AgentCallbackLogin(“SIP/9012-b7944470”, “||9012@from-internal”) in new stack
– Playing ‘agent-user’ (language ‘en’)
– Playing ‘agent-pass’ (language ‘en’)
== Setting global variable ‘AGENTBYCALLERID_9012’ to ‘4023’
– Playing ‘agent-loginok’ (language ‘en’)
== Callback Agent ‘4023’ logged in on 9012@from-internal
– Executing Hangup(“SIP/9012-b7944470”, “”) in new stack
== Spawn extension (macro-agent_login, s, 12) exited non-zero on ‘SIP/9012-b7944470’ in macro ‘agent_login’
== Spawn extension (macro-agent_login, s, 12) exited non-zero on ‘SIP/9012-b7944470’
– Executing Macro(“SIP/9012-b7944470”, “agent_logout|9012”) in new stack
– Executing Set(“SIP/9012-b7944470”, “__agent=4023”) in new stack
– Executing NoOp(“SIP/9012-b7944470”, “agent 4023”) in new stack
– Executing Set(“SIP/9012-b7944470”, “DB(agent/4023)=”) in new stack
– Executing UnpauseQueueMember(“SIP/9012-b7944470”, “|Agent/4023”) in new stack
– Executing Dial(“SIP/9012-b7944470”, “local/logout@macro-agent_logout/n||D(4023#4023##)o”) in new stack
– Called logout@macro-agent_logout/n
– Executing AgentCallbackLogin(“Local/logout@macro-agent_logout-36a9,2”, “”) in new stack
– Playing ‘agent-user’ (language ‘en’)
– Local/logout@macro-agent_logout-36a9,1 answered SIP/9012-b7944470
– Sending DTMF ‘4023#4023##’ to the called party.
– Playing ‘agent-pass’ (language ‘en’)
– Playing ‘agent-newlocation’ (language ‘en’)
– Playing ‘agent-loggedoff’ (language ‘en’)
== Callback Agent ‘4023’ logged out
– Executing Hangup(“Local/logout@macro-agent_logout-36a9,2”, “”) in new stack
== Spawn extension (macro-agent_logout, logout, 2) exited non-zero on ‘Local/logout@macro-agent_logout-36a9,2’
== Spawn extension (macro-agent_logout, s, 5) exited non-zero on ‘SIP/9012-b7944470’ in macro ‘agent_logout’
== Spawn extension (macro-agent_logout, s, 5) exited non-zero on 'SIP/9012-b7944470’
asterisk1CLI> exit
[root@asterisk1 ~]#

The above is from a working production system with MySQL as the localhost. However, I’m getting the following on my setup (external MySQL server) when I get audo confirmation that I’ve logged in:

6519 (nerdy) not logged in (musiconhold is ‘default’)

-- Remote UNIX connection disconnected
-- Executing NoOp("SIP/8002-09696f88", "agent login "device" <8002>| 8002") in new stack
-- Executing Macro("SIP/8002-09696f88", "agent_login|"device" <8002>|8002") in new stack
-- Executing Set("SIP/8002-09696f88", "agent=") in new stack
-- Executing GotoIf("SIP/8002-09696f88", "?104:9") in new stack
-- Goto (macro-agent_login,s,9)
-- Executing NoOp("SIP/8002-09696f88", "Agent:  ") in new stack
-- Executing Set("SIP/8002-09696f88", "DB(agent/)=") in new stack
-- Executing AgentCallbackLogin("SIP/8002-09696f88", "||8002@from-internal") in new stack
-- Playing 'agent-user' (language 'en')
-- Executing Hangup("SIP/8002-09696f88", "") in new stack

== Spawn extension (macro-agent_login, s, 12) exited non-zero on ‘SIP/8002-09696f88’ in macro ‘agent_login’
== Spawn extension (macro-agent_login, s, 12) exited non-zero on ‘SIP/8002-09696f88’
– Remote UNIX connection disconnected
– Executing Macro(“SIP/8002-095a2658”, “agent_logout|8002”) in new stack
– Executing Set(“SIP/8002-095a2658”, “__agent=”) in new stack
– Executing NoOp(“SIP/8002-095a2658”, "agent ") in new stack
– Executing Set(“SIP/8002-095a2658”, “DB(agent/)=”) in new stack
– Executing UnpauseQueueMember(“SIP/8002-095a2658”, “|Agent/”) in new stack
– Executing Dial(“SIP/8002-095a2658”, “local/logout@macro-agent_logout/n||D(#0##)o”) in new stack
– Called logout@macro-agent_logout/n
– Executing AgentCallbackLogin(“Local/logout@macro-agent_logout-cbb6,2”, “”) in new stack
– Playing ‘agent-user’ (language ‘en’)
– Local/logout@macro-agent_logout-cbb6,1 answered SIP/8002-095a2658
– Sending DTMF ‘#0##’ to the called party.
– Playing ‘agent-incorrect’ (language ‘en’)
– Playing ‘agent-incorrect’ (language ‘en’)
– Executing Hangup(“Local/logout@macro-agent_logout-cbb6,2”, “”) in new stack
== Spawn extension (macro-agent_logout, logout, 2) exited non-zero on ‘Local/logout@macro-agent_logout-cbb6,2’
== Spawn extension (macro-agent_logout, s, 5) exited non-zero on ‘SIP/8002-095a2658’ in macro ‘agent_logout’
== Spawn extension (macro-agent_logout, s, 5) exited non-zero on ‘SIP/8002-095a2658’

Another funny thing is that I always have to press hold on after a call was established and then release the hold - that’s when i’m asked to enter my agent number and password. The same goes when I try to log off. Does anyone have a clue on this?

3

Please, anyone who knows how to do this, please respond. Everything, except for agent logins, are working. We’re using Asterisk 1.2.30 our test machine with MySQL on another server (Fedora Core 8), and it still wouldn’t work with 1.2.18. Our production server is using Asterisk 1.2.18 with MySQL integrated on the same production server, which works fine.

Thanks

4

We’re using FreePBX, which is the reason why we’re not using Realtime-static. Any help is greatly appreciated. Thanks!