if i am understanding your setup its different then mine however yes dbconfig.xml.php is accessable on the net but not via SAM its one of the samPHPweb files you upload to your server it contains the proper script to allow SQL communication that takes place on port 3306
that file nees A) the username that you setup in MySQL Administrator (not root) b) the users password C) your network IP address D) the exact name for your sam db ( SAMDB or samdb ) whatever you called it upon setup Again this is how i am using it to handle requests. Its the most basic way. here is a copy of one <?/* <CONFIG application="SAM"version="4.2.2"> <Database> <Driver>MYSQL</Driver> <Host>yournetwork IP address</Host> <Port>3306</Port> <Database>SAMDB</Database> <Username>extra user name in mysql administrator</Username> <Password>the above users password</Password> </Database> </CONFIG> */?> ----- Original Message ----- From: Bill Curd To: [email protected] ; [email protected] Sent: Saturday, September 29, 2007 9:43 PM Subject: RE: [General-discussion] Reports errors I figured it out! Located in the SAMReporter/htdocs/ folder. This file dbconfig.xml.php is the one that needed my MySql password. I have noticed that Sam does not prompt you and ask if you want to set a password on setup unless in a custom setup, I think this would be considered a security flaw/breach but just for me I prefer to have passwords set when the root user is used so much by SAM. Is this file accessible from the internet in anyway via Sam? I am pretty sure it is not but just wanted to know for sure.... Bill Curd Hope Radio Online www.hoperadio.us 270-589-1737 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Curd Sent: Saturday, September 29, 2007 8:30 PM To: [email protected] Subject: [General-discussion] Reports errors I am getting this error when attempting to look at a requests report status=err SQL error=Could not connect to MySQL server Bill Curd Hope Radio Online 270-589-1737 _______________________________________________ General-discussion mailing list [email protected] http://mailman.spacialaudio.com/mailman/listinfo/general-discussion TO unsubscribe to this list, simply send a blank email to [email protected] with the subject 'unsubscribe' _______________________________________________ General-discussion mailing list [email protected] http://mailman.spacialaudio.com/mailman/listinfo/general-discussion TO unsubscribe to this list, simply send a blank email to [email protected] with the subject 'unsubscribe'
