View Full Version : nxMyDB v0.3.0 - Alpha 3
neoxed
10-06-2007, 05:22 PM
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.ioftpd-scripts.php?id=227
sFinx
10-06-2007, 05:29 PM
In other words 5.8.5r is the one to use this script with
neoxed
10-06-2007, 05:32 PM
Yeah, until Yil fixes some missing module functions in v6.x.
pretty work, your scripts are always the best, good continuation :)
some syntax error in the schema.sql
DECLARE elapsed FLOAT UNSIGNED DEFAULT 0;
Using MySQL 5.0.45
What is the cause of this?
neoxed
10-08-2007, 02:08 PM
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.
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
razoor
10-08-2007, 05:06 PM
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.
neoxed
10-08-2007, 06:01 PM
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';
monk-
10-08-2007, 07:25 PM
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
neoxed
10-13-2007, 09:42 PM
Not much activity...either no one is using it or it's working.
Feedback is welcome. :p
hukker
10-14-2007, 04:49 AM
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
11-04-2007, 04:54 AM
Seems to be working with the new ioftpd.v6.3
hukker
11-04-2007, 06:23 AM
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?
neoxed
11-04-2007, 02:30 PM
nxExport (e.g. dump from ShareDb) / nxImport (e.g. import to nxMyDB) still works from what I've heard.
razoor
11-06-2007, 02:28 PM
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
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
11-06-2007, 03:45 PM
and all of a sudden all works.
No idea what happend really.
razoor
11-06-2007, 08:05 PM
mm i get some problems here. don´t know if it me or the db or what.
I can make groups and all works as it should.
But if i try and add a user in a group i get errors
But if i use version 2.0 i dont have these problems, all works as it should.
site gadduser TRiAL olle nisse *@*
500 TRiAL: Group locking failed.
site adduser test2 test *@*
500 test2: User locking failed.
SITE CHGRP test iND SiTEOP
500 test: User locking failed.
and from my prevoius post, i only get those error if i use the sql file i get from 3.0 if i use the one in 2.0 i don´t get any errors at all.
ioFTPD: 0.6.31
nxMYDB: 3.0
MySQL: 5.0.45
hukker
11-07-2007, 12:31 AM
5.0.41 works fine on mine 64bit vista system (worked fine)
5.0.24a-Debian_9ubuntu2 This version however was really strange, I tried importing sql file and I actually got a similour error msg as razoor, it did import part of the sql file, just not everything, seems the issue is with the two last tables io_group/user_lock. Heres comes the strange thing, without actually doing anything other then a few times of testing import import the darn thing actually imported without any errors... I really dont know whats up with that.
As I cant reproduce the entire error again to show you... I got a small part of it anyways saved.
ERROR 1064 (42000) at line 200: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FLOAT UNSIGNED DEFAULT 0' at line 4
neoxed
11-07-2007, 01:05 PM
razoor: Please read before you post. I already posted a workaround for the error a few posts above yours.
http://www.inicom.net/forum/showpost.php?p=69289&postcount=6
You will have to recreate the database.
razoor
11-11-2007, 09:54 AM
That did the trick, all is now working.
I was reading in the readme file. and you forgott to add the --delimiter=$ in that command.
Now all we miss is a good tral/quota/top script to ;)
vBulletin® v3.8.11 Alpha 3, Copyright ©2000-2024, vBulletin Solutions, Inc.