kamil2321
Member-
Posts
26 -
Joined
-
Last visited
-
Feedback
0%
About kamil2321
Informations
-
Gender
Male
Recent Profile Visitors
1115 profile views
kamil2321's Achievements
-
Yes almost success, please stop MariaDB and use command for rename folder mysql to old_mysql: Command: mv /var/db/mysql /var/db/old_mysql And reboot. Next step, i have a question, did you have full backup in .sql? In MariaDB and MySQL 5.7/ 8.0 not make backup only folder account etc.. yu must all packed, but i preffer always pack MySQL in .sql I have mega script backup for all databases, but i must translate to EN and i will give for this forum for free soon. Next Question, old databases you have MySQL5.6? MySQL5.6 still is supported in FreeBSD 13.x If you have old databases and still work, I can help you faster via AnyDesk
-
kamil2321 started following Problem pick up itm and Aborted connection to db, changed MYSQL to MARIADB
-
Okay, i help you. Eg. i use IP VPS (IP is not real): 177.22.33.44 for this TuT. First one, change from: bind-address = 0.0.0.0 to: bind-address = 127.0.0.1, 177.22.33.44 Yes, you must BIND IP too in VPS. Step two, in file: hosts from: /etc/ Comment out the lines that start with: ::1 eg.: # The following lines are desirable for IPv6 capable hosts #::1 vmi33.hosts.net vmi33 #::1 localhost.localdomain localhost #::1 localhost6.localdomain6 localhost6 P.S. name: vmi33.hosts.net vmi33 its not real, i use fake name only for a TuT. Its ipv6 btw. and now restart MariaDB, probably command is: service mysql-server restart I hope its works, if dont work then i give you more information.
-
You have mysql 56? yes i can help
-
Hmm, maybe first I will discuss the size of the vdi/vhd disk and the actual size in the BSD system (df -h) To begin with, each virtual machine in metina is made dynamic and this has its advantages and disadvantages. Dynamic - the size of the .vdi, .vhd, etc. file increases with demand - recommended for someone who does not care about the allocated virtual and physical space, i.e. on the machine we can have, for example, 6 GB of occupied space, but the virtual disk may have 30 GB because that in the past, for example, files were unpacked and then backups were made, then compilations etc. and the space demand has almost doubled (usually it increases by 51% of a given virtual disk occupancy) and after deleting this data, the virtual size of such a disk will not decrease, unfortunately Fixed size - this is one that does not change and there is a constant disk size .vdi, .vhd - the preferred output when we do not want our virtual machine to have e.g. 60 GB of virtual disk and the actual value inside would be 5 GB, then it is worth considering this option and then, after using the df -h command, it will be as much as it should be and will not exceed, e.g. 30gb if we set a fixed size of 30gb (you can always increase such a disk or add another virtual dynamic or fixed disk as an additional partition on e.g. for metin file, etc.) If you want to see which folder weighs a lot, I recommend running the command: du -sh /* If you want to save results to txt, I recommend: du -sh /* >> /check_disk.txt If you want to check which folder weighs a lot inside, e.g. all the files: du -sh /*/* If you want to see how much /usr weighs: du -sh /usr If you want to see which folders in usr weigh a lot: du -sh /usr/* Etc., I recommend this option, of course there are other methods, but this method is universal and transparent, I think. And finally, to change the dynamic disk (its physical value on a computer weighing e.g. 80 GB), it is best to migrate such a machine to a newer one with the setting to a permanent disk and then it will not exceed the physical space. There is also a method of compacting VDI VHD disks, but I do not recommend it because I don't know, maybe the compact will reduce the occupied virtual disk of the physical scale by 20%, so it is more profitable to migrate to a permanent disk with a size of e.g. 20 GB and if there is a greater demand for the disk, simply add another one. partition and mount another partition and add it to boot in fstab, mounting a partition on ufs is trivial, example the name of partition no. 4 to be mounted to the /mnt folder: mount -t ufs /dev/ada0p4s /mnt or: mount /dev/ada0p4s /mnt unmount: umount /mnt I didn't want to write down the topology of the dynamic disk because I would have to write it down in size letter A4 XD and I wrote a lot so I apologize for it and for my bad English.
-
A okay, i have the system in my disk, i will check soon src
-
Aaa i seee! you probably in the code you cut some lines hehe or you have inventory not from turk ;c Can you give link to special inventory from you add? You use files by T4UMP so maybe i download this and check src too
-
Cant equip alchemy stone
kamil2321 replied to Mirdasek's topic in Community Support - Questions & Answers
Hm, did you send sql item_proto or .txt whatever to attachment or pastebin or whatever? Sql you dump from navicat or command in putty: mysqldump -uroot -p --extended-insert=FALSE player item_proto> item_proto.sql and type password for localhost user or just enter if you dont have password for localhost user I have this one just to be sure heh ^^ I will have other ideas in some time, when I sit down at the computer or tomorrow because I need to check the SRC code -
I don't really understand what you mean, so I'll ask, do you want to transfer the book from the additional system inventory to the regular inventory?
-
kamil2321 started following Mysql not starting and Argon2 and byebye MD5 password on db
-
Problem implement special inventory
kamil2321 replied to Tr3l's topic in Community Support - Questions & Answers
Hehe okay ^^ If my solution work, please mark as Solved and my post and thank you -
Problem implement special inventory
kamil2321 replied to Tr3l's topic in Community Support - Questions & Answers
hm, so maybe i can help in anydesk? -
Problem implement special inventory
kamil2321 replied to Tr3l's topic in Community Support - Questions & Answers
Thank you too, and now i see when problem. Solution: in ExtendedInventoryWindow.py line: missing: , explanation: in: "image" : "d:/ymir work/ui/public/Slot_Base.sub" change: "image" : "d:/ymir work/ui/public/Slot_Base.sub", and maybe in: "text_horizontal_align":"center" change: "text_horizontal_align":"center", and i think it's all. Download if you want: Scan: in files in notepad++ i change formatting to ANSI(option convert to ANSI- not code to ANSI) I think now works fine, and locale_interface you have fine, and i change formatting to ANSI -
Argon2 and byebye MD5 password on db
kamil2321 replied to porexemplo's topic in Community Support - Questions & Answers
Why use unstable mysql57 and very bad in mt2? use mysql56 or mysql8 (mysql58 have upgrade native mysql password work in mt2) FreeBSD still have mysql56 and if dont have mysql56, install from txz/tbz mysql and works normally. I dont prefer you change files in c++ because why must -
Why use 5.7? in FreeBSD 13.x still have a mysql56 just repleace FreeBSD.conf from latest to release_2 and pkg update. And i recommend backup files in .sql or .sql.bz2 or copy all folder using metin2 and 3 files named ibdata ib_logfile1 ib_logfile2 and repleace. Dont replace folder mysql and use command: chown -R mysql:mysql /var/db/mysql; chgrp -R mysql /var/db/mysql Dont use chmod 777, tutorial all its very bad. Maye I'll write someday tutorial 100% great and work. I help you on AnyDesk if you want