[Release] Perfect World Server 1.4.4 - Basic Setup

Quote:

---

Originally Posted by cogame

i got this error when trying to excute the mysql_procedures.sl

Error
searching SQL:

CREATE PROCEDURE `usecash`( in userid1 INTEGER, in zoneid1 INTEGER, in sn1 INTEGER, in aid1 INTEGER, in point1 INTEGER, in cash1 INTEGER, in status1 INTEGER, out error INTEGER ) BEGIN DECLARE sn_old INTEGER; DECLARE aid_old INTEGER; DECLARE point_old INTEGER; DECLARE cash_old INTEGER; DECLARE status_old INTEGER; DECLARE createtime_old DATETIME; DECLARE time_old INTEGER; DECLARE need_restore INTEGER; DECLARE exists1 INTEGER; DECLARE rowcount INTEGER; START TRANSACTION; SET error = 0; SET need_restore = 0; SELECT SQL_CALC_FOUND_ROWS sn, aid, point, cash, status, creatime INTO sn_old, aid_old, point_old, cash_old, status_old, createtime_old FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn >= 0; SET rowcount = FOUND_ROWS(); IF rowcount = 1 THEN SET exists1 = 1; ELSE SET exists1 = 0; END IF; IF status1 = 0 THEN IF exists1 = 0 THEN SELECT aid, point INTO aid1, point1 FROM usecashnow WHERE [...]

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 95

---

You are not going to import the file like the other one...
->Open the mysql_procedures.sql with any text editor...
->Select you database pw
->Go on SQL
->Copy and Pate the contents of the mysql_procedures.sql into it... and change the delimitir from ; to $$...
->If you still get an error... you can remove the two firt lines:
*DELIMITER $$
*use pw$$
.. and try again


I noticed this error before too... but rememmber.. you are not using the function Import... you are using the SQL to work with the 2nd file..

What about the ones that already have a flavor of linux installed? Or is just better to do a fresh install?

I don't know how to get out of my 1.3.6 root system.

When I try

apt-get install PWS144-Base.rar

it tells me it can't locate it. So I tried sticking it in that root folder(or what I assumed was)..same thing. As a way of guess work, I unpacked it the old fashion way(via winrar).

Basically, all I need to know is how to unpack this, the rest I can do easily. Already have the client setup and the database setup, just not the server.


I just hate being unsavy in things..

Any hope of a x64-bit Windows OS running a vm running this? or am I S.O.L until I get my lazy ass working on my "out-of-commission" Linux OS?

Quote:

---

Originally Posted by Selenica

What about the ones that already have a flavor of linux installed? Or is just better to do a fresh install?

I don't know how to get out of my 1.3.6 root system.

When I try

apt-get install PWS144-Base.rar

it tells me it can't locate it. So I tried sticking it in that root folder(or what I assumed was)..same thing. As a way of guess work, I unpacked it the old fashion way(via winrar).

Basically, all I need to know is how to unpack this, the rest I can do easily. Already have the client setup and the database setup, just not the server.


I just hate being unsavy in things..

---

In your case is a better idea start a fresh installation... and maybe get more familiar with Linux?!

apt-get install PWS144-Base.rar <- this command wont work... i had to make a dedicated link repository for that, wich i can say for sure im not going to do.

Besides you can easily download the *decompressed* files through a program like WinSCP or FileZila using an SFTP connection (thats why the needind of the OpenSSH)

I see. Well I'll do a fresh install then. And command use in linux I'm definetly lacking in knowledge in.

Quote:

---

Originally Posted by Dysmo

Any hope of a x64-bit Windows OS running a vm running this? or am I S.O.L until I get my lazy ass working on my "out-of-commission" Linux OS?

---

I have 64bit Win 7, using a vm to run one. Just get the ubuntu SERVER EDITION(there is a 64bit version). Assuming this applies for 144

Refer to this post: http://forum.ragezone.com/6233360-post2.html

Quote:

---

Originally Posted by Dysmo

Any hope of a x64-bit Windows OS running a vm running this? or am I S.O.L until I get my lazy ass working on my "out-of-commission" Linux OS?

---

Even if you have a supreme build with good SSDs/Processors/Memorys it wont be as good as it should be in a dedicated Linux server... maybe if the server files were ported to Win 32/64.. but thats not the case...


But everthing just depends of what you want... i suppose you still can have some fun playing with a few ppl if you were running on a VM machine... but if your main target is a big server... thats definitely not recommended =]

Um... Got a matrixpwd error on gdeliveryd

Quote:

---

TRACE : gdelivery: :passwdtimeout. user=khangvn08

---

and then a cache missing error too.
Thus, it got me the Server network error.
Any help will be appreciated.

