Help with invite

[void4ever]

I hate looking like an idiot, but i could use some help getting the invite script to work correctly with alcobot. It's step 2 thats throwing me for a loop here.

2. Create an ODBC DSN connection to your database. Use the table schema
provided in invite.sql, which is located in the module's directory.

I don't know the first thing about SQL. I have mysql installed along with the ODBC driver, and i've looked over at least 10 sites found from a google search. But there are at least 3 different ways to do this from what i see. User, system, and file.

I'm not looking for a hand out, but if someone could point me at a certain article i can read. or even some quick steps (if there is such a thing) i'd appreciate it.

Void4ever

[hukker]

youd have to import the invite.sql to your mysql, that step is fairly easy, you open up your administrator tool of mysql, and there should be an option of importing *.sql files.
This would create the database you need for invite.

About the ODBC connection between alcobot and mysql, do as followed...
start menu / run / odbcad32 "push enter" :D
choose the system DSN window, then Add... and select the ODBC driver "MYSQL ODBC DRIVER 5.1"
after that you input the info for your mysql Database, IP address, username / password.
Remeber to set the same Datasource Name as you have in your config settings of alcobot.

btw this invite script is only for the /msg _BOT_ !invite username pass feature when connected to IRC. You could use the internal one, the one for ioftpd only "site invite nick" this way a connection to any DB is not needed. Theres info about how you install the siteInvite.tcl in the readme.txt

"slap me if I have said anything wrong" :)

[void4ever]

i'm at work now, but i'll remote to my box and give this a try in a bit. One more question, Am i to assume any box that i want to use this invite function on needs to have mysql installed. Or once i create the database i'm good to go even if the box doesn't have mysql installed.

Void4ever

[PaRaNoiD_JaCK]

You have to the install the mySQL ODBC driver before you can select "MYSQL ODBC DRIVER 5.1"

http://www.mysql.com/products/connector/odbc/

[void4ever]

already have the connector installed, but it's actually 3.51 not 5.1. But anyways

I ran through your steps hukker, i had to go download an admin tool though :)

i created the database then imported the invite.sql, then went to the odcb connector page and followed those steps. using the test button it said it connected just fine. So i think i'm set there (i still need to test the bot though)

But as from my last question it looks like any computer i have this script setup on will have to have mysql installed is that correct? Say i have 3 different sites, each with there own user files, i'm going to have to get mysql installed on each box in order for the invite script to work is that correct?

Void4ever

[neoxed]

But as from my last question it looks like any computer i have this script setup on will have to have mysql installed is that correct? Say i have 3 different sites, each with there own user files, i'm going to have to get mysql installed on each box in order for the invite script to work is that correct?No, the idea is that all sites would share a single invite database.

If you have multiple ioFTPD sites, with the same users and groups, why would you keep them independent? It would make a lot more sense to use a shared database, that way users and groups are consistent across all sites.

[void4ever]

well in the past i had always had multiple sites and each site had it's own users and groups. Everything was seaprate.

What script would you recommend to setup a shared user database between all my sites?

Void4ever

[neoxed]

What script would you recommend to setup a shared user database between all my sites?
There is only one public module to do this - ioShareDb. However, the author no longer supports the module and has not reposted it. I uploaded the original ioShareDb package to my website (for those of you who need it).

http://www.alcoholicz.com/scripts/other/sharedb-0.9.0.zip

[void4ever]

Neo i appreciate the link to the share database. Thank you

I'm currently tracking down this issue, but i figured i'd post it just in case someone answers it before i track it down.

[19:39] [☻AlcoBot☻] Error :: ModInvite - The database "Alcoholicz" is missing th
e "invite_hosts" or "invite_users" table.

Any ideas??? that seems to me like the invite.sql was incomplete, but that can't be the issue or more people would be writing about it.

Void4ever

[void4ever]

LMAO fixed it myself. When i created the odbc connection i forgot to select the invite database lol. So it was connecting to the SQL server just fine, but no database was chosen HA i'm a moron. :)

I'm sure i'll have a few more questions before this is over. I really do appreciate your guys input!!!

Void4ever

[ko0ky]

btw this invite script is only for the /msg _BOT_ !invite username pass feature when connected to IRC. You could use the internal one, the one for ioftpd only "site invite nick" this way a connection to any DB is not needed. Theres info about how you install the siteInvite.tcl in the readme.txt

Are you sure about this? I am trying to configure only site invite cmd via ftp site, the script errors while trying to connect to db and isn't inviting me.

0:24:04 PM > site invite ko0ky
10:24:04 PM 200-.-[Invite]-----------------------------------------------------.
10:24:04 PM 200-| Unable to connect to database "Alcoholicz". |
10:24:04 PM 200-'--------------------------------------------------------------'
10:24:04 PM 200 Command successful.

