Keanu

Okay so after a lot of searching, and I mean a lot. I managed to find this on rAthean's forums. ./configure --enable-64bit --with-MYSQL_LIBS=/usr/lib64/libmysqlclient.so I didn't have lib64, however had lib, so all I had to do was run ./configure --enable-64bit --with-MYSQL_LIBS=/usr/lib/libmysqlclient.so And it compiled fine. I'm not entirely sure if i'm allowed to post rAthena links in here, so I won't, however i'd like to tag on a massive shout out and thank you to " Latheesan " from the rAthena forums for this fix, and hopefully it'll help someone else out on the Herc Forums. Please consider this topic closed. Regards,

I believe you have to to install libmariadbclient instead. Hi Secrets, Thanks for the suggestion. I'm unable to find libmariadbclient, however i've found libmariadbclient-dev. I'm pretty sure I did try this before, however will update in a second... Andddd. Sadly no luck! checking MySQL library (required)... no configure: error: MySQL not found or incompatible Thank you for the suggestion though! Kind Regards, -Keanu

Hi Shatowolf, Ive got no idea why but that seems to have worked?.... no errors or anything...? Can't help but feel it may have been a DNS caching problem. All working. Will drop an update after disabling debug mode and show exceptions, incase it causes issues! Thanks for the help and the quick reply!! Kind Regards, -Keanu Going to say it was a DNS issue, still working after changing those settings back. Thank you for your help. Mods, please feel free to close off this thread. Thanks!

Hi all, Having an issue with connecting Flux to the database, It just seems to time out after 20-30 seconds! Bit of background, i'm hosting the FluxCP on a webserver I managed to get it setup / installed by setting up a local sql database on the webserver with all the herc files, then re-uploaded them to the dedibox. (Jumping through hoops, eh?) Atleast now i'm not stuck on the installation page, however if I try to go anywhere inside of the panel, it times out after a period of time and displaysss; Error An error occurred while trying to process your request. Please try contacting an administrator: admin@localhost I've tried enabling debug mode, no luck, doesn't give me any info. I've made sure that the webhost server isn't blocking off ports 3306, and that php is able to connect to external SQL Databases, i've checked permissions, i've recreated the fluxcp database user, i've checked passwords, i've checked the forum, but still no luck, even checked rAthena's board, but no luck. Server doesn't have a firewall yet, i'm able to connect to the sql database using Navicat with the fluxcp credentials, I even swapped the fluxcp user over to % on the database incase it was me giving the incorrect ip! Slightly tearing my hair out here! I think the next thing i'm going to do (Which I don't think will help, but C'est la vie!) is swap it over to it's own hosting / own domain to clear off any problems on that side. (It's currently on a subdomain for testing purposes!) Any insights or ideas would be great. I can't help but feel it's going to be something really simple that i'm missing, and i'm going to feel like an idiot, but I just can't think what it'll be yet! Kind Regards, -Keanu

Hi Ridley, Thanks again for the reply. Please correct me if i'm wrong, but MariaDB should just be a replacement, rather than running both itself and MySQL alongside. Also, it seems that when MariaDB is installed, you can't install "libmysqlclient-dev", or much else for that matter. (lol!) so i'm not entirely sure how i'd run them side by side! Going by the link on my first post - https://github.com/HerculesWS/Hercules/commit/e1e5bd338fe507d23ac72c964efa5c7009c30bba it seemed there was a commit to add support for MariaDB, however due to the fact that it was released over 2 years ago, the code is different and I can't really seem to make heads or tails of it! I did try adding in as much of it as I could, however to no avail! (Especially in the configure.in) Thanks for your help so far! Kind Regards, -Keanu

Can confirm that I receive exactly the same on CentOS7 with "MySQL not found or incompatible".

Hi Ridley, First off, thanks for the reply! I've tried with the "libmariadb-client-lgpl-dev", whenever I try the command "apt-get install libmariadb*" I get the following error: root@j-deb:~# apt-get install libmariadb* Reading package lists... Done Building dependency tree Reading state information... Done Note, selecting 'libmariadb-client-lgpl-dev' for regex 'libmariadb*' Note, selecting 'libmariadbclient16' for regex 'libmariadb*' Note, selecting 'libmariadbclient18' for regex 'libmariadb*' Note, selecting 'libmariadb2' for regex 'libmariadb*' Note, selecting 'libmariadbclient-dev' for regex 'libmariadb*' Note, selecting 'libmariadb-client-lgpl-dev-compat' for regex 'libmariadb*' Note, selecting 'libmariadbd-dev' for regex 'libmariadb*' Note, selecting 'libmariadbclient16-dev' for regex 'libmariadb*' libmariadb-client-lgpl-dev is already the newest version. libmariadb2 is already the newest version. libmariadb2 set to manually installed. libmariadbclient18 is already the newest version. libmariadbclient18 set to manually installed. Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: libmariadb-client-lgpl-dev-compat : Conflicts: libmysqlclient-dev E: Unable to correct problems, you have held broken packages. Google doesn't really help me with that issue, just a bunch of suggestions of different packages to install / try installing, all of which i've tried (been at this for about 6 days now!) i've even tried "apt-get install mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1" etc etc... But to no avail. All leads to; checking for library containing backtrace... none required checking for mysql_config... /usr/bin/mysql_config checking for mysql_init... no checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking MySQL library (required)... no configure: error: MySQL not found or incompatible Kind Regards, -Keanu Also as a side note, Ridley, can you PM me when you're free for some work please! Thanks!

