Topic: MySQL (YaBB SE and UBB.Threads) Support

[Mike Bobbitt]

Hi all!

Just wanted to let you know that I have beta quality version of album.pl running that uses MySQL for authentication.

It's been tested with both YaBB SE (this forum) and UBB.Threads and works on both. I believe it can also be configured to work with forums such as Ikonboard without code modifications, though I haven't tested it.

If anyone wants to give this a shot, please let me know and I'll set you up.

Thanks!

For those that are interested, here's the new config section:

Code: [Select]

############
# DATABASE #
############

# This section is only required if you are using a database for authentication (I.E. authentication_type=4). If not, you can ignore all the settings here.

# The name of the database.
# YaBB SE default is yabbse
db_name=yabbse

# The system running the database. If it's the same system as the one running album.pl, leave this as "localhost"
db_hostname=localhost

# Username to log into database as
db_user=root

# Password to allow above user to log into database
db_password=password

# Port number to use to connect to the database.
# MySQL default is 3306
db_port=3306

# Table name containing member records
# YaBB SE default is yabbse_members
# UBB.Threads default is w3t_users
db_membertable=yabbse_members

# Name of the field that contains the user's login name in the "member" table
# YaBB SE default is memberName
# UBB.Threads default is U_LoginName
db_username=memberName

# Name of the field that contains the user's password in the "member" table
# YaBB SE default is passwd
# UBB.Threads default is U_Password
db_passwdfield=passwd

[MattUK]

Hi Mike,

Thats the best xmas news I could get!  I am about to move across my sites to UBB-Threads and wasnt looking forward to loosing the tie in with Gallery!

Superb news! I'd love to be set up with this!

Will it work with the new Invision forum software? Thats also MySQL related as I have a site that is using that and the users all want galleries too!

Hope to hear from you!
Matt

[Mike Bobbitt]

Hi Matt,

Glad to have you as a tester. I'm not sure what Invision is all about, but I'm confident we can get album.pl working with it. Can you provide me with some details on it?

I'll e-mail you the "MySQL" version of album.pl if you're ready to give it a shot...

Cheers

[MattUK]

Yes please!  I'm working with JC who I believe you know on my Threads installation as well.

Ill send you details on the other software.

Thanks!

[Mike Bobbitt]

Yeah, I know JC...

I've sent you the updated script file, and you can use the album.cfg from the download site. Note the "Database" section in the config file, with some UBB.Threads default suggestions. Looking for feedback on that as well, if you have any. The only other thing is you have to set authentication_type=4 in the config, and that should get it going.

Let me know if you have any problems or see anuything that's not right.

Thanks!

[SSBK]

I would like to give it a try.
I recently upgraded to YaBBSE 1.5 and I'd like to try the MySQL version of album.pl also.

[Mike Bobbitt]

...on it's way.

Thanks!

P.S. Forgot to mention that you need to have the Perl DBI package installed for this to work. Most MySQL sites already do, but if you need help just let me know.

[MattUK]

Mike,

Having a few issues getting it started... when running the new album.pl i get:

CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:


Can't locate DBI.pm in @INC (@INC contains: D:/Perl/lib D:/Perl/site/lib .) at e:\webs\gallery.bm3w.co.uk\cgi-bin\album.pl line 2644.
BEGIN failed--compilation aborted at e:\webs\gallery.bm3w.co.uk\cgi-bin\album.pl line 2644.



Looks like I need the DBI stuff.. ill have a hunt for it.. any pointers would be good..

[MattUK]

I've located plenty of files, but its on about me compiling them, and that where I look blankly at the screen and cannot proceed..

HELP!

[Mike Bobbitt]

Hi Matt,

If you're on a Windows system, try this:

Code: [Select]

C:\Documents and Settings\Mike Bobbitt>ppm
PPM - Programmer's Package Manager version 3.0.1.
Copyright (c) 2001 ActiveState SRL. All Rights Reserved.

Entering interactive shell. Using Term::ReadLine::Stub as readline library.

Profile tracking is not enabled. If you save and restore profiles manually,
your profile may be out of sync with your computer. See 'help profile' for
more information.

Type 'help' to get started.

