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:content-transfer-encoding;
        b=ZJREXhU0pMR9UMMB1HZbl8OsHtqNE3bPG4ifdK9CM2EQdNNbYTbdLVDTz9ExpeveCM
         EcXCPUIIHsi8UqPPNcoYTdUHpdz7KymLPHsNKfY/h2HIVd2cfy9m02xk34a2JW5ezsVg
         I7ZemLnc5GD/pT60TxoA5OHCd5R3oik8W9/qk=
Precedence: list
MIME-Version: 1.0
In-Reply-To: <453083326.332401272570591209.JavaMail.osg@osgjas04.cns.ufl.edu>
References: <453083326.332401272570591209.JavaMail.osg@osgjas04.cns.ufl.edu>
Date: Fri, 30 Apr 2010 13:39:47 +0200
Message-ID: <z2o1b2623ac1004300439i734cfaafiaeead9a0add993fe@mail.gmail.com>
Subject: Re: [alpine-devel] Re: help: freepbx install on alpine linux
From: Carlo Landmeter <clandmeter@gmail.com>
To: Kenny Aral <oggyk22@ufl.edu>
Cc: Harry Lachanas <grharry@freemail.gr>, 
	Alpine-devel Developers <alpine-devel@lists.alpinelinux.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 <oggyk22@ufl.edu> wrote:
> I would like to thank all of you for your help with this project. I reall=
y
> appreciate the time you took to provide helpful suggestions to the proble=
ms
> 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 o=
n
> putting my installation procedure on the Alpine Linux Wiki, but if you ar=
e
> interested, you can read the paper I wrote for this project here:
> https://docs.google.com/fileview?id=3D0B7wCC8VkuTlvNWY0NzgzYjctYmYyMC00Mz=
VjLWFjMzctZjE1Y2ZlNDk0ZmNh&hl=3Den
>
> 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 <grharry@freemail.gr> wro=
te:
>
>> Kenny Aral wrote:
>>>
>>> Thanks for the suggestion, Harry. That corrected the error I was gettin=
g.
>>> However, now I am getting a new error that I've spent the whole day try=
ing
>>> 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@localhos=
t
>>> 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=3DNo such file or directory] **
>>> mysql://asteriskuser:amp109@localhost/asterisk
>>> Try running ./install_amp --username=3Duser -password=3Dpass
>>> [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=3DConnection refused] **
>>> mysql://asteriskuser:amp109@192.168.1.114/asterisk
>>> Try running ./install_amp --username=3Duser -password=3Dpass
>>> [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 t=
he
>>> very last part of the installation too.
>>>
>>> On Fri Apr 23 02:27:55 EDT 2010, Harry Lachanas <grharry@freemail.gr>
>>> 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: =A0alpine-devel+unsubscribe@lists.alpinelinux.org
> Help: =A0 =A0 =A0 =A0 alpine-devel+help@lists.alpinelinux.org
> ---
>
>


---
Unsubscribe:  alpine-devel+unsubscribe@lists.alpinelinux.org
Help:         alpine-devel+help@lists.alpinelinux.org
---