[ixpmanager] Failed when running perl 'compare-route-server-prefix.pl'

[Mokhamad Nizar Z]

Thanks a lot i will try it now

On Fri, Nov 30, 2018, 4:12 PM Barry O'Donovan <barry.odonovan at inex.ie wrote:

> Hi Mokhamad,
>
> Mokhamad Nizar Z wrote on 30/11/2018 06:40:
> > Hello today i'm facing problem again when i run perl script
> > 'compare-route-server-prefix.pl
> > <http://compare-route-server-prefix.pl>'. I run that script on Server
> > Running Bird, so it's separated with Server Running IXP-Manager.
>
> Okay, different server to where MySQL is also then.
>
> > The  error showed this "DBI
> >
> connect('database=ixp;host=localhost;port=/var/run/mysqld/mysqld.sock'','root',...)
>
>
> > This is my ixpmanager.conf configuration
> > "
> >
> > <sql>
> >          dbase_type      = mysql
> >          dbase_database  = ixp
> >          dbase_username  = root
> >          dbase_password  = **188**
> >          dbase_hostname  = localhost
>
> So the issue is 'localhost'. You need to:
>
> a) replace this with the IP / hostname of the IXP Manager instance where
> I assume MySQL is running
>
> b) ensure MySQL is listening on tcp/3306 and not firewalled / firewalled
> so as to allow access from your Bird server
>
> c) that the MySQL user has permissions to access the database from the
> Bird server.
>
> [side note: using the 'root' user in MySQL is not advised - you should
> create a dedicated user for this]
>
>   - Barry
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20181130/5ee51c4e/attachment.html>