[millenium.dare]

@Haggis - If you have phpMyadmin running on your webserver, once you create Jukebox's database, select that database and then use the "Import" tab. Browse for the location of the .sql files and select the one which corresponds with the version of Jukebox you are running.

@SirLamer, thanks for that, I misread the documentation.

I've almost got this working, but when I launch the source server, it gives me quite a few errors relating to the mySQL db. I'm running mySQL 4.1.22.

[IMG]http://img121.**************/img121/6284/49617845.jpg[/IMG]

Here is jukebox.cfg:

// URL path to Jukebox's base folder.
// -
// Default: ""
jb_base_url "http://www.dhabedank.org/jukebox"

// Named SQL connection to be used by Jukebox.  Database must be defined within sourcemod/configs/database.cfg
// -
// Default: "default"
jb_db_conn_name "localhost"

and the databases.cfg:

"Databases"
{
    "driver_default"        "mysql"
    
    "default"
    {
        "driver"            "default"
        "host"              "174.120.152.66"
        "database"        "dhabedan_jukebox"
        "user"               "dhabedan_jukebox"
        "pass"               "********"
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}

[SirLamer]

@ zerosin:

Attached is an alternate security.php. It basically the same, it just uses some different syntax, since it seems to be confusing your parser. Let me know if this works better for you.

@ farmerbill256:

Oh okay I understand. I want to add HTTP uploading, too. I set it up for FTP uploading to start because I knew that would enjoy more universal support. Many web hosts place restrictions on web form uploading that makes uploading large sets of files hard to do.

@ haggis:

Use the latest script version, 0.5.1.0. When I release new Jukebox versions that use the same SQL database as the last, I don't bother changing the version name on the script so that people don't end up with a whole bunch of identical SQL scripts with different file names when upgrading. I guess I should make that clearer.

@ millenium.dare:

The error "access denied for ..." means that it rejected your login credentials. It's really up to you to verify that they're correct. However, I see that your jb_db_conn_name is "localhost" when you don't have a connection named localhost. So it looks like it's using the "default" one as a backup, except the IP address in the attached databases.cfg doesn't match the one in the error report. Remember that jb_db_conn_name should be the name of the connection you want to use from databases.cfg (ie. "default", "my_jukebox_connection", etc.) and NOT the host address. Also don't forget that, by default, MySQL will set up itself to only allow connections from "localhost", that is, from the machine that the server itself is running on. If you are running your own SQL server, you need to grant the connection account you are using permissions to connect from your game server's IP address. If you are renting a game server and web server package, your host will have already set up the SQL database to be allowed to remotely connect from the game server. If you are renting a website separately from the game server, the website host will have set up the SQL database for "localhost" connections only and won't let you remotely connect to the database.

The SQL server should at least be on the same LAN as the game server. Connections over the Internet are generally much too slow for SQL transactions and you'll find Jukebox performance to be sluggish, though it will still work.

[BrutalGoerge]

hey the songs won't play for me, but they do for other people.

might i suggest use a flash mp3 player, or some other web-based player?

[Sir Jake]

I don't think flash is supported very well in Steam.
At least the music player I'm using does not work right for everyone.
I'll give this a try later.

[BrutalGoerge]

i used the odeo flash player for my motd music stuff, it seemed to have a higher success rate than win media

[millenium.dare]

Hello SirLamer!

I've managed to fix most of my errors and things seem to be running smoothly now. I can access the control panel in game and select songs from my collection. The song shows that it's playing but there is no sound. I had a buddy get into the server and he had the same problem. I get two errors but I'm not sure if they are the cause:


[IMG]http://img255.**************/img255/6738/95949975.jpg[/IMG]


I have defined the password in both locations but it isn't recognized. In addition, I believe I have properly declared where the base_url is.

// URL path to Jukebox's base folder.
// -
// Default: ""
jb_base_url "http://www.dhabedank.org/jukebox/"

// Named SQL connection to be used by Jukebox.  Database must be defined within sourcemod/configs/database.cfg
// -
// Default: "default"
jb_db_conn_name "default"
//
// Anti-leech password used to timestamp produced URLs.  Must match the leech password specified on the web server.
// -
// Default: ""
jb_leech_password "leechpass"

// The encryption key used for leech protection.  This value must be the same as the encryption key provided to the Jukebox server script.  It is highly recommended that you change this value from the default.
$leech_pass = 'leechpass';

Edit: I tried again and Jukebox seems to be working quite well. Thanks for all your help, SirLamer!

[SirLamer]

@ brutal george and Sir Jake:

The MOTD window does support Flash quite well, but not Java. There is already a lot of history in this thread about using a Flash-based player. It is my preference to do this because it's a lighter program for the client machine to load on first use. However, I am not a Flash developer and I have yet to find a player that offers all of the features that I would expect of it in order to maintain the Jukebox's feature set. From what I understand, you can only pass a string a data from HTML to Flash via a value in the EMBED object, so I guess I'd have to be able to pass a volume setting, the filename of the generated playlist file and the position to start at in the first track.

If the songs don't play for you then Internet Explorer's security settings may not be allowing the MOTD program to run 3rd party programs like Media Player. Try turning down your security settings in Tools, Options, Security. This has happened to a couple other people before and this was the solution. Right now, my security setting is Medium-High, which is the default value.

@ millenium.dare:

I think you probably edited those values after Jukebox already loaded, since the errors you were getting only happen if the fields are left blank. You would have to reload the plugin to get it to read the config file again.

@ EVERYONE!

So I think Jukebox is at a point where most people are finding success with getting Jukebox to work. Working towards version 1.0 release, the emphasis right now is definitely on making Jukebox's front-end better and easier for your users to operate. Here are the next major new features of focus:

• Menu-based playback controls, featuring muting, playback stopping and more.
• Queuing of new tracks while music is playing, to begin at the end of the current playlist. Queued music will propagate down to other people who are listening to the stream, permitting admins to perform better as DJs. It will also allow multiple admins to share DJing of a single public stream.
• The ability for admins to designate a selection of songs to play randomly during map changes.

Further down the road, here are some later goals:

• The ability for admins to select a specific track or a select of tracks to play when a user first connects to the server. This will allow your server to feature a special "welcome" sound effect as well as a one-time-per-user welcome message with some explanation about your server, what makes it special and the available custom features. This may also evolve into a simple announcements system, allowing you to share news with your community members through short announcement spiels that are each heard only once.
• Improved HTML coding to better permit customization of the interface's appearance.
• Improved tools for music uploading to allow users to submit tracks for consideration by admins for addition.
• Hooks to allow other plugins to make use of Jukebox's platform.

Later yet, I intend to develop a karaoke add-on plugin that will use Jukebox to play the karaoke songs. It will work in two modes: The more familiar mode where the song plays, lyrics show up on the and everyone spams the mic in unison, and a more structured role where a smaller group self-elects to take on different roles in the songs, they all perform their parts, and then the others vote on a winner to receive some server-customizable bonuses.

[captainAngry]

sorry, didn't really want to read through everything but if no one has mentioned it, sm_mute is already a command to mute people in game with the default sourcemod.

Could you please change your command to something else (sm_jbmute)?

Other than that it is great.

[DontWannaName]

Here are some more errors, I dont know why its looking for the default database since I set it to something else.

L 11/07/2009 - 11:43:19: SourceMod error session started
L 11/07/2009 - 11:43:19: Info (map "pl_goldrush") (file "errors_20091107.log")
L 11/07/2009 - 11:43:19: [jukebox.smx] Failed to connect to SQL database.  Error: Could not find database conf "default"
L 11/07/2009 - 12:37:12: Error log file session closed.
L 11/08/2009 - 10:11:38: SourceMod error session started
L 11/08/2009 - 10:11:38: Info (map "pl_goldrush") (file "errors_20091108.log")
L 11/08/2009 - 10:11:38: [SM] Plugin encountered error 15: Array index is out of bounds
L 11/08/2009 - 10:11:38: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/08/2009 - 10:11:38: [SM]   [0]  Line 2769, W:\server script\sourcemod123\scripting\jukebox.sp::ClearDisconnectData()
L 11/08/2009 - 10:11:38: [SM]   [1]  Line 2579, W:\server script\sourcemod123\scripting\jukebox.sp::RemoveStream()
L 11/08/2009 - 10:11:38: [SM]   [2]  Line 2448, W:\server script\sourcemod123\scripting\jukebox.sp::Query_NextTrack2()
L 11/08/2009 - 10:58:09: Error log file session closed.
L 11/08/2009 - 16:39:50: SourceMod error session started
L 11/08/2009 - 16:39:50: Info (map "pl_badwater") (file "errors_20091108.log")
L 11/08/2009 - 16:39:50: [SM] Plugin encountered error 15: Array index is out of bounds
L 11/08/2009 - 16:39:50: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/08/2009 - 16:39:50: [SM]   [0]  Line 2769, W:\server script\sourcemod123\scripting\jukebox.sp::ClearDisconnectData()
L 11/08/2009 - 16:39:50: [SM]   [1]  Line 2579, W:\server script\sourcemod123\scripting\jukebox.sp::RemoveStream()
L 11/08/2009 - 16:39:50: [SM]   [2]  Line 2500, W:\server script\sourcemod123\scripting\jukebox.sp::Query_NextTrack2()
L 11/08/2009 - 17:12:22: Error log file session closed.
L 11/08/2009 - 18:48:30: SourceMod error session started
L 11/08/2009 - 18:48:30: Info (map "pl_badwater") (file "errors_20091108.log")
L 11/08/2009 - 18:48:30: [SM] Plugin encountered error 14: Divide by zero
L 11/08/2009 - 18:48:30: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/08/2009 - 18:48:30: [SM]   [0]  Line 1121, W:\server script\sourcemod123\scripting\jukebox.sp::KvSQL()
L 11/08/2009 - 18:48:30: [SM]   [1]  Line 1666, W:\server script\sourcemod123\scripting\jukebox.sp::PlayMusic()
L 11/08/2009 - 18:48:30: [SM]   [2]  Line 1046, W:\server script\sourcemod123\scripting\jukebox.sp::MusicMenuResultParse()
L 11/08/2009 - 18:48:30: [SM]   [3]  Line 1062, W:\server script\sourcemod123\scripting\jukebox.sp::MusicMenuHandler()
L 11/08/2009 - 18:48:34: [SM] Plugin encountered error 14: Divide by zero
L 11/08/2009 - 18:48:34: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/08/2009 - 18:48:34: [SM]   [0]  Line 1121, W:\server script\sourcemod123\scripting\jukebox.sp::KvSQL()
L 11/08/2009 - 18:48:34: [SM]   [1]  Line 1666, W:\server script\sourcemod123\scripting\jukebox.sp::PlayMusic()
L 11/08/2009 - 18:48:34: [SM]   [2]  Line 1046, W:\server script\sourcemod123\scripting\jukebox.sp::MusicMenuResultParse()
L 11/08/2009 - 18:48:34: [SM]   [3]  Line 1062, W:\server script\sourcemod123\scripting\jukebox.sp::MusicMenuHandler()
L 11/08/2009 - 19:16:42: Error log file session closed.
L 11/08/2009 - 19:30:28: SourceMod error session started
L 11/08/2009 - 19:30:28: Info (map "pl_goldrush") (file "errors_20091108.log")
L 11/08/2009 - 19:30:28: [SM] Plugin encountered error 11: Invalid memory access
L 11/08/2009 - 19:30:28: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/08/2009 - 19:30:28: [SM]   [0]  Line 1124, W:\server script\sourcemod123\scripting\jukebox.sp::KvSQL()
L 11/08/2009 - 19:30:28: [SM]   [1]  Line 1666, W:\server script\sourcemod123\scripting\jukebox.sp::PlayMusic()
L 11/08/2009 - 19:30:28: [SM]   [2]  Line 1046, W:\server script\sourcemod123\scripting\jukebox.sp::MusicMenuResultParse()
L 11/08/2009 - 19:30:28: [SM]   [3]  Line 1062, W:\server script\sourcemod123\scripting\jukebox.sp::MusicMenuHandler()
L 11/08/2009 - 20:07:10: Error log file session closed.
L 11/08/2009 - 21:02:02: SourceMod error session started
L 11/08/2009 - 21:02:02: Info (map "pl_goldrush") (file "errors_20091108.log")
L 11/08/2009 - 21:02:02: [SM] Plugin encountered error 15: Array index is out of bounds
L 11/08/2009 - 21:02:02: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/08/2009 - 21:02:02: [SM]   [0]  Line 2769, W:\server script\sourcemod123\scripting\jukebox.sp::ClearDisconnectData()
L 11/08/2009 - 21:02:02: [SM]   [1]  Line 2579, W:\server script\sourcemod123\scripting\jukebox.sp::RemoveStream()
L 11/08/2009 - 21:02:02: [SM]   [2]  Line 2500, W:\server script\sourcemod123\scripting\jukebox.sp::Query_NextTrack2()
L 11/08/2009 - 21:17:26: [SM] Plugin encountered error 15: Array index is out of bounds
L 11/08/2009 - 21:17:26: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/08/2009 - 21:17:26: [SM]   [0]  Line 2769, W:\server script\sourcemod123\scripting\jukebox.sp::ClearDisconnectData()
L 11/08/2009 - 21:17:26: [SM]   [1]  Line 2579, W:\server script\sourcemod123\scripting\jukebox.sp::RemoveStream()
L 11/08/2009 - 21:17:26: [SM]   [2]  Line 2448, W:\server script\sourcemod123\scripting\jukebox.sp::Query_NextTrack2()
L 11/08/2009 - 21:46:09: Error log file session closed.

[DontWannaName]

and a different server on the same box with a similar database error.

L 11/07/2009 - 02:44:25: SourceMod error session started
L 11/07/2009 - 02:44:25: Info (map "pl_badwater") (file "errors_20091107.log")
L 11/07/2009 - 02:44:25: [jukebox.smx] Failed to connect to SQL database.  Error: Could not find database conf "default"
L 11/07/2009 - 03:21:31: Error log file session closed.
L 11/07/2009 - 21:37:07: SourceMod error session started
L 11/07/2009 - 21:37:07: Info (map "pl_swiftwater") (file "errors_20091107.log")
L 11/07/2009 - 21:37:07: [SM] Plugin encountered error 11: Invalid memory access
L 11/07/2009 - 21:37:07: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/07/2009 - 21:37:07: [SM]   [0]  Line 1124, W:\server script\sourcemod123\scripting\jukebox.sp::KvSQL()
L 11/07/2009 - 21:37:07: [SM]   [1]  Line 1666, W:\server script\sourcemod123\scripting\jukebox.sp::PlayMusic()
L 11/07/2009 - 21:37:07: [SM]   [2]  Line 1046, W:\server script\sourcemod123\scripting\jukebox.sp::MusicMenuResultParse()
L 11/07/2009 - 21:37:07: [SM]   [3]  Line 1062, W:\server script\sourcemod123\scripting\jukebox.sp::MusicMenuHandler()
L 11/07/2009 - 21:46:52: Error log file session closed.
L 11/08/2009 - 00:52:58: SourceMod error session started
L 11/08/2009 - 00:52:58: Info (map "pl_hoodoo_final") (file "errors_20091108.log")
L 11/08/2009 - 00:52:58: [SM] Native "KvJumpToKey" reported: Invalid key value handle 0 (error 4)
L 11/08/2009 - 00:52:58: [SM] Displaying call stack trace for plugin "jukebox.smx":
L 11/08/2009 - 00:52:58: [SM]   [0]  Line 868, W:\server script\sourcemod123\scripting\jukebox.sp::AddParamNum()
L 11/08/2009 - 00:52:58: [SM]   [1]  Line 1597, W:\server script\sourcemod123\scripting\jukebox.sp::TopMenuHandler()
L 11/08/2009 - 01:30:21: Error log file session closed.

L 11/07/2009 - 01:12:20: Info (map "pl_goldrush") (file "errors_20091107.log")
L 11/07/2009 - 01:12:20: [jukebox.smx] Failed to create stream entry in database.  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Mrs. Boobies 2U', 0, 0)' at line 1
L 11/07/2009 - 02:02:06: Error log file session closed.