Habilis
-
Content Count
225 -
Joined
-
Last visited
-
Days Won
20
Everything posted by Habilis
-
You cannot just change emulators and expect DataBase to be 100% compatible... If you want to keep data you need to analyze and do a conversion. If you don't want to keep data, use a fresh database.
- 1 reply
-
- 1
-
-
Ne semble pas a une probleme de Mot de passe....
-
Premier erreur c'est clair que ca ne fonctionnerait pas, tu eassaie d'executer une tache avec compte root sans fournir de Mot de passe... essai mysql -u root -p ragna < "C:\eathena svn\sql-files\main.sql" C'est vraiment comme ca que je fais dans mon guide d'installation de Hercules 2017 sur Raspberry Pi La seule difference, Raspberry Pi, c'est du linux... Si tu doute toujours qu'il ne se passe rien, fais ceci dans l'invite de commande: mysql -u root -p use ragna SHOW TABLES; 1 connecte toi 2 choisi ta BD 3 Regarde si les tables que tu essai d'importer sont crées. Sinon, je te recommenderais de reinstaller ton Instance de serveur MySQL et essayer a nouveau.
-
Yea i also thought that internet connection is an issue in my country. isp give very slow connection and that would be a problem for players specially internationally. thanks for the brief explanation though. My Raspberry Pi 3 Dev server Been running 67 days without restart CPU Temperature ranging in 40-45 Degrees C.
-
For those who wondering, not only Google Drive is supported, in the guide I provide a link to rclone github, cool guys, you should check them out! https://github.com/ncw/rclone They have a list of all remote options supported (If you are by any chance Russian, they Even support Yandex Disk, amazing isn't it?)
-
Thank you so much for your FeedBack! Well here is V2 of my Database Backup solution Ow yeah, Don't worry about someone hacking your GoogleDrive, if you put 14 character+ Alphanumeric password on yout backup archives it is going to be bruted loong time... Featuring 1. generate a backup of databases specified in a list 2. Name them with yyy-mm-dd[DatabaseName] format 3. Compress them into .7z using maximum compression 4. Set a password on .7z archive 5. Send them to cloud storage Google Drive 6. Write logs 7. Removes all compressed backups 28 days or older (keeping local folder nice and clean) 8. Can be automated with cron to run even every 12 hours
-
Hello! Depends what VPS... 5$ VPS from DigiOcean featuring 1 core processor 512mb Ram 20 GB SSD COMPARED TO Raspberry Pi 3 model b featuring Quad Core processor 1GB of Ram ? GB of ?? (I use 64GB SD class 10 card (I got some for 12$)) but buying and setting up a Raspberry Pi might cost you a year's worth of hosting a VPS Raspberry Pi server costs ~70-80$ (RPi 3, Power Supply, SD card) Assuming it uses your residential Internet... 80/5 = 16 (months of VPS at Digi Ocean) Anyways, people have to see for themselves. I just have bunch of Raspberry Pi laying around, so I play with them...
-
There is a script to make bash talk to dropbox https://github.com/andreafabrizi/Dropbox-Uploader Will try to integrate it to my solution. But, on the other hand, the db backup folder takes 1.5 Mb at this moment and it contains 5 * 3 database backups. I suppose at this rate archived backups could be sent by Email to make the script somewhat less complex.
-
Hello guys I wrote an article lately about automatic SQL database backup For Linux Systems (Sorry Wind0z guys and gals...) This is the one I'm using for my projects https://habilisbest.com/sql-database-automatic-backups Features: Backups database names specified in a list compresses and stores them Uses filename format for easy retrieval [DatabaseName].YYYY-mm-dd.gz Removes backups older than 28 days (to keep it nice and clean) Writes log files You can configure it to run every 12 hours with cron (crazy server owners...) I run it every 3 days. Because, I don't give a damn about my players I'm confident in my Raspberry Pi server! Would like your feedback and if you can think of any other features I can develop, please speak up!
-
Well, this is sad. But, this is the part of life, there will allways be less than honest people. And, no matter how well you encrypt, there will be someone crafty enough to steal it. Although, I would love to see how would some one steal a graphical enchancment with your server name on it
-
.@i < getarraysize(variable_one) You want to review the control part of your FOR loop. You also, may want to review the overall logic of your code... I don't have time right now to go over Hercules's scripting Syntax and see how arrays are built there. But, there is something about your code, that confuses me...
-
Create a new Linux user called heruser: sudo useradd -m hercuser source https://habilisbest.com/raspberry-pi-and-ragnarok-online-private-server ... ...
-
Well, that's the risks of going with something Hipster, instead of going with one of big players... Never know it still going to be supported 6 months from now, and whether you will be able to get support when needed.
-
LOL 512 mb of RAM Even on my Raspberry Pi I have 1gb Anyways, If you have more questions, just ask. We will do our best to answer you!
-
try guide in my signature it should be a breeze if you use Debian or ubuntu as operating system... Just skip the part about Router setup .... Since you rent a VPS at DigiOcean this step already done by them...
-
Well there is complete guide in my signature
-
CentOS... yum install gcc make mysql mysql-devel mysql-server pcre-devel git zlib-devel
-
You need to install package sudo apt-get install libmysqlclient-dev You can follow guide in my signature, if you ever have any more trouble...
-
I don't have much time but so far what I did is I downloaded rAthena rev 13414 http://rathena.svn.sourceforge.net/viewvc/rathena/trunk/?pathrev=13414 and I will edit db monsters skills etc.. to match those in that revision huge work, will take long time I will also change morroc npc's ... Sorry Satan you weren't there back in the days..
-
It is not that complicated to change IP, just sayin... So, don't do serious stuff depending upon that logic...
-
remove this #define safestrncpy(dst,src,n) (strlib->safestrncpy((dst),(src),(n))) from partyscript.c
-
Failed to Connect Server~help please thanks
Habilis replied to saitamaq15's question in General Server Support
Perhaps Client is the problem. 1 - Did you compile Hercules with the date of your client? 2 - Did you try different client? 3 - Did you try different diffs (containing words "login","packet") ? -
Depends what this is needed for... You can do it Habilis' way (not as efficient, but somewhat easier) Habilis' way : Well you can read a custom table (or MySQL View) from your Ragnarok database Create a mysql view in your Ragnarok database reference the other database in this mysql view Database user your Emulator uses should have access to SELECT (or whatever else you want to do) on that OTHER database... Food for Thought (To inspire you): http://stackoverflow.com/questions/674115/select-columns-across-different-databases http://stackoverflow.com/questions/5698378/mysql-join-between-tables-in-2-different-databases
-
A lot trouble for little profit IMO... I Actively played RO 2004-2008 in my school years After few days I turned off BGM After few months I turned off SFX That's probably what most players do anyways...
-
What's the most stable version of the hercules repository?
Habilis replied to hercules newbie's question in General Server Support
I don't think that principles as stable or not applies to Hercules. Hercules being "versionned" by Git. Therefore, latest version in the git repository is the most stable.
