[Xastir] Xastir => Mysql

[Alex Carver]

I haven't looked at the latest version of Xastir yet but it should be present in the interface configuration window when you create the MySQL interface.  If it's not there then it would likely show up in the xastir.cnf file

--- On Sat, 1/23/10, Mike L <w2swrster at gmail.com> wrote:

> From: Mike L <w2swrster at gmail.com>
> Subject: Re: [Xastir] Xastir => Mysql
> To: "Xastir - APRS client software discussion" <xastir at lists.xastir.org>
> Date: Saturday, January 23, 2010, 11:14 PM
> Hi Alex,
> Tnx for the reply. I have a user and pass setup in MySQL
> but where do I set
> those parameters up in xastir?
> Mike
> --
> 
> On Sat, Jan 23, 2010 at 8:15 PM, Alex Carver <kf4lvz at yahoo.com>
> wrote:
> 
> > The username and password it talks about is the one
> you add to MySQL.  You
> > need to put in a user that Xastir will use when
> connecting to the MySQL
> > server and give it the appropriate permissions as
> dictated by the "user"
> > table in the "mysql" database.  By default MySQL
> sets up "root" as a user.
> >  You can use that account to test things out
> first and then later make a
> > separate user for Xastir.  In general it's a good
> idea (especially when
> > using PHP and MySQL) to create users that have limited
> database access
> > instead of the root superuser just as it is with Linux
> machines and user
> > accounts versus root.
> >
> > --- On Sat, 1/23/10, Mike <w2swrster at gmail.com>
> wrote:
> >
> > > From: Mike <w2swrster at gmail.com>
> > > Subject: [Xastir] Xastir => Mysql
> > > To: Xastir at lists.xastir.org
> > > Date: Saturday, January 23, 2010, 6:03 PM
> > > Hi All,
> > >
> > > I am knee deep in trying to get data collected
> from Xastir
> > > to MySQL. I have MySQL 5.1.37 and PHP 5.2.10
> installed with
> > > Xastir 1.9.7.  I have followed the MySQL
> Persistence
> > > directions [http://www.xastir.org/wiki/index.php/Persistence]
> > > closely with the execption of using the included
> sql dump
> > > (db_gis_postgis.sql) which has a lot of syntax
> errors no
> > > matter  which SQL compatibility mode I use.
> So I
> > > built the databases and tables manually using the
> SQL dump
> > > as a road map. With that said, I can only say
> that I am 90%
> > > sure I did them all correctly. What I havn't done
> so far is
> > > (and I quote): "Run xastir and add a SQL Database
> interface,
> > > start with the MySQL defaults, add the username
> and password
> > > of the xastir user." This I am not too sure what
> Im being
> > > told to do here. I am a newbe to PHP and MySQL
> ive only used
> > > them for some small web related stuff as a user
> and never on
> > > a dev end of it, but I have my nose deep into PHP
> &
> > > MySQL for Dummies and I am slowly learning.
> > >
> > > If anyone can help, I would deeply appreciate
> it.
> > >
> > > Mike, W2SWR
> > >
> > > P.S. if it helps, I use phpMyAdmin to drive
> MySQL
> > > _______________________________________________
> > > Xastir mailing list
> > > Xastir at lists.xastir.org
> > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> > >
> >
> >
> >
> > _______________________________________________
> > Xastir mailing list
> > Xastir at lists.xastir.org
> > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> >
> _______________________________________________
> Xastir mailing list
> Xastir at lists.xastir.org
> http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
>