|
||||||
|
I had problems with displaying UTF-8 characters in my exported CSV files. Unlike LibreOffice Calc and Google Docs, this happened on only MS Excel. Here is a small hack: header("Content-Transfer-Encoding: binary");
header("Content-Length: " . strlen($str) ."; ");
header("Content-Disposition: attachment; filename=\"ourfilename.csv\"; ");
header("Content-Type: application/vnd.ms-excel");
echo "\xEF\xBB\xBF"; // UTF-8 BOM
echo $str;
สรุปขั้นตอน เริ่มต้นเขียน android application
ทั้งนี้ ช่วงท้าย จะมีแถมให้สองเรื่อง คือ การทำให้ emulator (ระบบจำลองโทรศัพท์ android) ที่ต่ำกว่า 2.2 สามารถอ่านตัวหนังสือภาษาไทยได้ กับอีกเรื่องคือการเอาตัวติดตั้ง ไปติดตั้งที่ android เครื่องจริง ซึ่ง ก่อนที่จะเริ่ม ผมแนะนำว่า ให้ใช้ internet ที่มีความเร็วหน่อยนะครับ เพราะว่าทั้งหมดนี้ ขนาดมันใหญ่มาก (น่าจะเกิน 2 GB) รวมทั้ง harddisk ที่จะใช้เก็บก็ด้วย แนะนำให้ใช้ drive ที่เหลือพื้นที่เกิน 5 GB ก็น่าจะอยู่ครับ ถ้าไม่ได้กระหน่ำเขียนอะไรเยอะแยะนะครับ
ที่มา: http://meewebfree.com/site/android/300-build-android-application-from-scratch I’ll use server terminal for all such commands. You should execute them from local server terminal or SSH connection such as OpenSSH server. I’ll use bold font for commands, red bolded font for informations that needs edit to your preferences and orange bolded font for temporary things such as download address. Firstly we need to download latest server package for linux from here, remember that it needs to match your server architecture – use i386 (x86) for 32-bit and amd64 for 64-bit. Also it would be cool to start teamspeak process as another user, just for server security. So… let’s do it. Code:
root@archi:~# adduser teamspeak root@archi:~# su teamspeak teamspeak@archi:/root$ cd ~ teamspeak@archi:~$ wget http://teamspeak.gameserver.gamed.de/ts3/releases/3.0.6.1/teamspeak3-server_linux-amd64-3.0.6.1.tar.gz teamspeak@archi:~$ tar xvf teamspeak3-server_linux-amd64-3.0.6.1.tar.gz teamspeak@archi:~$ mv teamspeak3-server_linux-amd64 teamspeak teamspeak@archi:~$ cd teamspeak teamspeak@archi:~/teamspeak$ chmod +X ts3server_linux_amd64 teamspeak@archi:~/teamspeak$ chmod +X ts3server_minimal_runscript.sh teamspeak@archi:~/teamspeak$ nano ts3server.ini In last command you can use your favourite text editor, I used nano. Now paste below text to your text editor and save it as ts3server.ini. machine_id= Okey. Now we need mysql-server on our machine. If you already have MySQL server on other machine and you want to use it instead – skip this part and remember to change host and port in ts3db_mysql.ini. As part of this tutorial we’ll set up local mysql server. Code:
teamspeak@archi:~/teamspeak$ su root root@archi:/home/teamspeak/teamspeak# cd ~ root@archi:~# apt-get update && apt-get install mysql-server You’ll be prompted for root password for MySQL server. This is NOT a password for your teamspeak mysql connection. We’ll use non-root mysql account for teamspeak. Okay, MySQL Server should be running. Next… Code:
root@archi:~# mysql -h localhost -u root -p
mysql> create database teamspeak;
mysql> grant ALL on teamspeak.* to teamspeak@localhost identified by 'your_password_for_mysql_connection';
mysql> exit
Let’s continue… Code:
root@archi:~# su teamspeak teamspeak@archi:/root$ cd ~/teamspeak teamspeak@archi:~/teamspeak$ nano ts3db_mysql.ini Now paste below text to your text editor and save it as ts3db_mysql.ini. [config] Okay. We’re nearly ready to go. Last (and probably hardest) part is to set up right libraries for teamspeak. Firstly let’s check actual status… Code:
teamspeak@archi:~/teamspeak$ ldd libts3db_mysql.so You should get similar output: linux-vdso.so.1 => (0x00007fff8a7c8000) As we can see it’s missing libmysqlclient15 library. There are 2 ways to fix it. First one is just copying this library from older linux distros and paste it and second way is just to install missing package. We’ll use second way because it’s much easier. Package is named libmysqlclient15off and it’s unavailable to install for latest distros. We need to download and install it manualy. There are 2 main versions of this package. Ubuntu version and Debian version. For some reason Ubuntu version of libmysqlclient15off works much better on my both machines – ubuntu and debian. I’ll attach working links: Ubuntu Hardy [5.0.96] (i386) – http://security.ubuntu.com/ubuntu/po…untu3_i386.deb Warning! libmysqlclient15off needs installed package mysql-common. If you have working MySQL Server on your machine it has been installed automatically. If you have remote MySQL Server install it using apt-get install mysql-common running as root. If for some reason Ubuntu’s version won’t work for you just install Debian’s one. I’ll install Ubuntu’s amd64 version for my machine: Code:
teamspeak@archi:~/teamspeak$ su root root@archi:/home/teamspeak/teamspeak# cd ~ root@archi:~# wget http://security.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.96-0ubuntu3_amd64.deb root@archi:~# dpkg -i libmysqlclient15off_5.0.96-0ubuntu3_amd64.deb And that’s it! We’ve installed missing library for teamspeak. Let’s check if everything works fine: Code:
root@archi:~# su teamspeak teamspeak@archi:/root$ cd ~/teamspeak teamspeak@archi:~/teamspeak$ ldd libts3db_mysql.so Output: linux-vdso.so.1 => (0x00007fff4b5f1000) Yep, It works just fine. This step is optional. You don’t need screen software to run TeamSpeak but it can help you out if you like to have things running in seperate windows like myself. Screen is useful when we’re leaving our server in a background. If you wish to attach to the output just typescreen -r as user teamspeak. If you want to deattach it just hit CTRL+A+D. Code:
teamspeak@archi:~/teamspeak$ su root root@archi:/home/teamspeak/teamspeak# apt-get install screen And let’s turn on our server… Code:
root@archi:/home/teamspeak/teamspeak# cd ~ root@archi:~# su teamspeak -c 'screen -d -m -S ts3 /home/teamspeak/teamspeak/ts3server_minimal_runscript.sh inifile=ts3server.ini' If you didn’t install screen use this command: Code:
root@archi:/home/teamspeak/teamspeak# cd ~ root@archi:~# su teamspeak -c '/home/teamspeak/teamspeak/ts3server_minimal_runscript.sh inifile=ts3server.ini'
www.rocketdock.com Hi, I’ve been experimenting with freeRadius for 2 weeks now, but I still havent got it to do the following: I need to expire a specific time (could be different for each account) after their first login. This time is listed in the MySQL database under the attribute “Max-All-Session” in seconds. The server has a MySQL backend which is working correctly. I’ve tried the following methodes (they will be described in detail below):
Unfortunately non of the above are working correctly. I will explain them in detail now: sqlcounter sqlcounter expire_on_login sqlcounter accessperiod I’ve been google-ing non-stop for days now, with the above result. I’d really appreciate any help. If you want to do some anonymously (private) you can PM, or add me on MSN, or Skype.
ที่มา: http://www.wjunction.com/92-development-area/110059-help-radius-need-accounts-expire-specific-time-after-first-login.html |
||||||
|
Copyright © 2019 Kunawut's knowledge blog - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
