Register forum user name Search FAQ

Gammon Forum

Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the password reset link.

Due to spam on this forum, all posts now need moderator approval.

 Entire forum ➜ PennMUSH ➜ Running the server ➜ Database blues

Database blues

It is now over 60 days since the last post. This thread is closed.     Refresh page


Posted by Tidalwv   USA  (5 posts)  Bio
Date Sat 22 Sep 2001 06:30 PM (UTC)
Message
Is there anyway to convert a Win32 database over to UNIX-readable format, even if by hand?
Top

Posted by Nick Gammon   Australia  (23,173 posts)  Bio   Forum Administrator
Date Reply #1 on Sat 22 Sep 2001 10:23 PM (UTC)
Message
They should be directly compatible, excepting perhaps the line endings. In the PennMUSH section of the Downloads page (see button at top of page) are utilities for converting from Unix to DOS (or vice-versa) line endings.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by Tidalwv   USA  (5 posts)  Bio
Date Reply #2 on Sun 23 Sep 2001 01:23 AM (UTC)
Message
The file converters I assume?

The answer is probably painfully obvious, but how would I use it? Temporarily make the database a .txt file, place it in the directory of the program, then run the program?
Top

Posted by Nick Gammon   Australia  (23,173 posts)  Bio   Forum Administrator
Date Reply #3 on Mon 24 Sep 2001 09:35 PM (UTC)

Amended on Mon 24 Sep 2001 09:37 PM (UTC) by Nick Gammon

Message
Put the program somewhere in your path (eg. C:\WINDOWS), then open a "Dos" window. Change to the "game\data" directory and type:


DOS2UNIX INDB


(or replace INDB by OUTDB or whatever is appropriate).

Alternatively, if you "ftp" the file over to your Unix PC, using "text" translation mode, the translation will be done for you automatically.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by Vanne De Castle   (2 posts)  Bio
Date Reply #4 on Mon 01 Oct 2001 07:50 AM (UTC)
Message
there is also another handy way, all you do is load your database file through WS-ftp, and then save it again.

hope that helps.
Vanne
Top

Posted by Tidalwv   USA  (5 posts)  Bio
Date Reply #5 on Fri 02 Nov 2001 12:55 AM (UTC)
Message
Okay, I'm still having troubles, but this time I come with the error messages from the log file:

11/01 08:47:44 Reading alias.cnf
11/01 08:47:44 Reading restrict.cnf
11/01 08:47:44 CONFIG: directive 'exit_flags' missing from cnf file, using default value.
11/01 08:47:44 ANALYZING: data/indb
stdin: not in compressed format
11/01 08:47:44 ANALYZING: data/indb (done)
11/01 08:47:44 LOADING: data/indb
stdin: not in compressed format
11/01 08:47:44 ERROR: failed object 0
11/01 08:47:44 ERROR LOADING
11/01 08:47:44 ERROR: Couldn't load databases! Exiting.

Can somebody help?
Top

Posted by Nick Gammon   Australia  (23,173 posts)  Bio   Forum Administrator
Date Reply #6 on Sun 04 Nov 2001 08:56 AM (UTC)
Message
In your file mush.cnf you may need to fiddle with the compression options. Since the error message is "not in compressed format" try making the compression options blank, like this:


# Use these 3 lines for no compression. Required on win32.
compress_program
uncompress_program
compress_suffix

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by Tidalwv   USA  (5 posts)  Bio
Date Reply #7 on Mon 05 Nov 2001 02:21 PM (UTC)
Message
I changed the compression stuff, and now I'm getting these errors:

11/04 22:20:48 ANALYZING: data/indb
11/04 22:20:48 ANALYZING: data/indb (done)
11/04 22:20:48 LOADING: data/indb
11/04 22:20:48 ERROR: Bad character 1 (49) in attribute list on object 0
11/04 22:20:48 (expecting ], >, or < as first character of the line.)
11/04 22:20:48 No attributes had been read yet.
11/04 22:20:48 ERROR: bad attribute list object 0
11/04 22:20:48 ERROR LOADING
11/04 22:20:48 ERROR: Couldn't load databases! Exiting.
Top

Posted by Nick Gammon   Australia  (23,173 posts)  Bio   Forum Administrator
Date Reply #8 on Mon 05 Nov 2001 08:28 PM (UTC)
Message
There is something weird about your database, possibly caused by the line endings. Try listing the first 20 lines and see if they look reasonable (eg. edit them in vi on Unix, and Notepad on Windows and make sure they look the same). You shouldn't see any "funny" characters (like ^M) when you edit the file.

If you can't work it out post the first 20 lines here.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by Tidalwv   USA  (5 posts)  Bio
Date Reply #9 on Mon 05 Nov 2001 10:49 PM (UTC)
Message
Here's the #0 object. I couldn't catch anything wacky.

+V1047554

~242

!0

"Plaza <OOC World>"

-1

104

214

-1

-1

1

235

0

32768

0

0

0

986325975

1002051375

]DESCRIBE^4^66080

"%r[ansi(hy, --------------------------------------------------------------------------------)]%r%tA fairly large, open-aired plaza, decorated Spanish style. Various places branch off, providing information about the gameworld, or a place to just OOCly hang out. Cheesy theme park music plays in the background while costumed characters wander about, depicting important people in the gameworld.%r%r%t[ansi(hw, Places to go:)]%r%t[ansi(hc, <)][ansi(hg, M)][ansi(hc, > )] [ansi(hg, Museum)]: See examples of people from social classes and professions.%r%t[ansi(hc, <)][ansi(hg, CC)][ansi(hc, > )] [ansi(hg, Cast and Crew)]: See the in-game NPCs and the staff.%r%t[ansi(hc, <)][ansi(hg, R)][ansi(hc, >)] [ansi(hg, Regester)]: Apply for a character. GUESTS: Logoff and at the login screen, create a character with the name you want before you proceede here.%r%t[ansi(hc, <)][ansi(hg, E)][ansi(hc, >)] [ansi(hg, Examples)]: Examples to help if you were going to have a home built, or other things like that. Gives examples of basic things and allows you to expand for your purposes.%r%t[ansi(hr, RP)]: Takes you to the gameworld. [ansi(hr, !RP)]: Will bring you back here.%r[ansi(hy, --------------------------------------------------------------------------------)]%r"

<
Top

Posted by Nick Gammon   Australia  (23,173 posts)  Bio   Forum Administrator
Date Reply #10 on Tue 06 Nov 2001 01:11 AM (UTC)
Message
Judging by the source code the bad character is literally the number "1". I can't see why it is saying that. I can only suggest you zip up the first few hundred lines of the database and email it to me so I can see why it is saying that.

eg. do something like this:


head -200 indb | gzip -c > nick.gz


This will compress the first 200 lines into "nick.gz" which you can then email to me.


- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.


32,176 views.

It is now over 60 days since the last post. This thread is closed.     Refresh page

Go to topic:           Search the forum


[Go to top] top

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.