Quote:
|
Originally Posted by John Adams
Edit: Hey, guess what just happened to me? Empty server screen. I was changing over to PEQ database to test the Fabled Crush loot thingy, when I saw no servers. :O Looking into it, I saw the variables table, LoginType was set to Public (from when I ran a server), so Minilogin didn't show up. I changed it to "minilogin" and now all is well.
And I had to add a column to table: account for minilogin_ip, and set it to my machines IP address - but I imagine you already did that one.
|
Ah! Hah! You WERE right in a way. I followed the mySQL 5.0.23(?) setup guide under the server section as I wanted to use a recent mySQL version.
I copied and pasted the list of INSERT queries to the variables table, and NEVER checked them!
So, after reading about your comment wrt LoginType in the variables I went and checked it to find the %#^&^*&@%*&@$%7!!!! EMPTY!
So I tried the guide suggested copy and paste all INSERT query into the query browser, bang complains about duplicate ailevel. Ok, so I remove it try again, still complains about it. Look at the variables table, and only ailevel is present. WTF?!
Short story ended up adding all of those(for now) individually via query browser. (Should've dumped 'em into a text file and fed the via the CLI interface, but oh well...)
Bang! My server is now listed!
Haven't logged in and tried making a character, but will do that shortly...
Must also remember to go back and check everything else that I did through that POS query browser. (mySQL's own GUI tools suck badly...)
As to running everything on one machine, I figure it's more than capable of handling it. Even the initial peq database setup was only pushing it to about 25% utilization on ea. core, and with the 5 zones, I still see less than .5G of total memory usage... I'd run it on another machine if I had one with enough memory to bother with. I have an old 1G T-bird, but it has no drives and only 256M... also sitting as a bare mb + cpu + memory stick...
1H later,
well, you were also right sort of, in that I had to go change all of the listed IP addresses to be 127.0.0.1 . I suppose that localhost should work as well as it SHOULD be directly mapped to 127.0.0.1 anyways.
(I found the above, as while I could see the server and login it would kick me out with a log message telling me to verify my account in the account table. I did so, and created a second test account with the same results, then tried changing all of the IPs. I'm, obviously, not 100% sure that they ALL needed to be changed but it worked for me and allowed me to create a character.)
Now, I just have to figure out why my movement keys aren't moving me...