[Xastir] Xastir => Mysql

[Mike L]

Yes I recompiled it with that phrase. I am using a version of
xastir(1.9.7)/Kubuntu(9.10) from a disk image. So xastir was basically
installed with the os.
MIke
--

On Sat, Jan 23, 2010 at 11:55 PM, Alex Carver <kf4lvz at yahoo.com> wrote:

> 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
> >
>
>
>
> _______________________________________________
> Xastir mailing list
> Xastir at lists.xastir.org
> http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
>