Thanks for the info James Do you know what the 127 error code is when generating the reports?
Bill Curd Hope Radio Online 270/589/1737 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Spacial Sent: Saturday, September 29, 2007 10:12 PM To: 'Dj Liqid Touch'; [email protected] Subject: RE: [General-discussion] Reports errors The file he is asking about is actually located in the reports folder on your hard drive; this one is not accessible by anyone other than those on your internal network or yourself. When creating a website it is best to create a new user with only the needed privileges to work for SAM. We have a knowledge base article covering this. The one in the reporter folder is not accessible via the internet. In addition, SAM uses the root user by default, however you are free to change the password and supply SAM with that during installation. James Henline. Help Desk Manager Development Manager Spacial Audio Solutions LLC. 972-739-6420 ext: 110 www.audiorealm.com www.spacialnet.com www.spacialaudio.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dj Liqid Touch Sent: Saturday, September 29, 2007 10:11 PM To: [email protected]; [email protected] Subject: Re: [General-discussion] Reports errors 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' _______________________________________________ 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'
