Page 1 of 1

SUBPHASE 6.1: creating the MySQL "asterisk" databa

PostPosted: Thu Aug 03, 2006 3:45 pm
by D
Hi,

We are on SUBPHASE 6.1 section 2: creating the MySQL "asterisk" database:

2. type the following into the mysql client prompt:
(make sure you put your IP address in place of "10.10.10.15" in the queries below)

Do we need to enter the IP of our machine that's thru LAN (machine has been assigned an internal IP for LAN) or should we enter our actual external IP here?

Thanks

PostPosted: Thu Aug 03, 2006 3:56 pm
by marvin
if you will be accessing it locally/internally i guess u should use the local/internal address

PostPosted: Thu Aug 03, 2006 4:03 pm
by D
We will be will be accessing it locally/internally and from the outside/externally. In that case, which IP should we use?

Thanks

PostPosted: Thu Aug 03, 2006 4:03 pm
by mflorell
Yes you should always use the internal LAN if there is one. This is the address that other vicidial or database servers would see that server from. If you only have one machine for everything it's not as important what you put in that field.

PostPosted: Thu Aug 03, 2006 4:06 pm
by D
Hi Matt,

Our SQL databse is housed on an external webserver - what do suggest in that case.

Thanks

PostPosted: Thu Aug 03, 2006 4:20 pm
by mflorell
Not really sure, would you describe your network setup a little more?

VICIDIAL with many agents uses a lot of database resources and having all of that data go through a firewall might not be the most efficient or fastest way of setting this up. It should work just fine since the VICIDIAL server connects to the database, not the other way around.

PostPosted: Thu Aug 03, 2006 4:51 pm
by D
Our agents are going to be on the LAN and some other agents will also be dialing in from outside/external.

Our SQL database is on a webserver - the leads will be supplied to the dialer by this external server. What do u suggest in this case - use external ip or internal one?

Thanks

PostPosted: Thu Aug 03, 2006 5:00 pm
by mflorell
You should be able to use internal for the server_ip variables.