Anyone have any ideas? Still trying to fix this but stuck as the code isn't the same as what's listed on the fix. If anyone has any suggestions on a different database to use, that would be great? Also, please let me know if this is the wrong board for this. I feel it may fit better in support instead??

Still waiting for a reply myself.

I'd like your services please! PM me when you get a chance, thanks!

Hi there, I'm struggling to get Hercules running with MariaDB, i've seen the thread listing the changes made on github, have applied the changes manually (Not sure how else to do it, new to github!) but to no avail. https://github.com/HerculesWS/Hercules/commit/e1e5bd338fe507d23ac72c964efa5c7009c30bba <-- That's what I used. I'm still getting the error of: configure: error: MySQL not found or incompatible Any help would be appreciated! Or if anyone could suggest a lower footprint rev of MySQL other than MariaDB, also appreciated! Kind Regards, -Keanu

Sorry to bring up an old topic, but its still very much valid! How many hair styles are in this pack? Just trying to configure the server now and realised that I didn't know! Thanks!

I'm now using the 2014-04-16a client but i'm still getting the error of unsupported packets. this is the latest one; [Warning]: clif_parse: Received unsupported packet (packet 0x068a (0x022d), 19 bytes received), disconnecting session #7. patched the client using NEMO and using "Recommended". I have updated the repo, and compiled it. Still no luck. This still doesn't answer the questions I had in a previous post. What could possibly be going wrong to cause all these issues? As said, i've even installed a fresh version of the emu, but even that didn't work.

Thanks for your reply, I have updated the repo and also the packets.h however to no avail. Would it be a problem using a outdated client? I mean to say, would it still have all the features (e.g. Pin code login screen, client items shop and auction house etc?) I can't understand why I'm having the problem in the first place, I mean, I followed the guide and used SVN to download the emu, so I can't see why I'd have a problem with it being outdated unless it's actually outdated on the repo? If it helps, I'm running CentOS 6, and have fully updated using "yum upgrade" the only other thing I can think of would be that it's not compiling correctly using make? But then, wouldn't it show an error? I'm using the commands listed above then running ./athena-start start and it's running fine? Looking forward to your reply, Kind Regards, -Keanu

Hi there, I've just copied the document you've given me and uploaded it to the server.and Yeah, I recompiled the server using these commands; configure --disable-64bit make clean make sql. Is that correct? Also just used the make all command to no avail. Kind Regards -Keanu

I used the svn to download? Am I meant to be using branch then, not trunk? After painfully uploading a copy of the master repo via SFTP (did this to make SURE i had the latest instead of relying on svn this time), i'm still getting the same problems. I'm adamant that its not outdated now as I got the zip from here. https://github.com/HerculesWS/Hercules Can anyone provide me with a copy of the latest packets.h / mmo.h please?

Hi there, I'm recieving the error of; [Info]: Selected char: (Account 2000000: 0 - )[Info]: Subnet check []: WAN[Warning]: clif_parse: Received unsupported packet (packet 0x736e (0x093d), 19 bytes received), disconnecting session #7.[Info]: Closed connection from ''. I've tried several different clients; 2013-08-14a 2014-02-12a 2014-04-16a (few others) and finally the current one; 2014-06-13 however to no luck. I've followed these guides too; http://www.eathena.ws/board/index.php?showtopic=220481&st=0&p=1203335entry1203335http://herc.ws/board/topic/7466-whats-the-packet-and-what-can-i-do-with-it/?hl=%2Bpacket+%2Bdb Here is a copy of my mmo.h, packet.h and a link to the client i've used. mmo.h:http://pastebin.ca/2861655packets.h:http://pastebin.ca/2861656Clent:https://www.facebook.com/l.php?u=https%3A%2F%2Fgithub.com%2FThemonChan%2F2014-Ragexe-Client&h=fAQFA-mVX Please note that we have used NEMO to do the diff. But to no luck either... Can anyone provide with with support for this please? Thanks -Keanu