Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

batch import users with password field

2 posts in General Discussion Last posting was on 2007-04-12 14:20:47.0Z
haiyan Posted on 2007-04-03 18:55:31.0Z
Sender: 64af.461290ce.1804289383@sybase.com
From: haiyan@virginia.edu
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: batch import users with password field
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46129513.650d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Apr 2007 10:55:31 -0800
X-Trace: forums-1-dub 1175622931 10.22.241.41 (3 Apr 2007 10:55:31 -0800)
X-Original-Trace: 3 Apr 2007 10:55:31 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1062
Article PK: 17871

All accounts on our M-business server will be managed
accounts. Is there a way to import users with password field
into the server? Right now, only three fields are there, and
they are Username, Lastname, and Firstname. The version we
are running is 5.7 b1023 Windows.

Thanks much

Haiyan He
University of Virginia


David Fishburn Posted on 2007-04-12 14:20:47.0Z
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: batch import users with password field
From: David Fishburn <fishburn_spam@off.ianywhere.com>
References: <46129513.650d.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns99105F014443Efishburnsybasecom@127.0.0.1>
User-Agent: Xnews/2005.10.18 Hamster/2.1.0.0
NNTP-Posting-Host: 10.25.18.129
X-Original-NNTP-Posting-Host: 10.25.18.129
Date: 12 Apr 2007 06:20:47 -0800
X-Trace: forums-1-dub 1176384047 10.25.18.129 (12 Apr 2007 06:20:47 -0800)
X-Original-Trace: 12 Apr 2007 06:20:47 -0800, 10.25.18.129
Lines: 80
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1065
Article PK: 17872

haiyan@virginia.edu wrote in news:46129513.650d.1681692777@sybase.com
of ianywhere.public.mbusinessanywhere.general:

h> All accounts on our M-business server will be managed
h> accounts. Is there a way to import users with password field
h> into the server? Right now, only three fields are there, and
h> they are Username, Lastname, and Firstname. The version we
h> are running is 5.7 b1023 Windows.

In version 6.x there is a SOAP API which allows you to programmatically
access the AGDB database. I use this to import users/groups and
channels.

Since this is 5.7, obviously this API does not exist.
I do not believe there is a process to use.

So I would suggest this, though we do not recommend people to use the
AGDB database directly.

First, navigate to the page type in all the user information BUT do NOT
press Add/Ok.

Next, I would backup and truncate the transaction log of the AGDB
database. I am assuming you are somewhat familiar with SQL Anywhere
with the following commands:
dbbackup -c dsn=AGDB c:\backup -x

Now, press Add/Ok.

The SQL Anywhere transaction log has a record of what just happened
within the AGDB database. If you use the "DBTRAN" utility to translate
the transaction log you can see the statements just executed.

I am not certain whether the database password is stored
encrypted/encoded within the database or whether it is stored in plain
text.

If plain text, you are most likely off to the races. If encrypted, you
don't know how the password was encrypted. What you might be able
to do is create all users with the same encrypted password and tell
them they must all change their passwords. This assumes the userid
(or other data) is not added as part of the encryption key.

Shutdown the agdb database (dbsvc -x agdb) and then translate the log
file:
cd \where\ever\agdb.log.exists
dbtran agdb.log agdb.sql

Now restart the AGDB database:
dbsvc -u agdb

If the dbsvc.exe commands are only part of SQL Anywhere 9.x and not 8.x
which mBusiness ships with you can use Windows Service Manager or:
net stop ASANYs_AGDB
net start ASANYs_AGDB

You can use notepad (or you favourite editor) to view agdb.sql.

Please post an example of what was in the dbtran output file.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList