[Xastir] Xastir => Mysql

Alex Carver kf4lvz at yahoo.com
Sun Jan 24 02:06:38 EST 2010 

You may have used the --with-mysql compiler directive but it may not have compiled support into Xastir if the MySQL development headers and libraries are not installed on the system.  You would have to install the MySQL package as well as the MySQL development package (something like mysql-dev, I don't know what Kubuntu calls it).

--- On Sun, 1/24/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: Sunday, January 24, 2010, 12:01 AM
> 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
> >
> _______________________________________________
> Xastir mailing list
> Xastir at lists.xastir.org
> http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
>

More information about the Xastir mailing list