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 <[email protected]> wrote: > From: Mike L <[email protected]> > Subject: Re: [Xastir] Xastir => Mysql > To: "Xastir - APRS client software discussion" <[email protected]> > 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 <[email protected]> > 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 <[email protected]> > wrote: > > > > > From: Mike L <[email protected]> > > > Subject: Re: [Xastir] Xastir => Mysql > > > To: "Xastir - APRS client software discussion" > <[email protected]> > > > 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 > <[email protected]> > > > 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 <[email protected]> > > > wrote: > > > > > > > > > From: Mike <[email protected]> > > > > > Subject: [Xastir] Xastir => Mysql > > > > > To: [email protected] > > > > > 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 > > > > > [email protected] > > > > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > Xastir mailing list > > > > [email protected] > > > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir > > > > > > > _______________________________________________ > > > Xastir mailing list > > > [email protected] > > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir > > > > > > > > > > > _______________________________________________ > > Xastir mailing list > > [email protected] > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir > > > _______________________________________________ > Xastir mailing list > [email protected] > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir > _______________________________________________ Xastir mailing list [email protected] http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
