[Xastir] Xastir => Mysql

[Mike L]

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
>