[Xastir] Xastir => Mysql

[Alex Carver]

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
>