[Arcturus] Security Fix

[buzbee]

you need to go through all your stored procedures and replace the old db names with your new ones

 

[important]

you need to go through all your stored procedures and replace the old db names with your new ones

yes i know that.

But i cant find the old db name in Stored Procedures Properties could you show me the lokation where you edited your new databas names because i cant find it in Stored Procedures Properties.


Thx !

 

[buzbee]

i added you on msn

 

[WhyNot]

What should i write instead of Username1, Username2, pass1 and pass2?

 

[buzbee]

make something up

 

[WhyNot]

Ok, im done wit heverything now, but i have a new error...

Sql connection failed on login server...

I redid my ODBC and for seeven_ORA i changed default database to new seven_ORA db...
SHO to new SHO db ans SHO_LOG to new SHO_LOG db...

Any help? what have i done wrong?

 

[lCON]

The config needs to still say sho but have the new user/pass

 

[WhyNot]

ok, but i got it working now, but i am using windows nt verification...

so the dns should still be named SHO(for example) and the default databse should also still be SHO but i should not use windows nt verification and instead use the new user and pass?

 

[MyMomsAnIdiot]

guys where do i change the db names? into the sql's? but where is the name wrote there is so much matches for example like hundreds of seven_ora's in the seven_ora sql... =\

im confused

 

[Necro]

guys where do i change the db names? into the sql's? but where is the name wrote there is so much matches for example like hundreds of seven_ora's in the seven_ora sql... =\

im confused

Like icon said rename all the stored procedure to your new database names...

Let's say your database name was youraidiotSho then rename all your stored procedure from SHO to youraidiotsho inside the stored procedure.

Scroll up a little and look at buzbee's screenshot shows you where to find all your stored procedure in your databases.

Hope that helps.

 

[MyMomsAnIdiot]

Hello, in the step 5 what i should do is remove the SA (master) and grant permission all my 3 databases?.

 

[Necro]

Hello, in the step 5 what i should do is remove the SA (master) and grant permission all my 3 databases?.

Step 5. if you read my old post's asking about it the hint is there that is if you read each post for the security fix.

But run a query with step 5. run it under " Master " bam ! that is all.

 

[MyMomsAnIdiot]

i have read ur posts. but still a little bit confuse.. could u help me on msn mate? Professionalz7@hotmail.com
thanks.

 

[wolfwingx1]

Im facing this problem for like 12 hours now. I think i have tried everything. My mind it out of ideas atm to fix it -.-

It just keeps saying "sql connect failed ..." no matter what! Pretty frustrating, 12 hours in a row trying to fix this problem and nothing works.

at user dsn click seven_ORA or SHO or anyother dbase click configure and click next, now click next again. and you will see something called other database (dutch translation) *and put it on default if you can't select all your databases* click next and click finish test and click final ok if you have succes.
*just repeat the steps above but select the database you want to use.

hope it helps

 

[Dr. Dude]

Hmmm isnt this all more easy to edit the database install script when installing it all fresh?:$:

 

[Necro]

Hmmm isnt this all more easy to edit the database install script when installing it all fresh?:$:

Yup it is xD

 

[rakion27]

make a video tutorial please XD

 

[lCON]

Whats everyone want Vid tuts for this is so easy to understand.

 

[Hamscer]

buzbee, Would Tribal actually fix DC problem that occur when you teleport to maps ?

 

[lCON]

Question One was Buzz in this post? I must have missed it. And what are you referring to when you Say tribal? Are you talking about my tribalGuard?

And tribal Guard was coded to work with Inferno When it was Open a few had a version we did to use on None Inferno clients but them are rare. Also the teleport bug i think was an easy fix i just don't remember.