Skip to Content
It is currently February 22nd, 2018, 12:51 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 9 posts ] 
Author Message
PostPosted: November 16th, 2008, 8:45 pm 
Offline
Experienced User
Experienced User

Joined: January 8th, 2006, 6:51 pm
Posts: 348
Location: New-Caledonia
I have tried multiple times to configure SAM Reporter and MySQL to be able to browse the database from another PC than the one where SAM is installed.
I haven't been able to do it.
Please offer this possibility so that a Program Director can browse reports via SAM Reporter while DJs are working on SAM computer.


Top
 Profile  
Reply with quote  
PostPosted: November 17th, 2008, 8:03 pm 
Offline
Junior User
Junior User

Joined: October 4th, 2008, 12:35 pm
Posts: 39
Location: Kaufbeuren, Germany
Shouldn’t be much of a problem, though I never tried:

Put the SAMReporter folder and all subfolders onto a PHP-enabled web server (check local php.ini for required settings) that has access to your SAM PC’s mySQL database, change SAMReporter/htdocs/config.local.php and SAMReporter/htdocs/dbconfig.xml.php as needed, and you should be up and running.

And do not allow any mySQL access (esp. not »root«) over the network without a password set!

_________________
Moonbase: The Problem Solver
I will not give any support for unlicensed or pirated software.


Top
 Profile  
Reply with quote  
PostPosted: November 17th, 2008, 8:19 pm 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
Location: Show Low, AZ
...or, if you want to access it from another machine on the same network, just open a browser on the remote machine, enter the IP for the SAM machine w/ the port for reports.

http://SAM-machine-IP:10080

Make sure you have the port open to that machine.

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
Reply with quote  
PostPosted: November 17th, 2008, 8:45 pm 
Offline
Experienced User
Experienced User

Joined: January 8th, 2006, 6:51 pm
Posts: 348
Location: New-Caledonia
Quote:
...or, if you want to access it from another machine on the same network, just open a browser on the remote machine, enter the IP for the SAM machine w/ the port for reports.

http://SAM-machine-IP:10080

Make sure you have the port open to that machine.
Sorry it doesn't work. It was the 1st thing I've tried.
Quote:
Put the SAMReporter folder and all subfolders onto a PHP-enabled web server (check local php.ini for required settings) that has access to your SAM PC’s mySQL database, change SAMReporter/htdocs/config.local.php and SAMReporter/htdocs/dbconfig.xml.php as needed, and you should be up and running.
I've nearly tried that too, but I put the SamReporter files on the Program Director PC.
I'll setup local Web Server to see if it works (I'm not really used to setup a Windows based Web Server, but it shouldn't be too hard)
The last tests I've done are several months back and I haven't kept any trace of these tests.
I'll try again and let you know.

Whatever, thanks Moonbase & WDA1 for your answers ! :D


Top
 Profile  
Reply with quote  
PostPosted: November 17th, 2008, 9:03 pm 
Offline
Alumni
Alumni

Joined: October 14th, 2006, 9:38 am
Posts: 5986
Location: Deep in the heart of the PRNJ
You could always use Windows RDC (terminal services) or VNC and have the PD run the report on the SAM machine. I do it all the time. I output the report file in CSV format, download it to my machine and print.

A word of caution: Reports does not want to work on any port but 10080. I learned this the hard way when I tried to change it to fit into a group of ports I was using for remote access.

_________________
- Stan Olochwoszcz
A proud licensed SAM user since 2002

Raritan Bay Radio


Top
 Profile  
Reply with quote  
PostPosted: November 17th, 2008, 10:58 pm 
Offline
Alumni
Alumni

Joined: October 14th, 2006, 9:38 am
Posts: 5986
Location: Deep in the heart of the PRNJ
You got me curious so I started poking around.

First, it occurs to me that a website needs to speak to the database to do requests and such and there is something in one of SAM's config files that I vaguely remember having to play with to set up the website as a MySQL user. Dipped if I can find it right now, but there's this niggling suspicion that's what needs to be done. This may be what Moonbase was referring to.

I also stumbled on this article that may help (or not):
http://www.madirish.net/?article=139

fwiw

_________________
- Stan Olochwoszcz
A proud licensed SAM user since 2002

Raritan Bay Radio


Top
 Profile  
Reply with quote  
PostPosted: November 18th, 2008, 4:00 am 
Offline
Experienced User
Experienced User

Joined: January 8th, 2006, 6:51 pm
Posts: 348
Location: New-Caledonia
Quote:
You could always use Windows RDC (terminal services) or VNC
This is the way we proceed right now, but what about not being able to control your mouse as a DJ because the Program Director want to see SAMReports ?
Sincerely this isn't possible.
I know how to connect to any SQL database, but I wanted the Program Director to use SAMReporter.
It seems that I'll have to install an EasyPHP on the Program Director workstation and write codes to consult MySQL database.

SAMReporter is doing things fine (just have to modify some codes to suit our needs), I thought it COULD be possible to modify it without having to rewrite a complete PHP code to do the same thing (reason why I posted in Feature Request forum).


Top
 Profile  
Reply with quote  
PostPosted: November 18th, 2008, 7:53 am 
Offline
Alumni
Alumni

Joined: October 14th, 2006, 9:38 am
Posts: 5986
Location: Deep in the heart of the PRNJ
If VNC is set up properly, the DJ and the PD can engage in "mouse wars" grabbing it from each other; I go through that when trying to show my mother stuff remotely. But I see your point.

It would be a useful feature. We're all just trying to offer interim solutions.

_________________
- Stan Olochwoszcz
A proud licensed SAM user since 2002

Raritan Bay Radio


Top
 Profile  
Reply with quote  
PostPosted: November 20th, 2008, 4:46 am 
Offline
Experienced User
Experienced User

Joined: January 8th, 2006, 6:51 pm
Posts: 348
Location: New-Caledonia
Quote:
the DJ and the PD can engage in "mouse wars" grabbing it from each other
This is exactly what happens and what isn't pleasant at all for the DJ ...
But I'm trying the Moonbase thing (to put SAMReporter on a local Webserver).
I'll you know for sure ;)


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group