Database intergration or API

[kfsone]

I run my TS2 server on a Linux box which also houses a Roxen WebServer and Content Management Engine.

Roxen is a free webserver that pre-dates apache, has a built in web-based configuration interface, an XML-like language called RXML for scripting as well as all the usual goodies like CGI, Perl, Java, PHP, etc support; but RXML is by far and away the best means of scripting your webpages.

One of the big features of Roxen is that it has always had very good, integrated support for databases - something Apache never really picked up on until PHP and such came along.

The upshot of all this is that I've already had a user registration database for nearly 9 years - so it is fairly inconvenient for us having to register seperate accounts for the-latest-tool, e.g. TeamSpeak2.

I'd like a way to be able to integrate TeamSpeak 2 with my existing user database; so that people registered with my webservers can use those accoutns to access TeamSpeak2 - same username, password, etc.

If support were provided for MySQL, Postgres, ODBC and perhaps a flat-text module, then people will be able to integrate not only with Roxen authentication but also with PHP, Zope, IIS and other authentication databases enabling sites to integrate TeamSpeak2 with their existing systems and making it far more desirable.

I can also see a possible future for being able to associate TeamSpeak2 channels with parts of sites -- web-talks are very popular, but imagine being able to hook up those web-talks with a moderated, IP voice system...

You'll need to be flexible in your database api so as not to require specific field names, etc.

You can use SQLs 'AS' adjective to allow people to map field names to their required values, e.g.

SELECT uname AS username, uid AS userid, pw AS password

etc

[R. Ludwig]

hi

i will add database support, but i dont think that will happen this year.

also i dont know which db systems i gonna support. mysql
is ofcourse already choosen.

[kfsone]

you ought to be able to get people willing to contribute code fairly readily. I've done work on database API stuff for years now, I work with Postgres, MySQL and Oracle through Perl, PHP, Roxen, JDBC and other APIs; I've written API code for various platforms I've been involved with such as OpenWebMail.

[evilc]

this would really rule.
Our clan uses a web portal based on a message board (XMB) and if it could integrate into that user DB it would make life much simpler !

[Korban]

This would be extremely helpful!

Don't forget postgres as well as mysql. It shouldn't take much to support that in addition.

[RNilsson]

And if it's possible to user-configure the password routine, the users can select which method thay want to use when authenticate users, like crypt(), md5() among others they can use what their external source use for password-security.

crypt() in php makes a password encrypted so it can be used in .htpasswd/.htaccess

I know that phpbb2 use md5() for hashing the passwords in the db.

Just tacking my 2cents on the board...

Edit: Typo

Edit2: DBInfo

And if you collect this info from the server-admin to use as user-authentication:
DBHost: ip, fqdn
DBType: mysql, postgresql, etc
DBName: name of the database
DBUserTable: name of the table with userinfo: username, password
DBUserField: the name of the user-field in DBUserTable
DBPasswordField: the name of the password-field in DBUserTable
DBPasswordEncryption: how to verify the password (md5, crypt, etc, etc)

DBUserStatus: The status of the user (user, chanadmin, etc, etc)

and any other field tha users can easily adopt to their own dbinfo's for existing portals etc.

[ESW_Webmaster]

The use of this system by our community will be solely based on the addition of an external user database feature in the server software.

We are currently using an access database and the ability to setup an external database source for the users would be the deciding factor to integrate TeamSpeak into our community.

Please let us know if this is or when it will be supported.

Thanks.

[evilc]

XMB also uses MD5()
The requirements rnilsson states would fit my needs too.
However, for me it would also be nice if you could specify multiple databases to allow people from.
I run a number of sites using XMB, and people using all of them also use TS, so it would be nice to be able to specify multiple databases.
Thanks, hoping this will happen...

[lapapaz]

that might be tricky if multiple reoccuring names appear in the databases, they would have to figure out a way to get past the conflicting names

[ESW_Webmaster]

Well. Our system already makes sure that there aren't any duplicate names.