any suggestions?

[_panic_]

There is only one public module to do this - ioShareDb. However, the author no longer supports the module and has not reposted it. I uploaded the original ioShareDb package to my website (for those of you who need it).

http://www.alcoholicz.com/scripts/other/sharedb-0.9.0.zip

i don't suppose by any stretch you have the source code to this module? the binary module isn't working with 5.8.6r, and it isn't going to without access to the source code. i'm afraid this module might well wind up depricated.

[neoxed]

Are you sure about this? I am trying to configure only site invite cmd via ftp site, the script errors while trying to connect to db and isn't inviting me.
This isn't a whole lot of information to go on, but make sure you followed the setup instructions. You have to set the ODBC system data source name in AlcoBot.conf and in siteInvite.tcl (as mentioned in setup instructions in readme.txt and in siteInvite.tcl).

i don't suppose by any stretch you have the source code to this module? the binary module isn't working with 5.8.6r, and it isn't going to without access to the source code. i'm afraid this module might well wind up depricated.
Nope, sorry. The author of ioShareDb disappeared as quickly and abruptly as he arrived.

[ko0ky]

This isn't a whole lot of information to go on, but make sure you followed the setup instructions. You have to set the ODBC system data source name in AlcoBot.conf and in siteInvite.tcl (as mentioned in setup instructions in readme.txt and in siteInvite.tcl).

Sorry for not leaving more detailed information. I was attempting to configure invite only from the site not needed from IRC and thought it was mentioned this could be done. I was hoping to get this done without a setting up a DB, is that even possible?

btw this invite script is only for the /msg _BOT_ !invite username pass feature when connected to IRC. You could use the internal one, the one for ioftpd only "site invite nick" this way a connection to any DB is not needed. Theres info about how you install the siteInvite.tcl in the readme.txt

[void4ever]

Panic are u sure ioshare isn't working because of ioFTPD? I was reading in one of the support threads that you have to use an older version of mysql and the ODBC connector in order for it to work. I didn't see anything about the version of ioFTPD.


Does anyone know of any other sharedb modules?

[neoxed]

I was hoping to get this done without a setting up a DB, is that even possible?No, a database is required for the invite module (this does not nessacarily mean a database server).

There are a variety of data sources that can be used with ODBC. If you prefer not to use a server based solution (e.g. MySQL or PostgreSQL), you could use the SQLite ODBC driver (http://www.ch-werner.de/sqliteodbc/) and keep the database in a single local file.

btw this invite script is only for the /msg _BOT_ !invite username pass feature when connected to IRC. You could use the internal one, the one for ioftpd only "site invite nick" this way a connection to any DB is not needed. Theres info about how you install the siteInvite.tcl in the readme.txt I don't understand, is this a question? You can invite yourself by the !invite IRC command and/or by the SITE INVITE command. If you only want one invite method, disable the one you don't need.

[hukker]

As I understood it, a DB of somekind was required for the /MSG !invite cmd but not for the "site invite nick" cmd, thats what I thought neoxed.

kooky sorry for missleading.

[snatsert]

No, a database is required for the invite module (this does not nessacarily mean a database server).

There are a variety of data sources that can be used with ODBC. If you prefer not to use a server based solution (e.g. MySQL or PostgreSQL), you could use the SQLite ODBC driver (http://www.ch-werner.de/sqliteodbc/) and keep the database in a single local file..


Can you explain how that sqlite works than ?? I am trying to use that but how can I import the invite.sql ?

[eger]

I read this thread many times and I am still unclear if it is possible to use only site invite WITHOUT a dsn. Is this possible or not?

[neoxed]

I read this thread many times and I am still unclear if it is possible to use only site invite WITHOUT a dsn. Is this possible or not?
You obviously didn't read anything. http://www.inicom.net/forum/showpost.php?p=126383&postcount=15

[eger]

Sorry, don't know why I didn't understand what I was reading.

I modified the code to make a seperate module that allows for non-db setups with site invite only.

EDIT: I now realize that the use of the invite DB is NOT just for invites. It allows for other modules to depend on it and it's DB for other functions (like nxtools request system). So now I will probably go back and actually create the DB and use it as designed instead of hacking it up to now use it.

I also found this tool which should aid in the building of the sqlite db for the sqlite odbc driver should anyone be using it: http://sqlitebrowser.sourceforge.net/

Neoxed, any plans to have an option to use an sqlite db in the config and have easy to create sqlite db like nxtools? The nxtools setup of the db is much nicer than the one for Alcobot currently. Just a thought.

[hukker]

I must say that sounds like a greate idee, keeping the DB localy...
downside I guess is youd have to add each host/user to each site db :)

you could use the !site cmd for that then hehe, executeing it on all sites at once