[Xastir] Xastir => Mysql

[Alex Carver]

In the wiki it does say to edit the db_gis_mysql.sql file but it doesn't mention more than adding an SQL interface.  I would hazard a guess that if your copy of Xastir has not been compiled using the --with-mysql flag then it won't show that interface.  Double check that your copy was compiled with MySQL support.

--- 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:51 PM
> ok I guess its the "Networked
> Database (Not Implemented Yet)". I saw that
> and thought it might be, but the settings don't include the
> user, only
> host,port and pass.
> Mike
> 
> --
> 
> On Sat, Jan 23, 2010 at 11:37 PM, Alex Carver <kf4lvz at yahoo.com>
> wrote:
> 
> > 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
> > >
> >
> >
> >
> > _______________________________________________
> > 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
>