mySQL data base Help needed

[WyattEarp]

Hey Hey,

Here is what I have going, I own a internet radio station.and we use the powweb as our
site with the use of html for the playlist, how ever with the PHP we can also take dedication's but for this to happen the DJ tool sams has to connect to the data base and it gives you all the info but the port number to use also I like to know how many users per data base is allowed.. Thanks in advance for your help

[BerksWebGuy]

It sounds like you are talking about a remote connection...which is when you are trying to access a powweb mysql server outside of powweb (you must be within the powweb realm to access the mysql servers).

Remote connections are not allowed. On another note, you can have up to 3 users.

[mitchind]

All you need is a web browser (and php code) to connect to your Powweb database.

You're not limited to a specific number of users that can connect to the database at any one time - you're limited by bandwidth and I/O - which shouldn't be a problem in your case (if I understand what you're asking for).

What BWG is referring to is the number of users that can be defined as login users for your database - your PHP pages can use any or all of these users for multiple people to access your database - and they'll never know what user is being connected to it.

[WyattEarp]

Ok on the DJ tool Sams it connects to mySQL to run the playlist what this does is loads the playlist and takes in the request from the web site to the dj tool as in the html site
the mySQL used to run the tool is the one i downloaded with the tool mySQL 3.1 however to put 15 DJs on the site I need a database and we could use the one on each pc however that isnt as good and dependable as a webserver mySQL as you can understand so my DJ tool would ask for mySQL host , username pass and port # by default the tool uses localhost port 3306 user root password none and it connects and it auto loads the songs thats playing on air and so on, now thats what we want to do witrh the php which we cna do alot more with but need mySQL to do so with a database to log into you can see my site I am working on it needed to its at http://www.WildSideRadio.com/Playlist/DJ_WILD the html one you cna lok at as well is at http://www.WildSideRadio.com/DJ_WILD I want to make the php one do the same as the html one but with php we can take in live dedication's , by the listener typing in the request box who its from and who its to, if this makes sense to you lol its a radio thingy

if powweb will not lalow this then I am wasting my money with the package and do you know, another web server that would allow it so I can change to them ? cause my DJ tool has to connect to the mySQL database per DJ

[mitchind]

That's one long sentence ... making it very hard to understand .. but if I read all those words right ...

As long as the DJ tool in installed on your website, then yes - you can connect to your mysql database. Of course you'll need to set it up first in Member Ops.

Then - instead of localhost, use mysql##.powweb.com (matching the server that is in your Member Ops page after you create the database). Though you didn't mention it, you should also have to specify the name of the database you created.

[WyattEarp]

Sorry, the dj tool isnt on the web site but on desktop , it is a program you open and use like PSP or Winamp and it plays the music and you talk over it.
But you pretty much right on the on the set up of the mySQL and yes I did that all but, the program needs a port # to connect threw, as in mySQl on your desktop by default is on port 3306. I need the port # that my mySQL data base in powweb is on to make the 2 connect.

So far all the info I have is host name - mysql#.powweb.com the user name, the password and database name now I need the port number

[mitchind]

You can't connect remotely to Powweb's MySQL servers from your desktop software.
No settings you try will work. You need a different host for that.

As well it sounds like you want your web server to stream or serve up music/mp3/audio files. I doubt you'll find any shared hosting provider willing to do that for you on a 24 hour basis. You'll be grabbing all the cpu and bandwidth - incoming and outgoing!

Good luck on your search! I'd recommend a dedicated server - and some way to generate revenue!

[WyattEarp]

No not at all, I have a stream server, I am just trying to get the playlist working in php .
The mySQL for the DJ tool has nothing to do with the stream, we have encoders and stream server running threw shoutcast for that.
I am just trying to work the playlist in php format without using the mySQL on the computer, the problem with using the mySQL on each DJ's person computer is if their computer is turned off, thier playlist will not show up as for it needs mySQL to work.

[mitchind]

It still goes back to where the DJ tool is going to run - if it's a PC desktop app - then you can't connect to Powweb's database server. If it's a PHP app that can run from Powweb's server, then your DJs can access it from the web browser on their desktop.

Hope that's clear and helps you out on your decision.