Quote:

---

Originally Posted by khangvn10

Um... Got a matrixpwd error on gdeliveryd

and then a cache missing error too.
Thus, it got me the Server network error.
Any help will be appreciated.

---

sometimes if you were running the server before everthing is set.. you may get this error...

try add an account and then start you server...

if you are using everthing fresh.. i can garantee that it will work just fine...
but if you are replacing old files, not sure what problem you might have...

I tested on Debian 6.0.4, Unbuntu 10.04, Kunbuntu 11.10...
But i used fresh installations...

I set all the IP in hosts file to 127.0.0.1, but my server's IP is 192.168.61.129, so which do I need to replace in host file?

Quote:

---

Originally Posted by khangvn10

I set all the IP in hosts file to 127.0.0.1, but my server's IP is 192.168.61.129, so which do I need to replace in host file?

---

Code:

---

127.0.1.1  kunbuntu  <- replace with your previous configured server name

---

normally the instruction above is all you have to do... but i guess this case will work better if you are using a DCHP configuration...

If you have an static IP do as follow:

Code:

---

192.168.61.129  your-server-name

---

also take a look in /etc/network/interfaces and check if the configuration is set to your IP..
If you still have some doubts about how to configure the interfaces, take a look here: /etc/network/interfaces Ubuntu Linux networking example... its a good guide for starting

Quote:

---

Originally Posted by asgborges

Even if you have a supreme build with good SSDs/Processors/Memorys it wont be as good as it should be in a dedicated Linux server... maybe if the server files were ported to Win 32/64.. but thats not the case...


But everthing just depends of what you want... i suppose you still can have some fun playing with a few ppl if you were running on a VM machine... but if your main target is a big server... thats definitely not recommended =]

---

Thanks, mainly I want this for a personal server, for just me, and maybe someone running on a LAN could join, but not aiming for a commercial server. I'm installing x64 ubuntu atm, thanks for the info above and the fast responses, and Thank you asgborges for the files+guide. :)


EDIT: I'm almost done setting up the 1.4.4 server, but the only thing I couldn't get working was the "serverip/register/register.php", I have all the files directly added to the /root folder, and have phpmyadmin set up, but it still won't work, it just gives me a 404 error, any ideas?
(I've tried 127.0.0.1, 127.0.1.1, and my personal IP, and none work.)


EDIT 2: I also get this on PwAdmin: Connection to MySQL Database Failed

Quote:

---

Originally Posted by Dysmo

Thanks, mainly I want this for a personal server, for just me, and maybe someone running on a LAN could join, but not aiming for a commercial server. I'm installing x64 ubuntu atm, thanks for the info above and the fast responses, and Thank you asgborges for the files+guide. :)


EDIT: I'm almost done setting up the 1.4.4 server, but the only thing I couldn't get working was the "serverip/register/register.php", I have all the files directly added to the /root folder, and have phpmyadmin set up, but it still won't work, it just gives me a 404 error, any ideas?
(I've tried 127.0.0.1, 127.0.1.1, and my personal IP, and none work.)

---

Is your problem phpmyadmin or the registration script.

This is the fix I used to get phpmyadmin working.

Spoiler:

Does /etc/apache2/conf.d/phpmyadmin.conf exist? If not, does /etc/phpmyadmin/apache.conf exist?

If the first doesn't exist and the second does, try:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
sudo /etc/init.d/apache2 restart

Quote:

---

Originally Posted by jh281978

Is your problem phpmyadmin or the registration script.

This is the fix I used to get phpmyadmin working.

Spoiler:

Does /etc/apache2/conf.d/phpmyadmin.conf exist? If not, does /etc/phpmyadmin/apache.conf exist?

If the first doesn't exist and the second does, try:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
sudo /etc/init.d/apache2 restart

---

I figured out why phpmyadmin wasn't working, but I have another problem right now, it seems everytime I try to execute Start.sh, the files associated with it have their permissions denied, but when I go to the files they are allowed. (I used chmod 777 on all of the pw files and their folders.)

EDIT: Never mind, I got around the permissions, but now it says:

=== LOGSERVICE ===
cd: 14: can't cd to /root/logs/logservice
/root/start.sh: 14: ./logservice: not found

The file is there with the correct permissions, but does not run. Any thoughts?



EDIT 2: I also get this on PwAdmin: Connection to MySQL Database Failed

hhhmmm not sure on that one....I'm trying to get passed the matrixpasswd query, is not working I get the incorrect account name or password when i try to login.....

I figured out how come I got a network error. What you must change is the MySQL password in table.xml in both /etc/ and /root/mauthd/etc/.
Posted via Mobile Device