Ipswitch Forums / Technical Preview Programs / WS_FTP Server 6.1 TPP / User synchronize button destroys data / Latest Posts

RE: User synchronize button destroys data

FrankG — Fri, 04 Jan 2008 11:33:29 GMT

I made some more tests but the behavior is 100% reproducible. The impact ist a disaster. Hundreds of megabytes user data are deleted. most of the user directories are completely empty. User are deleted completely out of the database. Before migration from Postgres to SQLServer synchronisation worked!

Are there other users of WS_FTP Server 6.1 who experienced such behaviours when using MS SQLServer. We appreciate every input.

RE: User synchronize button destroys data

J.J. — Wed, 21 Nov 2007 18:59:16 GMT

I have not seen that occur, were you going between different versions of SQL perhaps?

User synchronize button destroys data

FrankG — Wed, 21 Nov 2007 08:15:53 GMT

We have a 5.04 version of WS_FTP Server upgraded to version 6.1 with SSH.

Our old user database was formerly configured via an ODBC connection and is
running on MS SQL Server. After the installation was finished we migrated all
the user data with "dbconfig.exe" from PostgreSQL to MS SQL Server successfully.

All user home directories contain six special subfolders which are necessary
for our application.

After we have done the first user synchronization we lost the most of these
subdirectories and from originally 361 users only 194 was left in "ws_ftp_server"
database.

The effect is reproducable as follow:
1) create a new host with ODBC data source
2) create a new user "extern" , looked to it's home folder
3) create a new user "EXTERNAL" , looked to it's home folder
4) put a file into the homefolder of "extern"
5) press the synchonize button in the users administration

A second strange effect is that we lost all specific permission sets, inclusive
the one from System Administrator!