Logins + passwords when migrating from ASE 12.5.4/Linux x86 32bit to ASE 15.0.3/Solaris SPARC 64bit

Hi,

I'd like to migrate one of our databases from ASE 12.5.4 to ASE 15. Source server is running on Linux x86 32bit, target server is Solaris SPARC 64bit. Cross-plattform dump and load works fine.

The problem arises with logins/passwords. I've copied the contents of syslogins from the old server to the new one, but I can't log in using one of the manually migrated logins. 

Checking syslogins, I noticed that the password hashes on ASE 15 look different. Old hashes are just 60 characters long, the new ones 84 characters.

According to Michael Peppler's ASE on Linux FAQ, there's trace flag 1650 for this, but it's supposedly only available on Linux (http://www.peppler.org/FAQ/linux.html#q1.20).

Can the passwords be converted somehow, or will I have to reset them?

TIA, Jochen

0
Jochen
4/2/2009 4:48:57 AM
sybase.ase.upgrades+migration 687 articles. 0 followers. Follow

2 Replies
1409 Views

Similar Articles

[PageSpeed] 30

"Jochen Schug" <news@expires-20090701.17z.de> wrote in message 
news:op.urqszvjj1xju3j@17z.de...
> Hi,
>
> I'd like to migrate one of our databases from ASE 12.5.4 to ASE 15. Source 
> server is running on Linux x86 32bit, target server is Solaris SPARC 
> 64bit. Cross-plattform dump and load works fine.
>
> The problem arises with logins/passwords. I've copied the contents of 
> syslogins from the old server to the new one, but I can't log in using one 
> of the manually migrated logins.
> Checking syslogins, I noticed that the password hashes on ASE 15 look 
> different. Old hashes are just 60 characters long, the new ones 84 
> characters.
>
> According to Michael Peppler's ASE on Linux FAQ, there's trace flag 1650 
> for this, but it's supposedly only available on Linux 
> (http://www.peppler.org/FAQ/linux.html#q1.20).
>
> Can the passwords be converted somehow, or will I have to reset them?

I don't know of a proved solution but I'm wondering if
- creating a small user_db on ASE12.5.4
- copy master..syslogins into a table in the user_db
- dump the user_db and load it into the ASE 15 server, this will take care 
of cross-platform issues.
- copy syslogins from the user_db to master.
would work ...
Probably not, since you see different lengths.

Luc.



0
Luc
4/2/2009 6:33:12 AM
On Thu, 02 Apr 2009 08:33:12 +0200, Luc Van der Veurst <dba_azvub@hotmail.com> wrote:

> I don't know of a proved solution but I'm wondering if
> - creating a small user_db on ASE12.5.4
> - copy master..syslogins into a table in the user_db
> - dump the user_db and load it into the ASE 15 server, this will take  
> care
> of cross-platform issues.
> - copy syslogins from the user_db to master.
> would work ...
> Probably not, since you see different lengths.

I copied the data using bcp, so there shouldn't be a problem with endianess. Seems that the password hash functions on Solaris and Linux are different.

Jochen

0
Jochen
4/2/2009 7:09:24 AM
Reply:

Similar Artilces:

Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, We are in the process of planning the upgrade of our ASE 12.5.4 dataservers to ASE 15.x. What is the most recommended way to upgrade ASE dataservers from ASE 12.5.4 to ASE 15.x? Potential options: 1) Install new instances of ASE 15.x and load database dumps from our ASE 12.5.4 dataservers to the newly installed ASE 15.x dataservers. - OR - 2) Use the ASE upgrade utility (sqlupgrade) to upgrade our existing ASE 12.5.4 dataservers to ASE 15.x. What are the Pros vs. Cons for loading a 12.5.4 database into a 15.x ASE dataserver versus performing an ASE dataserv...

Migration from ASE 12.5.3 (Win 32bit) to ASE 15.0.2 (Unix 64 bit) question
Hi, I would like to migrate an ASE 12.5.3 on a Microsoft 32-bit server to an ASE 15.0.2 on Linux (or Solaris) 64-bit server. What steps must I follow? Is it a good idea to use a Replication Server 15 as intermediate task (consultant advice)? Thanks, Lorenzo My current ASE has a total size of 350Gb , 2400 connections, 2.6 Gb of memory... With ASE 12.5.3 you're suppose to be able to perform cross platform dump-n-loads (XPDL), where 'cross platform' basically means different OS's and/or different endian hardware. This (obviously?) assumes you'll be using ...

Migration from ASE-64 bits 12.5.0.2 to ASE 64 bits 12.5.3 for AIX 5.3
Here there someone to indicate me the road tasks in order to migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 bits) Thank you kamel wrote: > Here there someone to indicate me the road tasks in order to > migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 > bits) > > Thank you Apply 12.5.2 IR then 12.5.3 esd 5. -- Jason L. Froebe http://jfroebe.livejournal.com http://www.propsmart.com Team Sybase On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote: > Here there someone to indicate me the road tasks in order to migrate an > ASE 12.5.0.2 ...

