[Fiware-lab-help] [Blueprints] mysql authentication

[luigi.papino at gmail.com]

Yes, now it works both on localhost and remote.

However, the machine didn't execute php script, just print out the code in
the browser. I removed and reinstalled php and php-devel and it works fine
now.

Thank You!
Luigi


On 30 January 2014 15:43, HENAR MUÑOZ FRUTOS <henar at tid.es> wrote:

>  Hi
>
>
> Yes, you are right. Can you have a look now?
>
> Thanks for your feedback,
>
> Regards,
>
> Henar
>
>
>
> *De:* luigi.papino at gmail.com [mailto:luigi.papino at gmail.com]
> *Enviado el:* jueves, 30 de enero de 2014 15:27
> *Para:* HENAR MUÑOZ FRUTOS
> *CC:* fiware-lab-help at lists.fi-ware.eu; Ivan Paudice; Ottavio Sgrosso
> *Asunto:* Re: [Fiware-lab-help] [Blueprints] mysql authentication
>
>
>
> It works well from localhost, but doesn't work from public ip
>
>
> LOCALHOST:
>
> [root at appetitoomain-mainserver-1 ~]# mysql -u root -pmysql321go
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 16
> Server version: 5.1.71-log Source distribution
> mysql> quit
> Bye
>
>
>
> PUBLIC IP: (reamin in waiting status for a lot of time)
>
>  nietzsche at nietzsche-Extensa-5635Z:~$ mysql -u root -h 130.206.82.35
> -pmysql321go
>
>  ERROR 2003 (HY000): Can't connect to MySQL server on '130.206.82.35'
> (110)
>
>
>
> On 30 January 2014 14:54, HENAR MUÑOZ FRUTOS <henar at tid.es> wrote:
>
> Hi again
>
> The mysql installed and configured with recipes have the root user with
> the password mysql321go. You cannot access from localhost. It is configured
> to be accessible from outside. Can you try to do the following?
>
> mysql -u root -h PUBLIC_IP -p
>
> (where the password is mysql321go).
>
> Please tell me if this works for you.
>
> Thanks for your feedback,
>
> Regards,
>
> Henar
>
>
>
> *De:* fiware-lab-help-bounces at lists.fi-ware.eu [m
> ailto:fiware-lab-help-bounces at lists.fi-ware.eu] *En nombre de *
> luigi.papino at gmail.com
> *Enviado el:* jueves, 30 de enero de 2014 10:55
> *Para:* fiware-lab-help at lists.fi-ware.eu
> *CC:* Ivan Paudice; Ottavio Sgrosso
> *Asunto:* [Fiware-lab-help] [Blueprints] mysql authentication
>
>
>
> Hi, sorry to trouble again and take advantage of your patience. But I have
> very little time to finish the project for the FI-WARE 800k Challenge and I
> lack some knowledge.
>
>
>
> I launched an instance of my template blueprints, which also contains
> mysql. Trying to access the mysql console, or set the root password, I get
> the following error:
>
>
>
>  [root at appetitoomain-mainserver-1 ~]# mysql
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
> [root at appetitoomain-mainserver-1 ~]# mysql -u root -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
>
>
>
>
>
> What should be the proper way to authenticate to mysql, perhaps through
> phpmyadmin, in the default installation provided in blueprints?
>
>
>
> Really, really thanks!
> Luigi
>
>
>  ------------------------------
>
>
> Este mensaje se dirige exclusivamente a su destinatario. Puede consultar
> nuestra política de envío y recepción de correo electrónico en el enlace
> situado más abajo.
> This message is intended exclusively for its addressee. We only send and
> receive email on the basis of the terms set out at:
> http://www.tid.es/ES/PAGINAS/disclaimer.aspx
>
>
>
> ------------------------------
>
> Este mensaje se dirige exclusivamente a su destinatario. Puede consultar
> nuestra política de envío y recepción de correo electrónico en el enlace
> situado más abajo.
> This message is intended exclusively for its addressee. We only send and
> receive email on the basis of the terms set out at:
> http://www.tid.es/ES/PAGINAS/disclaimer.aspx
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-lab-help/attachments/20140130/e9d36e18/attachment.html>