search

aoberegg / ep_user_pad

User-Management System for etherpad-lite
Apache License 2.0
5 stars 8 forks source link

user_pad crashes when creating new user #8

Closed loadavg closed 9 years ago

loadavg commented 9 years ago

When I create a new user on my home page at www.editopia.com etherpad crashes as follows:

[2014-07-07 10:29:52.493] [ERROR] console - ep_user_pad_frontend: existValueInDatabase error, sql: SELECT * from User where User.name = ? [2014-07-07 10:29:52.533] [ERROR] console - Error: Cannot find module 'encoding' at Function.Module._resolveFilename (module.js:338:15) at Function.Module._load (module.js:280:25) at Module.require (module.js:364:17) at require (module.js:380:17) at Object. (/home/etherpad/etherpad-lite/node_modules/ep_user_pad_frontend/node_modules/nodemailer/node_modules/mailcomposer/node_modules/mimelib/lib/mimelib.js:3:15) at Module._compile (module.js:456:26) at Object.Module._extensions..js (module.js:474:10) at Module.load (module.js:356:32) at Function.Module._load (module.js:312:12) at Module.require (module.js:364:17) [2014-07-07 10:29:52.533] [INFO] console - graceful shutdown... [2014-07-07 10:29:52.534] [INFO] console - db sucessfully closed.

I dont see notes on editing the database anywhere ? I am using a mysql database and free pads work fine..

http://editopia.com/public_pad/testpad

also how do i install module encoding ?

also..

How can I support this project ? looking to launch a proper etherpad driven site at editopia here...

thanks!

quenenni commented 9 years ago

the notes are in the installation.pdf file. You have toi create several tables before using this plugin..

Also, check this comment before launching the sql queries: https://github.com/aoberegg/ep_user_pad/issues/4#issuecomment-40288911

loadavg commented 9 years ago

yes thanks! found the pdf and got up and running. the SQL queries gave me hell as well but was able to get past them... will dig in to the comment and see what else was going on. working fine now, really like it great work!

niraj8241 commented 9 years ago

If anyone faced issues setting up databases. Please copy paste the below ones.

CREATE TABLE IF NOT EXISTS GroupPads ( GroupID int(11) NOT NULL, PadName varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (GroupID,PadName) );

CREATE TABLE IF NOT EXISTS Groups ( groupID int(11) NOT NULL AUTO_INCREMENT, name varchar(255) COLLATE utf8_bin NOT NULL DEFAULT , PRIMARY KEY (groupID,name) );

CREATE TABLE IF NOT EXISTS NotRegisteredUsersGroups ( email varchar(255) NOT NULL, groupID int(11) NOT NULL );

CREATE TABLE IF NOT EXISTS User ( userID int(11) NOT NULL AUTO_INCREMENT, name varchar(255) COLLATE utf8_bin NOT NULL DEFAULT , pwd varchar(255) COLLATE utf8_bin DEFAULT NULL, considered tinyint(11) DEFAULT NULL, SSO tinyint(4) DEFAULT NULL, FullName varchar(255) COLLATE utf8_bin DEFAULT NULL, considerationString varchar(50) COLLATE utf8_bin DEFAULT NULL, salt varchar(255) COLLATE utf8_bin DEFAULT NULL, active int(1) DEFAULT NULL, PRIMARY KEY (userID, name) );

CREATE TABLE IF NOT EXISTS UserGroup (userID int(11) NOT NULL DEFAULT 0, groupID int(11) NOT NULL DEFAULT 0, Role int(11) DEFAULT NULL, PRIMARY KEY (userID,groupID) );