nxMyDB v0.4.0

[neoxed]

Notes
Built in release mode, will be much faster than the previous version.
Consider this a beta, possibly release candidate.

Changes
NEW: Compiled as a release build (alpha releases were debug builds).
NEW: New topics in the FAQ section of the readme.
CHG: Only open the debug log only when a message is available to be written, this allows you to download the log file through ioFTPD.
FIX: Corrected readme instructions for executing the "schema.sql" batch file.

Download

http://rapidshare.de/files/38291295/nxMyDB-v0.4.0.rar.html

[neoxed]

For users upgrading from v0.3.0 to v0.4.0, just replace the two DLLs (nxmydb.dll and libmysql.dll).

[Yil]

Have you tried it with 6.3.2 yet? I'm hoping it works :)

[neoxed]

I did some very brief testing on ioFTPD v6.3.2, and it worked OK. When I have time I will go through and check module API compatibility and ABI compatibility between 5.x and 6x. But at first glance, it seems fine.

[rolan]

hi,neoxed,i had use ioFTPD5.8.5r and mysql5.0.27

After site adduser , the user had exist mysql table,but show "11-23-2007 12:41:52 Unable to create user "user" (error 20601)." in the nxMyDB.log

[neoxed]

Follow the steps in the FAQ. The same steps apply.


Q: How do I enable debug logging?
A: Set "Log_Level" to "3" in the ioFTPD.ini file and restart ioFTPD.

Q: What does "Group locking failed." or "User locking failed." mean?
A: This error can be caused by a number of failures, try the following.
- Enable debug logging and paste recent entries from the debug.
- Check that the module is able to establish a connection with the MySQL server.
- Check that all tables and stored procedures exist.
- Check that the MySQL user account has execute privileges (required for stored procedures).
- Check that the MySQL server is the latest v5.0 version.

[magicman2008]

NEED a working link of please upload the .zip file here

[neoxed]

NEED a working link of please upload the .zip file here
Added a RapidShare download link. See the first post.

[hukker]

helloo

neoxed had a chance to try the script together with latest ioftpd on a vista system?
Iam getting weird lockups from time to time, eventually have to reboot computer or change ports in ioftpd and then restart it.

strangest thing, ioftpd it self runs fine for days on, but as soon as I try it out with nxdb strange lockups accure.

nothing in logs or anything of that sort... I hope you can try it out or someone else willing to test, see if it infact happends to more people. Be patient tho it can take sometime before a lockup, the other day I executed a !df command while uploading, at that point it locked for me... dunno, but it sure is real annoying


ioftpd v6.3.5 nxdb v0.4.0

[neoxed]

helloo neoxed had a chance to try the script together with latest ioftpd on a vista system?
Iam getting weird lockups from time to time, eventually have to reboot computer or change ports in ioftpd and then restart it.
What is locking up? Windows or ioFTPD?

If Windows is locking up, it is more than likely a problem with your hardware or device drivers. User-land applications cannot cause Windows to lock up, they don't have low level access.

If ioFTPD is locking up, is there any other specifics? Can you still log into the daemon? Does the task manager show ioFTPD using 100% CPU usage (or perhaps 50% if it's a dual-core machine, etc.)?

nothing in logs or anything of that sort... I hope you can try it out or someone else willing to test, see if it infact happends to more people. Be patient tho it can take sometime before a lockup, the other day I executed a !df command while uploading, at that point it locked for me... dunno, but it sure is real annoying
The !df command shouldn't cause ioFTPD to lock up at all. The !df command in AlcoBot doesn't even talk to ioFTPD, it just queries the Windows volumes using two WinAPI functions: GetDiskFreeSpaceEx (http://msdn2.microsoft.com/en-us/library/aa364937(VS.85).aspx) and GetVolumeInformation (http://msdn2.microsoft.com/en-us/library/aa364993(VS.85).aspx). I believe dZSbot does the same.

[razoor]

im using it on a vista machine. I havent seen this at all. So no problem here.

[hukker]

its ioFTPD thats locking up, task manager shows normal usage, nothing out of the ordinary. Once you try to logon you just get connection timeout.

Its a duel core processor yeah...

Ok so prolly nothing to do with the !df command, I was just trying to figure out what I did just before it happend... Iam sorry I cant help more... also seems its working ok for razoor so :\ Iam gonna go ahead and try iofptd + nxdb at first, only the two and check if it happends again...

[Yil]

What happens if the database is unreachable? I'm totally out on a limb here, but ioFTPD might get pretty confused if threads started blocking for any length of time... There are some simple changes I could make if this ends up being the case, but without looking at the code it just occurred to me this might be a problem.

Perhaps next time you see this, double check the DB is responsive just to rule this out. Especially if it isn't local...

[hukker]

yeah the nxdb logfile does indicate that the db has been offline for a number of times. A bunch of error lines.

[magicman2008]

How do i make the first step, creating a MySQL database:
please post the exactly command to make it correct

################################################## ##############################
# 2. Installation #
################################################## ##############################

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


--------------------------
now i have the db.opt created but im not sure its correct, no i try to import the "schema.sql" file to MySQL with MySQL Administrator 1.2.12
but still no luck to import the file from nxMyDB v.0.4.0

the error: The selected file was generated by mysqldump and cannot be restored by this application.

[o_dog]

how does it work with credits on several sites, and stats, does it sync it all to the same fields?

[neoxed]

how does it work with credits on several sites, and stats, does it sync it all to the same fields?
Yes, the incremental updates will sync changes to user/group data.