NeoXed's scripts nxAutoNuke, nxTools, etc. |
10-06-2007, 05:22 PM
|
#1
|
Too much time...
FlashFXP Beta Tester ioFTPD Scripter
Join Date: May 2003
Posts: 1,326
|
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
|
|
|
10-06-2007, 05:29 PM
|
#2
|
Junior Member
Join Date: Jan 2007
Posts: 3
|
In other words 5.8.5r is the one to use this script with
|
|
|
10-06-2007, 05:32 PM
|
#3
|
Too much time...
FlashFXP Beta Tester ioFTPD Scripter
Join Date: May 2003
Posts: 1,326
|
Yeah, until Yil fixes some missing module functions in v6.x.
|
|
|
10-07-2007, 04:55 PM
|
#4
|
Junior Member
FlashFXP Registered User ioFTPD Foundation User
Join Date: Jun 2004
Posts: 7
|
pretty work, your scripts are always the best, good continuation
|
|
|
10-08-2007, 01:25 PM
|
#5
|
Senior Member
Join Date: Feb 2006
Posts: 138
|
some syntax error in the schema.sql
DECLARE elapsed FLOAT UNSIGNED DEFAULT 0;
Using MySQL 5.0.45
What is the cause of this?
|
|
|
10-08-2007, 02:08 PM
|
#6
|
Too much time...
FlashFXP Beta Tester ioFTPD Scripter
Join Date: May 2003
Posts: 1,326
|
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.
|
|
|
10-08-2007, 05:06 PM
|
#7
|
Senior Member
ioFTPD Foundation User
Join Date: Oct 2006
Posts: 163
|
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.
|
|
|
10-08-2007, 06:01 PM
|
#8
|
Too much time...
FlashFXP Beta Tester ioFTPD Scripter
Join Date: May 2003
Posts: 1,326
|
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';
|
|
|
10-08-2007, 07:25 PM
|
#9
|
Member
Join Date: Oct 2007
Posts: 32
|
Quote:
Originally Posted by razoor
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.
|
|
|
10-13-2007, 09:42 PM
|
#10
|
Too much time...
FlashFXP Beta Tester ioFTPD Scripter
Join Date: May 2003
Posts: 1,326
|
Not much activity...either no one is using it or it's working.
Feedback is welcome.
|
|
|
10-14-2007, 04:49 AM
|
#11
|
Senior Member
FlashFXP Registered User ioFTPD Foundation User
Join Date: Jun 2004
Posts: 165
|
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
|
|
|
11-04-2007, 04:54 AM
|
#12
|
Senior Member
FlashFXP Registered User ioFTPD Foundation User
Join Date: Jun 2004
Posts: 165
|
Seems to be working with the new ioftpd.v6.3
|
|
|
11-04-2007, 06:23 AM
|
#13
|
Senior Member
FlashFXP Registered User ioFTPD Foundation User
Join Date: Jun 2004
Posts: 165
|
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?
|
|
|
11-04-2007, 02:30 PM
|
#14
|
Too much time...
FlashFXP Beta Tester ioFTPD Scripter
Join Date: May 2003
Posts: 1,326
|
nxExport (e.g. dump from ShareDb) / nxImport (e.g. import to nxMyDB) still works from what I've heard.
|
|
|
11-06-2007, 02:28 PM
|
#15
|
Senior Member
ioFTPD Foundation User
Join Date: Oct 2006
Posts: 163
|
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.
|
|
|
Thread Tools |
|
Display Modes |
Rate This Thread |
Linear Mode
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -5. The time now is 07:22 AM.
|