Go Back   FlashFXP Forums > > > >

NeoXed's scripts nxAutoNuke, nxTools, etc.

Reply
 
Thread Tools Rate Thread Display Modes
Old 10-06-2007, 05:22 PM   #1
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default nxMyDB v0.3.0 - Alpha 3

Will not work with ioFTPD v6.x, as the module system is partially broken.

Notes
  • Built in debug mode, so file sizes are larger and performance is marginally slower.
  • This is the final alpha release, now the beta period begins.

Changes
  • NEW: Added configuration option "Log_Level" to control the log verbosity.
  • NEW: Group rename operations are now implemented.
  • NEW: Logging system to log errors, warnings, and information to a dedicated log file.
  • NEW: Spin-lock based locking implemented using stored procedures, reduces failed locks.
  • CHG: Renamed configuration option "SyncFirst" to "Sync_First".
  • CHG: Renamed configuration option "SyncInterval" to "Sync_Interval".
  • CHG: Requires MySQL Server v5.0.19, or newer.
  • FIX: All user's admingroups, groups and hosts were inserted with null-padding to the database.
  • FIX: If ioFTPD fails to open a user at start-up it considers them deleted.
  • FIX: User rename operations failed during sync, since the new name was not present in the changes table.
  • FIX: Work around a bug in ioFTPD that leads to memory corruption if a module open call returns UM_ERROR/GM_ERROR.

Download

http://www.inicom.net/pages/en.ioftp...pts.php?id=227
neoxed is offline   Reply With Quote
Old 10-06-2007, 05:29 PM   #2
sFinx
Junior Member
 
Join Date: Jan 2007
Posts: 3
Default

In other words 5.8.5r is the one to use this script with
sFinx is offline   Reply With Quote
Old 10-06-2007, 05:32 PM   #3
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default

Yeah, until Yil fixes some missing module functions in v6.x.
neoxed is offline   Reply With Quote
Old 10-07-2007, 04:55 PM   #4
m5
Junior Member
FlashFXP Registered User
ioFTPD Foundation User
 
Join Date: Jun 2004
Posts: 7
Default

pretty work, your scripts are always the best, good continuation
m5 is offline   Reply With Quote
Old 10-08-2007, 01:25 PM   #5
pion
Senior Member
 
Join Date: Feb 2006
Posts: 138
Default

some syntax error in the schema.sql
DECLARE elapsed FLOAT UNSIGNED DEFAULT 0;

Using MySQL 5.0.45


What is the cause of this?
pion is offline   Reply With Quote
Old 10-08-2007, 02:08 PM   #6
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default

Apparently the MySQL Command Line Client uses the semi-colon as its default delimiter, which screwed up the creation of stored procedures.

Use the following commands instead, I will update readme.txt for future versions.

Code:
1. Create a MySQL database and import the schema.sql file.

   mysql -u root -p -h 192.168.1.1 -e "CREATE DATABASE ioftpd"
   mysql -u root -p -h 192.168.1.1 -D ioftpd --delimiter=$ < schema.sql

Last edited by neoxed; 10-08-2007 at 02:37 PM.
neoxed is offline   Reply With Quote
Old 10-08-2007, 05:06 PM   #7
razoor
Senior Member
ioFTPD Foundation User
 
Join Date: Oct 2006
Posts: 163
Default

Creating a group works just fine, but i get this when im adding a user in the group.

e gadduser iND test test *@*
iND: Group locking failed.
razoor is offline   Reply With Quote
Old 10-08-2007, 06:01 PM   #8
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default

Code:
site gadduser fake duke duke foo@bar *@127.0.0.1
500 fake: Group does not exist.

site gadduser www duke duke foo@bar *@127.0.0.1
200 gadduser Command successful.
Works fine for me, I'll need more information to go on.

- Version of ioFTPD.
- Did you upgrade from an older version of nxMyDB?
- Did you remember to create the stored procedures if you upgraded?
- Did you enable Log_Level=3 and paste information from nxMyDB.log?
- Information about the group/user:
- SELECT * FROM io_group WHERE name='iND';
- SELECT * FROM io_user WHERE name='test';
neoxed is offline   Reply With Quote
Old 10-08-2007, 07:25 PM   #9
monk-
Member
 
