User synchronize button destroys data

To the Ipswitch web site

Ipswitch Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



User synchronize button destroys dataExpand / Collapse
Author
Message
Posted 11/21/2007 8:15:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 3/20/2008 9:04:32 AM
Posts: 8, Visits: 33
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!

Post #38751
Posted 11/21/2007 6:59:16 PM


Forum Guru

Forum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum Guru

Group: Forum Members
Last Login: 4/29/2008 3:07:20 PM
Posts: 53, Visits: 56
I have not seen that occur, were you going between different versions of SQL perhaps?

Ipswitch QA Team
Post #38775
Posted 1/4/2008 11:33:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 3/20/2008 9:04:32 AM
Posts: 8, Visits: 33
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.

Post #39722
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Dave, kevin r gillis

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 1:02pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 10 queries. Compression Enabled.