ppm> install DBI
====================
Install 'DBI' version 1.30 in ActivePerl 5.8.0.802.
====================
Downloaded 375640 bytes.
Extracting 57/57: blib/arch/auto/DBI/Driver_xst.h
Installing X:\Perl\site\lib\auto\DBI\dbd_xsh.h
Installing X:\Perl\site\lib\auto\DBI\DBI.bs
Installing X:\Perl\site\lib\auto\DBI\DBI.dll
Installing X:\Perl\site\lib\auto\DBI\DBI.exp
Installing X:\Perl\site\lib\auto\DBI\DBI.lib
Installing X:\Perl\site\lib\auto\DBI\dbipport.h
Installing X:\Perl\site\lib\auto\DBI\DBIXS.h
Installing X:\Perl\site\lib\auto\DBI\dbi_sql.h
Installing X:\Perl\site\lib\auto\DBI\Driver.xst
Installing X:\Perl\site\lib\auto\DBI\Driver_xst.h
Installing X:\Perl\html\site\lib\DBI.html
Installing X:\Perl\html\site\lib\Win32\DBIODBC.html
Installing X:\Perl\html\site\lib\DBI\Changes.html
Installing X:\Perl\html\site\lib\DBI\DBD.html
Installing X:\Perl\html\site\lib\DBI\FAQ.html
Installing X:\Perl\html\site\lib\DBI\Format.html
Installing X:\Perl\html\site\lib\DBI\Profile.html
Installing X:\Perl\html\site\lib\DBI\ProxyServer.html
Installing X:\Perl\html\site\lib\DBI\PurePerl.html
Installing X:\Perl\html\site\lib\DBI\Shell.html
Installing X:\Perl\html\site\lib\DBI\W32ODBC.html
Installing X:\Perl\html\site\lib\DBI\Const\GetInfoReturn.html
Installing X:\Perl\html\site\lib\DBI\Const\GetInfoType.html
Installing X:\Perl\html\site\lib\DBI\Const\GetInfo\ANSI.html
Installing X:\Perl\html\site\lib\DBI\Const\GetInfo\ODBC.html
Installing X:\Perl\html\site\lib\DBD\Proxy.html
Installing X:\Perl\html\site\lib\Bundle\DBI.html
Installing X:\Perl\html\bin\dbiproxy.html
Installing X:\Perl\html\bin\dbish.html
Installing X:\Perl\site\lib\DBI.pm
Installing X:\Perl\site\lib\Win32\DBIODBC.pm
Installing X:\Perl\site\lib\DBI\Changes.pm
Installing X:\Perl\site\lib\DBI\DBD.pm
Installing X:\Perl\site\lib\DBI\FAQ.pm
Installing X:\Perl\site\lib\DBI\Format.pm
Installing X:\Perl\site\lib\DBI\Profile.pm
Installing X:\Perl\site\lib\DBI\ProxyServer.pm
Installing X:\Perl\site\lib\DBI\PurePerl.pm
Installing X:\Perl\site\lib\DBI\Shell.pm
Installing X:\Perl\site\lib\DBI\W32ODBC.pm
Installing X:\Perl\site\lib\DBI\Const\GetInfoReturn.pm
Installing X:\Perl\site\lib\DBI\Const\GetInfoType.pm
Installing X:\Perl\site\lib\DBI\Const\GetInfo\ANSI.pm
Installing X:\Perl\site\lib\DBI\Const\GetInfo\ODBC.pm
Installing X:\Perl\site\lib\DBD\ExampleP.pm
Installing X:\Perl\site\lib\DBD\NullP.pm
Installing X:\Perl\site\lib\DBD\Proxy.pm
Installing X:\Perl\site\lib\DBD\Sponge.pm
Installing X:\Perl\site\lib\Bundle\DBI.pm
Installing X:\Perl\bin\dbiproxy
Installing X:\Perl\bin\dbiproxy.bat
Installing X:\Perl\bin\dbish
Installing X:\Perl\bin\dbish.bat
Writing X:\Perl\site\lib\auto\DBI\.packlist
Successfully installed DBI version 1.30 in ActivePerl 5.8.0.802.
ppm> quit

If you're on UNIX, it's almost the same but you use "perl -MCPAN -e shell\;" to invoke the CPAN shell, then enter "install DBI".

Hope that helps!

Cheers

[Zackary]

Greetings all.

Hey Mike, told you I'd post here eventually. hehe!

I have Album working with my test Threads install so I'll try to help out where I can with the config stuff.

My Threads board isn't live yet as I'm slowly rebuilding my site around Threads, converting from .Classic.

My thanks to Mike for a great new version of this script! And thanks for putting up with my persistant emails bud. hehe!

Anyone running ActivePerl should definitely follow Mike's instructions above for the PPM install for the modules. It's very quick and easy to get this script working.

Zack

[Mike Bobbitt]

Thanks Zack, you and Matt both helped a lot in getting the wrinkles worked out of DB authentication.

And I think we're there!

Anyone using DB authentication now will benefit from your presistent testing.

Thanks to both of you!

[Zackary]

Thanks Mike.

Now if I could just get my icons to show up right.

Gonna reinstall tonight, i think I have different versions of different files floating around. hehe!

[Mike Bobbitt]

I'm pretty sure the icons thing was a bug. Try re-downloading...

[Zackary]

100% Working Mike.

I did have an old version of the .cfg file as well, not as big of a deal.

I will now need to convert the directories of members from the .Classic style of user numbers to login names, but that's easy.

Thanks again!