Join Date: Oct 2007
Posts: 32
Default

Quote:
Originally Posted by razoor View Post
Creating a group works just fine, but i get this when im adding a user in the group.

e gadduser iND test test *@*
iND: Group locking failed.
maybe the mysql user needs to have execute rights..
i had that problem

Last edited by monk-; 10-09-2007 at 12:11 AM.
monk- is offline   Reply With Quote
Old 10-13-2007, 09:42 PM   #10
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default

Not much activity...either no one is using it or it's working.

Feedback is welcome.
neoxed is offline   Reply With Quote
Old 10-14-2007, 04:49 AM   #11
hukker
Senior Member
FlashFXP Registered User
ioFTPD Foundation User
 
Join Date: Jun 2004
Posts: 165
Default

Its working just fine as far as my testing goes neoxed.

Iam guessing people use ioftpd 6.x and therefore havent replied that much on the topic.
Nothing you can really do until the new io version is out I guess, my own setups are all ioFTPD 6.x, but since I thought this is such a greate project you have here I just had to test it with io 5.8.5.

Tested around with two sites only atm, its syncing perfectly. I bring one down adduser, delusers, change permissions etc, all good when second sites pops up, takes about 30 sec, guess its depending on the settings in ioftpd.ini, for it to sync.
Havent tested the ssl stuff tho, never used that with mysql, maybe in the future

Anyways greate script greeeeeate work
hukker is offline   Reply With Quote
Old 11-04-2007, 04:54 AM   #12
hukker
Senior Member
FlashFXP Registered User
ioFTPD Foundation User
 
Join Date: Jun 2004
Posts: 165
Default

Seems to be working with the new ioftpd.v6.3
hukker is offline   Reply With Quote
Old 11-04-2007, 06:23 AM   #13
hukker
Senior Member
FlashFXP Registered User
ioFTPD Foundation User
 
Join Date: Jun 2004
Posts: 165
Default

neoxed, is there a way of exporting your current db and import to mysql... that old script you wrote for the first sharedb, export import, does that work?
hukker is offline   Reply With Quote
Old 11-04-2007, 02:30 PM   #14
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default

nxExport (e.g. dump from ShareDb) / nxImport (e.g. import to nxMyDB) still works from what I've heard.
neoxed is offline   Reply With Quote
Old 11-06-2007, 02:28 PM   #15
razoor
Senior Member
ioFTPD Foundation User
 
Join Date: Oct 2006
Posts: 163
Default

When i try to make the tables i get these error.
Beats me what it means.
But if i use the "old" sql file from 2.0 then it works, but then version 3 isnt working at all and i get some errors when i add users/groups

And im a totally newbie when it comes to mysql. =)
MySQL Version 5.0.45

Code:
Warning: Do not know how to handle this statement at line 6:
CREATE PROCEDURE io_user_lock(IN pName VARCHAR(65), IN pExpire INT, IN pTimeout INT, IN pOwner VARCHAR(36))
BEGIN
proc:BEGIN
  DECLARE elapsed FLOAT UNSIGNED DEFAULT 0;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Warning: Do not know how to handle this statement at line 10:
DECLARE sleep   FLOAT UNSIGNED DEFAULT 0.2;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Warning: Do not know how to handle this statement at line 12:
WHILE elapsed < pTimeout DO
    UPDATE io_user SET lockowner=pOwner, locktime=UNIX_TIMESTAMP()
      WHERE name=pName AND (lockowner IS NULL OR (UNIX_TIMESTAMP() - locktime) > pExpire);
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Warning: Do not know how to handle this statement at line 16:
IF ROW_COUNT() > 0 THEN
      LEAVE proc;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Warning: Do not know how to handle this statement at line 18:
END IF;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
razoor is offline   Reply With Quote
Reply

Tags
configuration, download, fix, log, option

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:22 AM.

Parts of this site powered by vBulletin Mods & Addons from DragonByte Technologies Ltd. (Details)