Server memory blow please help

[swish]

OK, its not premission. Its not the problem. I get access to the DB.
I just cant get rid of the error 1017.
Any clues how to fix it ?

Thanks,
Swish.

[swish]

I got it all working. I can access the DB now.

But I still having the memory blow after I used Angelox's sqls without being careful (no hard feelings).

Angelox: any way you can help me remove the lines I'v added by your sqls please ?

Thx.

[Angelox]

Originally Posted by bongol

I got it all working. I can access the DB now.

But I still having the memory blow after I used Angelox's sqls without being careful (no hard feelings).

Angelox: any way you can help me remove the lines I'v added by your sqls please ?

Thx.

This is why you have to always back up first - post me a back up of your database somewhere and I will download/look/test it.
MAKE SURE you compress it first with RARE or what ever, before you post it

[eq4me]

Yesterday: A DBA's backup song
(To be sung to the tune of Yesterday)


Yesterday,
All those backups seemed a waste of pay
Now my database has gone away
Oh I believe in yesterday

Suddenly,
There's not half the files there used to be
And there's a deadline
hanging over me
The system crashed so suddenly.

I pushed something wrong
What it was I could not say
Now my data's gone
and I long for yesterday-ay-ay-ay.

Yesterday,
The need for back-ups seemed so far away.
Thought all my data was here to stay,
Now I believe in yesterday.



Sorry, couldn't resist.

Seriously. Get a good beginners book about Linux adminstration and try to be more paranoid when it comes to important data.

[Angelox]

Originally Posted by eq4me

Yesterday: A DBA's backup song
(To be sung to the tune of Yesterday)


Yesterday,
All those backups seemed a waste of pay
Now my database has gone away
Oh I believe in yesterday

Suddenly,
There's not half the files there used to be
And there's a deadline
hanging over me
The system crashed so suddenly.

I pushed something wrong
What it was I could not say
Now my data's gone
and I long for yesterday-ay-ay-ay.

Yesterday,
The need for back-ups seemed so far away.
Thought all my data was here to stay,
Now I believe in yesterday.



Sorry, couldn't resist.

Seriously. Get a good beginners book about Linux adminstration and try to be more paranoid when it comes to important data.

Man, I really feel bad about this, I might be able to fix his database - But I don't know how it could have gotten damaged if these sqls worked for everyone else.
It could have been just a freak thing where the database got corrupted during the update process or, it could be the extra data needs more memory? his machine doesn't have much memory -anyways, If I can get my hands on it, I might be able to salvage it.

[swish]

Cant really download it its on my host and wont let me download it heh.

Maybe I can PM you the password ? Or maybe give you access to the DB ?

Swish.

[eq4me]

Dont feel bad Angelox. As far as I am reading it he is back to his original problem. That was before he inserted your SQLs(?). So it isnt your fault.
I am in the businness for over 10 years and at some point I stopped to feel sorry for people who regard backups as unneccessary.

Its all about not making the same mistake twice.
What I would do: Get a fresh PEQ database and switch the Server temorarily to this DB. Does the EQEmu Server still use massive ammounts of RAM?

[swish]

Lol bro, I said no hard feelings =P

I dont blame anyone but myself heh. But it was caused because of inserting these sqls. I should have backed it up heh.

I just need to know how to erase these things.

Thanks,
Swish.

[Angelox]

Originally Posted by bongol

Lol bro, I said no hard feelings =P

I dont blame anyone but myself heh. But it was caused because of inserting these sqls. I should have backed it up heh.

I just need to know how to erase these things.

Thanks,
Swish.

Like I said, make a back up of your database, compress it with something (zip, rar, etc) then post it and give me the link so I can download / install here - I'll try and find and fix the problem for you.
I really don't think these sql's did the damage -
What most I worry about is, if someone has a database with work already done, then installing mine could interfere or not all go in due to duplicate numbers (not crash the whole database).
Reality of all this is, if you want to depart from the original 7.0 installer for windows, and start doing your own stuff - then you need to learn stuff mysql, perl, and if Linux; basic Unix first.
I know enough Unix/Linux to have a Linux EqEmu server - but chose a windows server instead, because I knew I had to learn Mysql, Perl, and would be working out Linux issues also, not to mention most the support, tools are in windows.

[Angelox]

Originally Posted by bongol

Cant really download it its on my host and wont let me download it heh.

Maybe I can PM you the password ? Or maybe give you access to the DB ?

Swish.

I don't get it - where is your host? at your house? anyways if you want PM me the PW and I'll try back it up from here.
I don't really like to use PM a lot because all this that happens teaches others what to do (or what not to do). It's better to keep things open for the rest here.
But PM me the password -
Tell me what system you have running and where (if it is close to you like at home, or on a far off server). It sounds like your host controls you , instead of you control your host.

[swish]

Alright heh, its working now =D
I deleted all the loot drops and tables that i'v inserted from the sql from the DB.
The problem was the loots somehow heh.

Anyway, sorry for the mess and everything.
Thanks for supporting guys =D

I think your doing great job Angelox heh. Its all good now heh.
I just think you should make some warning in there =P

Anyways, cheers guys.

Thanks again,
Swish.

[Angelox]

Originally Posted by bongol

Alright heh, its working now =D
I deleted all the loot drops and tables that i'v inserted from the sql from the DB.
The problem was the loots somehow heh.

Anyway, sorry for the mess and everything.
Thanks for supporting guys =D

I think your doing great job Angelox heh. Its all good now heh.
I just think you should make some warning in there =P

Anyways, cheers guys.

Thanks again,
Swish.

You really should start saving your work, as i can assure this will not be the first time you loose what you are doing (there are more reasons to loose your data).
That's what they have back-ups
I haven't lost anything I wanted to keep in almost 20 years now.

[eq4me]

I am experimenting with an EQEmu Linux installation right now and it comes to my mind that maybe you didnt had enough shared memory.
Look in your logs or start a zone server and see if you find the following lines:

failed to get 0-length shared mem: Function not implemented
shmat failed! Invalid argument

To check your current shared memory limit setting do this

cat /proc/sys/kernel/shmmax

The Number you got is the size in BYTES

You can change that on the fly with this command. As an example let us set the size to 128 MB

echo 134217700 > /proc/sys/kernel/shmmax

To see an effect you should restart the EQEmu server after that.
After a reboot of the server the setting is gone. If you want to make it permanent you have to edit /etc/sysctl.conf (at least for Debian, Redhat/Fedora and derviates)
See if you already have an 'kernel.shmmax' entry you can modify. Otherwise add the line:

kernel.shmmax = 134217700

[Angelox]

Originally Posted by eq4me

Yesterday: A DBA's backup song
(To be sung to the tune of Yesterday)


Yesterday,
All those backups seemed a waste of pay
Now my database has gone away
Oh I believe in yesterday

Suddenly,
There's not half the files there used to be
And there's a deadline
hanging over me
The system crashed so suddenly.

I pushed something wrong
What it was I could not say
Now my data's gone
and I long for yesterday-ay-ay-ay.

Yesterday,
The need for back-ups seemed so far away.
Thought all my data was here to stay,
Now I believe in yesterday.



Sorry, couldn't resist.

Seriously. Get a good beginners book about Linux adminstration and try to be more paranoid when it comes to important data.

This song is hilarious - I've been passing it around to some friends

[eq4me]

Originally Posted by Angelox

This song is hilarious - I've been passing it around to some friends

There are more.

http://paul.merton.ox.ac.uk/computing/beatles.html