Upgrade to ASE 15..0.3 from ASE 12.5.4
I'm currently planning to do an upgrade in place from ASE 12.5.4 to ASE 15.0.3 using sqlupgrade(res) utility. Does it just run the installmaster and instmsgs.ebf scripts ? Will I have to manually run the rest of the scripts i.e. installsecurity, installdbccdb etc.? Also in ran the preupgrade program against my old server - the main errors it came up with were: Stored Procedure '' uses deprecated builtin functions as: 'rowcnt', which should be changed to 'row_count'. It doesn't show the stored procedures name - has anyone had this problem ? Re...

ASE 12.5 32bit to ASE 15.0 64bit upgrade
What are the steps to upgrade from 12.5 32bit to 15.0 64bit on AIX 5.3? The 15.0.1 Installation Guide describes the normal 15.0 upgrade process but then has a terse section towards the end, "Migrating from 32-bit to 64-bit version", that describes other steps. Are these steps in addition to the normal upgrade process (sqlupgrade) or are they in place of sqlupgrade? Do I really have to drop and re-create all compiled objects (step 12 under Method #3: Replacing the binary)? Keith Wonderly wrote: > > What are the steps to upgrade from 12.5 32bit to 15.0 64bit >...

ASE 12.5.0.3 to ASE 12.5.4 upgrade path
I would like to know if the migration from ASE 12.5.0.3 to 12.5.4 a direct migration or is there an intermediate upgrade to be performed in between? Take a look at the release bulletins and installation guides for your platform. These are the first steps to any upgrade. http://sybooks.sybase.com/nav/detail.do?docset=1287 <passerby> wrote in message news:484e9ca8.3f0d.1681692777@sybase.com... >I would like to know if the migration from ASE 12.5.0.3 to > 12.5.4 a direct migration or is there an intermediate > upgrade to be performed in between? ...

Upgrade ASE 12.0/64 bit on AIX 4.3.3 to ASE 12.5.x/64 bit on AIX 5.2
Trying to find what is the supported upgrade path for the above. Going from 12.0/64bit on AIX 4.3.3 to 12.5 (or 12.5.x) 64bit on AIX 5.2. If I put AIX 5.2 , the dataserver binary of 12.0 will not work which is used during the upgrade. If I put 12.5.x on 4.3.3, the dataserver binary will not work beacuse it is new binary for 5.2. Other than backup the databases and load them to the new server, is there a supported how to upgrade? Thanks! ...

upgrade from ASE 12.5.3 to ASE 15.0.2 ESD#4
What are the correct steps to upgrade from ASE 12.5.3 to 15.0.2#4? 1. Upgrade ASE 12.5.3 to ASE 15.0, then from ASE 15.0 to ASE 15.0.2#4 or 2. Upgrade ASE 12.5.3 to ASE 15.0.2 ESD#4 Thanks, liyp liy wrote: > What are the correct steps to upgrade from ASE 12.5.3 to 15.0.2#4? > > 1. Upgrade ASE 12.5.3 to ASE 15.0, then from ASE 15.0 to ASE 15.0.2#4 > > or > > 2. Upgrade ASE 12.5.3 to ASE 15.0.2 ESD#4 > I did #2. At one point I considered upgrading to 15.0.2 GA and then to ESD#4, but the $SYBASE/ASE/upgrade/upgrade program looks to b...

Migration from ASE 12.0 ( HPUX ) to ASE 12.5 ( Solaris 8 )
Hi, I'd like to migrate an ASE 12.0.0.3 (roman8) on HPUX 11 with many DBs to an ASE 12.5.0.3 (*roman8*) on Solaris 8. I know it's not the default charset on solaris. I've made dump on HPUX, copy it on Sun box and load it. I know it's not supported by Sybase ( cross plateform dump ). However, it seems to be OK, the upgrade works well, the dbcc (check table, alloc) did not reveal error. I think it's not supported only because the charset deffers ( by default ) on the plateform. What do you think of this ? is there others checks to do ? What kind of corruption or...

Upgrade ASE 12.5.3 to ASE 15.0
Can I upgrade my ASE Server 12.5.3 ESD #3 to ASE15.0 without any problems? According to a ESD #2 notice, if I do this it may regress the bug compatibility?. What exactly does that mean? What should I do instead? Deborah, Brown wrote: > Can I upgrade my ASE Server 12.5.3 ESD #3 to ASE15.0 > without any problems? > > According to a ESD #2 notice, if I do this it may regress > the bug compatibility?. What exactly does that mean? What > should I do instead? It means that most of the bugs fixed in 12.5.3 ESDs haven't yet been forward-ported to 15.0....

Upgrade from ASE 12.5.0.3 to ASE 12.5.1
This is a multi-part message in MIME format. ---=_forums-2-dub3ff97039 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I've just upgraded from ASE 12.5.0.3 to ASE 12.5.1. I tried to start the server, but it won't startup. Here is the message: sybase(ASE1250)328 /app/sybase/ASE-12_5/install --> startserver -f RUN_AMXDB sybase(ASE1250)329 /app/sybase/ASE-12_5/install --> 00:00000:00000:2004/01/05 21:37:44.10 kernel Use license file /app/sybase/SYSAM-1_0/licenses/license.dat. 00:00000:00000:2004/01/05 21:37:44.10 ker...

Where can I get the ASE 12.5.4 or ASE 12.5.3 for Linux?
Hi, all : I want to get the ASE12.5.4(DE) for Linux; but In the sybase.com,just have ASE 15.0.3 for download. Now, Where can I get the ASE 12.5.4(DE or XE) for Linux? Thank you! ----------------- Best Regards! On May 22, 6:10 pm, "Killwind" <killwin...@sina.com> wrote: > Hi, all : > I want to get the ASE12.5.4(DE) for Linux; > but In the sybase.com,just have ASE 15.0.3 for download. > Now, Where can I get the ASE 12.5.4(DE or XE) for Linux? Go to www.sybase.com -- in the upper-right-hand corner is a "Search" box. Search for...

ASE 12.5.0.3 to ASE 15.02 EBF2 upgrade
Hello All, I'm testing my upgrade from Adaptive Server Enterprise/12.5.3/EBF 12600 ESD#3/P/Linux Intel/Enterprise Linux/ase1253/1911/32-bit/ to Adaptive Server Enterprise/15.0.2/EBF 15101 ESD#2/P/x86_64/Enterprise Linux/ase1502/2516/64-bit/FBO/Thu Dec 20 01:26:11 2007 OS: RHEL 5 so far some db are been upgraded nice some I have issues , here is one of my error: ( mentioned this db has replicated tables from other site) Any tips ? 1>online database hstspss 2> go Started estimating recovery log boundaries for database 'hstspss'. Database 'hst...

Linux 64 bits migration ASE-12.5.4 --> 15.0.2
Hello We are in the process to migrate from 12.5.4 to 15.0.2 on a Linux 64 bits machine the 15.0.2 installation ran well and the bases started. Now we are trying to dump all the 12.5.4 bases ( works ok ) and load dump files into the 15.0.2 server, some of the bases are broken ... Any infos/links welcome Thank you Frank You may want to consider posting some details (eg, dump/load commands, associated errors, @@version strings). Alternatively you could open a case with Sybase TechSupport. Frank Bonnet wrote: > Hello > > We are in the process to migrate from ...

Web resources about - Logins + passwords when migrating from ASE 12.5.4/Linux x86 32bit to ASE 15.0.3/Solaris SPARC 64bit - sybase.ase.upgrades+migration

Password strength - Wikipedia, the free encyclopedia
Password strength is a measure of the effectiveness of a password in resisting guessing and brute-force attacks. In its usual form, it estimates ...

California Employers, College Administrators Can’t Ask For Facebook Passwords
As the link between Facebook usage and work comes under closer scrutiny, several states have made it a law that employers cannot request social ...

Protecting Your Passwords and Your Privacy
Facebook and Privacy hat eine Notiz mit dem Titel Protecting Your Passwords and Your Privacy geschrieben. Du kannst den vollständigen Text hier ...

New Facebook Security Features: One-Time Passwords, Security Info
Facebook has launched two new security features to help users stay in control of their accounts. Users can now receive a one-time password from ...

How to view saved Wi-Fi passwords in Windows 10, Android and iOS
So many stores, service stations, coffee shops, pubs and so on offer free Wi-Fi that you probably have countless networks saved on your phone ...

The absolute worst Wi-Fi password ever revealed in viral video
OK, so we all know about how many people are still using passwords like "password" and "1234" to secure their Wi-Fi hotspots, but a new viral ...

Google tests password-free logins
Google has confirmed it is testing a way for users to log in to its services using just their smartphone and no password.

2015 trends: The evolution of password security
Why you should get on board with fingerprint sensors and two-factor authentication.

Google tries again to kill the password, tests new auth idea via your phone
Google is testing a new authentication method. In a bid to get rid of the password, la GOOG will instead pop up a prompt on your phone, asking ...

Ditch the sticky notes to keep your passwords handy and secure
In this age of cyber theft, keeping your passwords on a pad of paper or (even worse) an online document just won’t cut it, no matter how indecipherable ...

Resources last updated: 1/4/2016 2:43:47 AM