X-Original-To: alpine-devel@lists.alpinelinux.org Delivered-To: alpine-devel@lists.alpinelinux.org Received: from mail-ww0-f54.google.com (mail-ww0-f54.google.com [74.125.82.54]) by lists.alpinelinux.org (Postfix) with ESMTP id 8D07B1EB598 for ; Wed, 12 May 2010 15:45:12 +0000 (UTC) Received: by wwd20 with SMTP id 20so126689wwd.13 for ; Wed, 12 May 2010 08:45:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=+UrLgJRE3fOAncYD7rsIMolWsYeEwGivqI2HIyFd5zo=; b=tHTou9sicB7gcbVRutcgN5RM2NOy6WFjIcTpgFL7OTA4mFFgdeJo0HnrV9KvqgxNk5 QtqIVIaQ6gRYs4L3hyMAbiUFrMfHWtnaTbSbFNwcNVr0VXxiEO3jPw64g8mpCgLvihxC 0JtzLnQLt4iSj8oz3qpy7okMnAnulc55sj5o8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=Buef5HrE+30DBRaDJili36De/HrnlrHnhAW5+7wg9MeCyTybBYGvecS6GSo7U0qgVw v6bFgKL4sA/bXl8ydOclM38sxjtVsAp5D1OyIwbedtzbVXa/Km0fhx4AGtZ3V6Rye410 8pfbdbM4Z9mD2gyK9g2ShkQW9ijYPhCnBq1qo= X-Mailinglist: alpine-devel Precedence: list List-Id: Alpine Development List-Unsubscribe: List-Post: List-Help: List-Subscribe: MIME-Version: 1.0 Received: by 10.227.136.3 with SMTP id p3mr6973643wbt.21.1273679111154; Wed, 12 May 2010 08:45:11 -0700 (PDT) Received: by 10.216.181.196 with HTTP; Wed, 12 May 2010 08:45:10 -0700 (PDT) In-Reply-To: <1886453988.383791272657176485.JavaMail.osg@osgjas04.cns.ufl.edu> References: <1886453988.383791272657176485.JavaMail.osg@osgjas04.cns.ufl.edu> Date: Wed, 12 May 2010 17:45:10 +0200 Message-ID: Subject: Re: [alpine-devel] Re: help: freepbx install on alpine linux From: Carlo Landmeter To: Kenny Aral Cc: Harry Lachanas , Alpine-devel Developers Content-Type: text/plain; charset=ISO-8859-1 Hi, There were some issues in AlpineLinux which prevented a clean/nice install of FreePBX. I think I've fixed most of those issues in edge repo and have created a wiki doc on how to setup FreePBX on AlpineLinux http://wiki.alpinelinux.org/wiki/Freepbx_on_AlpineLinux This is just a rough cp doc, if anyone wants to improve it go ahead. carlo On Fri, Apr 30, 2010 at 9:52 PM, Kenny Aral wrote: > Sorry about that. Try this link: > http://docs.google.com/fileview?id=0B7wCC8VkuTlvNWY0NzgzYjctYmYyMC00MzVjLWFjMzctZjE1Y2ZlNDk0ZmNh&hl=en > > On Fri Apr 30 07:39:47 EDT 2010, Carlo Landmeter > wrote: > >> Glad you managed to make it work. I tried to view your document but >> the Google link doesn't work for me. >> >> Carlo >> >> On Thu, Apr 29, 2010 at 9:49 PM, Kenny Aral wrote: >>> >>> I would like to thank all of you for your help with this project. I >>> really >>> appreciate the time you took to provide helpful suggestions to the >>> problems >>> I was having. I have completed the installation and I now have a working >>> web >>> server with FreePBX and Asterisk installed on Alpine Linux. I will work >>> on >>> putting my installation procedure on the Alpine Linux Wiki, but if you >>> are >>> interested, you can read the paper I wrote for this project here: >>> >>> https://docs.google.com/fileview?id=0B7wCC8VkuTlvNWY0NzgzYjctYmYyMC00MzVjLWFjMzctZjE1Y2ZlNDk0ZmNh&hl=en >>> >>> The final solution to the most recent problem that I was having with the >>> MySQL database connection was to use a UNIX socket connection instead of >>> TCP. To do this, I had to designate the host as >>> unix(/var/run/mysqld/mysqld.sock). >>> >>> On Mon Apr 26 02:12:30 EDT 2010, Harry Lachanas >>> wrote: >>> >>>> Kenny Aral wrote: >>>>> >>>>> Thanks for the suggestion, Harry. That corrected the error I was >>>>> getting. >>>>> However, now I am getting a new error that I've spent the whole day >>>>> trying >>>>> to fix. I have created the MySQL databases called asterisk and >>>>> asteriskcdrdb. I granted all privileges using: >>>>> >>>>> mysql> grant all privileges on asterisk.* to asteriskuser@localhost >>>>> identified by 'amp109'; >>>>> mysql> grant all privileges on asteriskcdrdb.* to >>>>> asteriskuser@localhost >>>>> identified by 'amp109'; >>>>> mysql> flush privileges; >>>>> >>>>> When I run the script the output is: >>>>> >>>>> # ./install_amp >>>>> ... >>>>> ... >>>>> Connecting to database..FAILED >>>>> DB Error: connect failed, [nativecode=No such file or directory] ** >>>>> mysql://asteriskuser:amp109@localhost/asterisk >>>>> Try running ./install_amp --username=user -password=pass >>>>> [FATAL] Cannot connect to database >>>>> >>>>> I don't understand why its giving me a "no such file" error when the >>>>> database definitely exists. If I change the IP address from 'localhost' >>>>> to >>>>> the actually IP address of the server I am running '192.168.1.114' the >>>>> output is: >>>>> >>>>> # ./install_amp >>>>> ... >>>>> ... >>>>> Connecting to database..FAILED >>>>> DB Error: connect failed, [nativecode=Connection refused] ** >>>>> mysql://asteriskuser:amp109@192.168.1.114/asterisk >>>>> Try running ./install_amp --username=user -password=pass >>>>> [FATAL] Cannot connect to database >>>>> >>>>> This time I get "Connection refused." I have tried running the script >>>>> with --skip networking uncommented/commented in /etc/mysql/my.cnf with >>>>> no >>>>> success. At this point I'm stumped as to why its not working. This is >>>>> the >>>>> very last part of the installation too. >>>>> >>>>> On Fri Apr 23 02:27:55 EDT 2010, Harry Lachanas >>>>> wrote: >>>> >>>> grant all privileges on asterisk.* to asteriskuser@localhost identified >>>> by >>>> 'amp109'; >>>> >>>> with this statement you allow asteriskuser to connect to database only >>>> from local host ( 127.0.0.1) >>>> >>>> try to place the ip address of the alpine box you have asterisk running >>>> ... >>>> >>>> that is on mysql server >>>> grant all privileges on asterisk.* to asteriskuser@ALPINE_IP_ADDRESS >>>> identified by 'amp109'; >>>> >>>> or any host >>>> 'asteriskuser'@'%' >>>> >>>> Can you connect from a remote box to your mysql server from lan ??? >>>> >>>> Make sure that you can, and proceed .. >>>> >>>> Cheers >>>> You R almost done . >>>> >>>> >>>> >>>> >>> >>> >>> >>> -- >>> ARAL,KENNY A >>> >>> >>> >>> --- >>> Unsubscribe: ??alpine-devel+unsubscribe@lists.alpinelinux.org >>> Help: ?? ?? ?? ?? alpine-devel+help@lists.alpinelinux.org >>> --- >>> >>> >> >> > > > > -- > ARAL,KENNY A > > --- Unsubscribe: alpine-devel+unsubscribe@lists.alpinelinux.org Help: alpine-devel+help@lists.alpinelinux.org ---