Rand
Members-
Content Count
13 -
Joined
-
Last visited
-
Days Won
1
Rand last won the day on January 18 2015
Rand had the most liked content!
About Rand
-
Rank
Member
Profile Information
-
Github
Rand
-
Clare reacted to an answer to a question: Compiling Hercules in linux
-
Javanese reacted to an answer to a question: i need help configure hercules
-
http://herc.ws/wiki/Getting_Started
-
Skyline reacted to an answer to a question: i need help configure hercules
-
Hey i think it would help u https://github.com/HerculesWS/Hercules/blob/master/doc/script_commands.txt goodluck)
-
tmav94 reacted to an answer to a question: Some itens bonus ^^
-
use sudo yum --enablerepo=remi install mysql-devel or yum --enablerepo=remi install mysql-devel
-
Try this: You should see the new user in the User overview. Global privileges should say "Usage".
-
ρixєℓ reacted to an answer to a question: Compiling Hercules in linux
-
try chmod a+x configure./configure if no u need to convert ./configure to unix file format yum install dos2unixdos2unix ./configure mb dos2unix install try only convert
-
Kitutty reacted to an answer to a question: How to set up a CentOS VPS to run a server
-
use this http://herc.ws/wiki/Installation_%28CentOS%29
-
use https://github.com/HerculesWS/Hercules/blob/master/doc/item_bonus.txt bonus2 bSPRegenRate,1,10000; bonus2 bHPRegenRate,1,10000;
-
how to sync time of my server to my database on logging?
Rand replied to Zirius's question in Database Support
no matter but if restart mysql this setting resets. Variant 2. U have full access to mysql server and u can enter SSH as a root user: run below command: #mysql or mysql -u root -p than enter the password 1) Check time_zone* tables in mysql database. mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql 2) To change / update timezone set global time_zone = timezone; Example: set global time_zone = "Asia/Calcutta"; restart mysql. You can change the time zone as per the requirement without root user. set time_zone = timezone; You can see the full list of possible values for ZONEINFO at /usr/share/zoneinfo or VPS. From an SSH: ls /usr/share/zoneinfo/ Then simply delete the current timezone: rm /etc/localtime And replace it with a symbolic link to the new timezone from /usr/share/zoneinfo. For example if your chosen zone is Pacific time: ln –s /usr/share/zoneinfo/PST8PDT /etc/localtime Or you can use the tzselect command: You may need to remove the existing symlink before using tzselect rm -f /etc/localtime than use tzselect You can make this change permanent for yourself by appending the line TZ='timezone'; export TZ to the file '.profile' in your home directory; then log out and log in again. Synchronizing time with NTP server The first step is to make sure you have the ntp program installed. Do a: which ntpdate Once ntp is installed synchronize your computer clock with: ntpdate pool.ntp.org If ntp is not install, you may run this to install ntp yum install ntp To set time and date date MMDDhhmmYYYY MM - Two digit month number DD - Two digit date hh - Two digit 24 hour system hour mm - Two digit minute YYYY - Four digit year code -
how to sync time of my server to my database on logging?
Rand replied to Zirius's question in Database Support
try: MySQL: SET time_zone='-03:00';"-03:00" - timezone u need. if no what os at your vps? -
how to sync time of my server to my database on logging?
Rand replied to Zirius's question in Database Support
double sorry -
you're welcome
-
try to: make clean./configuremake sql or if u have 64 bit system: make clean./configure --enable-64bitmake sql