Installing mysql in different box

Hi all,

I’m trying to setup asterisk and freepbx-2.2.0, can anyone help me how to setup mysql in different box? Im 0 knowledge in mysql.

regards,

john

Hi Alex,

Thank you for your reply, I will try it next week, i cannot access my asterisk box until next week. Actually, I will install new fresh asterisk+freepbx, So my asterisk server is 192.168.0.110 and i installed mysql server on 192.168.0.101. from your info :

AMPDBHOST: the host to connect to the ‘asterisk’ mysql database

AMPDBHOST=192.168.0.101

AMPDBUSER: the user to connect to the ‘asterisk’ mysql database

AMPDBUSER=asteriskuser

AMPDBPASS: the password for AMPDBUSER

AMPDBPASS=amp109

is it right ? and i follow the mysql setup for asterisk+freepbx installation as follow :

cd /usr/src/freepbx ; its in asterisk server
mysqladmin create asterisk ; in mysql server
mysqladmin create asteriskcdrdb ; in mysql server
mysql asterisk < SQL/newinstall.sql ; in mysql server
mysql asteriskcdrdb < SQL/cdr_mysql_table.sql
mysql -vv -e “GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO [email protected] IDENTIFIED BY ‘amp109’” ; i changed localhost to 192.168.0.110
mysql -vv -e “GRANT ALL PRIVILEGES ON asterisk.* TO [email protected] IDENTIFIED BY ‘amp109’” ; i change localhost to 192.168.0.110
mysql -vv -e "flush privileges"
mysqladmin -u root password ‘passw0rd’

cd /usr/src/asterisk-addons ; in asterisk server
cp Makefile Makefile.orig
sed -i ‘s/SOURCE/SOURCE -DMYSQL_LOGUNIQUEID/’ Makefile
make && make install

is it right ? anything else ?

Regards,

john

To point FreePBX to another box, open up /etc/amportal.conf in your favourite text editor, and change the following lines to match your new host:

AMPDBHOST: the host to connect to the ‘asterisk’ mysql database

AMPDBHOST=localhost

AMPDBUSER: the user to connect to the ‘asterisk’ mysql database

AMPDBUSER=asteriskuser

AMPDBPASS: the password for AMPDBUSER

AMPDBPASS=amp109

Now that being said, you most likely ran the install on the local box, so you’ll have to export the FreePBX tables locally and import them on your remote host, but it’s relatively simple if you’ve installed phpMyAdmin (or any other MySQL GUI).

Alex

On 12/9/06, john30 <[email protected] ([email protected])> wrote:[quote] Hi all,

I’m trying to setup asterisk and freepbx-2.2.0, can anyone help me how to setup mysql in different box? Im 0 knowledge in mysql.

regards,

john

-------------------- m2f --------------------

Sent using Mail2Forum (http://www.mail2forum.com).

Read this topic online here:
http://www.freepbx.org/forums/viewtopic.php?p=2826#2826

-------------------- m2f --------------------


Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net 's Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV


Amportal-users mailing list
[email protected] ([email protected])
https://lists.sourceforge.net/lists/listinfo/amportal-users
[/quote]


Alex Robar
[email protected] ([email protected])

Post generated using Mail2Forum (http://www.mail2forum.com)