Auto User Email Creation

[indie]

Hello, I've seen this topic and I'm really interested in your script...

¿How can I get it?

Regards,

Pablo Lagos M.

Wish people would read threads before asking stuff. The post here has the latest version attached. http://roundcubeforum.net/forum/index.php?topic=232.msg2456#msg2456

[doof92]

Hello,
Is it possible to use multiple domains with this script, i.e. a user can signup for either @domain1.com or @domain2.com?
If so, how is it done.
Thank you very much

[GuessEye]

Tuney,

I'm currently building a site in MODxCMS that intergrates into SMF. IMHO it would be great if you could add (preferably MODx) and/or SMF intergration support into a future release, I think it would be a great fit.

Nevertheless, I must say that your plug-in is a great addon to RC, thank you for all your hard work!
I'm really looking forward to the next release.  

Sincerely,
Will

[waltercool]

Hi there... i have this problem

Table '*****_webmail.useraccounts' doesn't exist

* is only a filter

What can i do?

In my version of roundcube (last) exist user table, no useraccounts :S

[SKaero]

Hi there... i have this problem

Table '*****_webmail.useraccounts' doesn't exist

* is only a filter

What can i do?

In my version of roundcube (last) exist user table, no useraccounts :S

Well I think you forgot to add the new tables in your mysql db. Go into the sql and then add the files to you db.

[waltercool]

I was used that.

[indie]

Upload 'emsu' directory and all sub-directories into your roundcube directory.

Ensure emsu/includes is writtable. Permissions can be changed after installation.

Point your browser to the install folder (eg.http://www.yourdomain.com/webmail/emsu/install/index.php)

That is from the install file. Running that installer script will add the necessary SQL tables to your database.

If you think you have already done this, do it again and be triple sure that the connection information you enter into the installer is correct.

Hope this helps.

[waltercool]

So... this error??

Invalid default value for 'activated'

[indie]

Worth a try...

OPEN: /emsu/install/do_install.php

FIND: (~line 96)

Code: [Select]

mysql_query("CREATE TABLE IF NOT EXISTS useraccounts ( id int(11) NOT NULL auto_increment, username varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', activated int(11) NOT NULL default '', altemail varchar(50) NOT NULL default '', fname varchar(20) NOT NULL default '', lname varchar(20) NOT NULL default '', securityquestion varchar(50) NOT NULL default '', securityanswer varchar(50) NOT NULL default '', ip varchar(16) NOT NULL default '', timestamp varchar(37) NOT NULL default '', quota int(11) NOT NULL default '', PRIMARY KEY (`id`))") or die(mysql_error());
REPLACE WITH:

Code: [Select]

mysql_query("CREATE TABLE IF NOT EXISTS useraccounts ( id int(11) NOT NULL auto_increment, username varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', activated int(11) NOT NULL default '0', altemail varchar(50) NOT NULL default '', fname varchar(20) NOT NULL default '', lname varchar(20) NOT NULL default '', securityquestion varchar(50) NOT NULL default '', securityanswer varchar(50) NOT NULL default '', ip varchar(16) NOT NULL default '', timestamp varchar(37) NOT NULL default '', quota int(11) NOT NULL default '0', PRIMARY KEY (`id`))") or die(mysql_error());

SAVE FILE

Try running the installer again and report back, if you still have problems can you post your server's versions of php and mysql?

gl

[waltercool]

Many thanks... works

I have MySQL 5.x

[doof92]

Anyone know? Thanks

Hello,
Is it possible to use multiple domains with this script, i.e. a user can signup for either @domain1.com or @domain2.com?
If so, how is it done.
Thank you very much

[xopek]

After the release I will mainly be working on RoundCube integration. Both with bulletin boards/forums and CMS's. Just a simple Auto signup/login type thing.

Please give me a shout if you need any volunteers to test roundcube/vbulletin integration!
If you can get them working together this would be increadible!!

Denis

[Tam2]

hey can someone mod this to work with direct admin,

The currrent script i use for direct admin is the following perl script:

Code: [Select]

#!/usr/bin/perl -w

# Read the standard input (sent by the form):
read(STDIN, $FormData, $ENV{'CONTENT_LENGTH'});
# Get the name and value for each form input:
@pairs = split(/&/, $FormData);
# Then for each name/value pair....
foreach $pair (@pairs) {
# Separate the name and value:
($name, $value) = split(/=/, $pair);
# Convert + signs to spaces:
$value =~ tr/+/ /;
# Convert hex pairs (%HH) to ASCII characters:
$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg;
# Store values in a hash called %FORM:
$FORM{$name} = $value;
}

use HTTP::Request::Common qw(POST);
use LWP::UserAgent;

print "Content-type: text/html\n\n";

@QUERY_STRING = split (/\&/, $ENV{QUERY_STRING});
foreach $line (@QUERY_STRING) {
( $var, $val ) = split (/\=/,$line);
$val =~ s/(\@|\%40)/\\\@/g;
eval &quot;\$&quot; . $var . &quot; = \&quot;&quot; . $val . &quot;\&quot;\n&quot;; print &quot;<br />&quot;;
}
$browser = LWP::UserAgent->new();
$browser->agent('Mozilla/4.76 [en] (Win98; U)');
$browser->cookie_jar({});
push @{ $browser->requests_redirectable }, 'POST';

# change the username, password and ip address to your server information.
$url = '[url]http://USERNAME:PASSWORD@IP:PORT/CMD_EMAIL_POP?DOMAIN=DOMAIN_NAME';[/url]
$response = $browser->post( $url,
[
action => 'create',
add => 'Submit',
user => &quot;$FORM{'user'}&quot;,
passwd => &quot;$FORM{'passwd'}&quot;,
passwd2 =>&quot;$FORM{'passwd2'}&quot;,
quota => '$FORM{'quota}',
]
);

die &quot;Can't access admin tool -- &quot;, $response->status_line
unless $response->is_success;

print $response->content;


[the r3a! ne0]

Hi

I've got a problem...

on my server there isn't cpanel as control panel running...the hoster is kas-server.de

and i don't know either the cpanel's port nor the cpanel's ip...so i am not even able to test if the admin and the password script are running on this...

can anybody help me please?!?

thanks and please forgive my english, it's the germans' school english ...

vg the r3a! ne0

[Romka]

What about postfixadmin?
I have own server and don't use cPanel.
Using postfix+mysql+dovecot+postfixadmin+rouncube
I use postfixadmin for user creatation/password change/quota management, but want to integrate all administrative tools into roundcube and delete postfixadmin web part.
Does anybody have a solution for this? Maybe some patch for "rc signup&admin 2.1b" for use postfixadmin database?