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 asteriskuser@localhost IDENTIFIED BY ‘amp109’” ; i changed localhost to 192.168.0.110
mysql -vv -e “GRANT ALL PRIVILEGES ON asterisk.* TO asteriskuser@localhost 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)