phpMyAdmin Authentication method

• Authentication Method — for single-user (root or trusted) environment…
  • Method 1: Prompt client for MySQL user/password…
    $cfg['Servers'][$i]['auth_type'] = 'http';
  • Method 2: Store MySQL user/password under config.ini.php…
    $cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root-password'; [Note password 'root-password'; substitute in set password for MySQL user 'root'; if no password set, leave as is (blank)]
• Authentication Method — for multi-user (untrusted) environment (this step is also required for enabling phpMyAdmin’s relational features)…
  $cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass'; [Note password 'pmapass']
• Create MySQL controluser user ‘pma@localhost’ with password ‘pmapass’, with the proper permissions set…
  C:\www\mysql\bin> mysql -u root -p
mysql> GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; [Note password 'pmapass']
  mysql> GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv) ON mysql.user TO 'pma'@'localhost'; [Note that this query is too large to be pasted into the mysql command line in its entirety; select half, copy/paste, press enter, copy/paste other half]
  mysql> GRANT SELECT ON mysql.db TO 'pma'@'localhost';
mysql> GRANT SELECT ON mysql.host TO 'pma'@'localhost';
mysql> GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost';
mysql> quit

regards,

tolahtoleh.com™

554 email error message

554 email error message: “reason: 554 mail server permanently rejected message”: When you send an email, error message comes back with “reason: 554 mail server permanently rejected message”. Why does this happen? Usually, the “reason: 554 mail server permanently rejected message” email is received because the mail server thought your email is spam. Did you send an attachment – BINGO, that’s your problem! Even though the email server return message “reason: 554 mail server permanently rejected message” sounds severe, what you should do is change the extension of your attachment. 554 mail error: solution: Let’s say you sent an ‘.htm’ file to a friend. You got a “reason: 554 mail server permanently rejected message” error. I’d suggest using WINZIP to zip the file, therefore changing the extension and sending it again – and you’re all set and should not get 554 mail server permanently rejected message (#5.3.0) error again. sample “reason: 554 mail server permanently rejected message” The original message was received at Mon, 18 Jul 2005 14:10:32 -0400 (EDT) from xyz.com [***.***.***.***] —– The following addresses had permanent fatal errors —– <***@xyz.com> (reason: 554 mail server permanently rejected message (#5.3.0)) —– Transcript of session follows —– … while talking to smtp.***.net.: >>> DATA <<< 554 mail server permanently rejected message (#5.3.0) 554 5.0.0 Service unavailable

The entered e-mail domain has no valid MX record

“The entered e-mail domain has no valid MX record.”

That is something wroten as an error report on my phpBB3. I use XAMPP, as my webserver. Its easy to install and easy to manage.

I install it ad localhost, so I don’t need any email confirmation. As a new member I use form registration, later I submit it. Error prompted as Title above.

Then I got a good answer from this site, they solve it.

here some note:

Cause
phpBB3 by default checks the MX record of all entered email addresses during registration to make sure the email domain is valid. If the domain does not have a valid MX record this error is generated.
Solution
Go to the,

Admin control panel -> general tab -> Server configuration -> security

Then for the option

Check e-mail domain for valid MX record:
If enabled, the e-mail domain provided on registration and profile changes is checked for a valid MX record.

select the 'no' checkbox

regards,
tolahtoleh.com™

Dear Lord

Please Forgive me, I will post more here,…

regards,

Cannot load mcrypt extension. Please check your PHP configuration

Having mYSql and PHP installed, looking great if it works fine and no errors, no one would expect thus errors. But an error means everything, you could learn something new, just like me.

My problem is written on the title,.
This problem solved based on my OS, you may config/modify it, make it suit through your OS.
Basically you need to install several package, and its dependencies, then restart your apache if your instalation complete. You may get your source of rpm from internet (means you download it) or you got it from your Linux installation DVD,.. my case, I took from its DVD …..

Have a nice day,..

site:/media/SU1100.001/suse/i586 # rpm -ivh php5-mcrypt-5.2.5-66.1.i586.rpm
error: Failed dependencies:
libmcrypt.so.4 is needed by php5-mcrypt-5.2.5-66.1.i586
site:/media/SU1100.001/suse/i586 # ls -l |grep libmcrypt.so.4
site:/media/SU1100.001/suse/i586 # ls -l |grep libmcr
-r--r--r-- 6 xxxxx root 68879 Jun 7 2008 libmcrypt-2.5.8-67.1.i586.rpm
site:/media/SU1100.001/suse/i586 # rpm -ivh libmcrypt-2.5.8-67.1.i586.rpm
Preparing... ########################################### [100%]
1:libmcrypt ########################################### [100%]
site:/media/SU1100.001/suse/i586 # rpm -ivh php5-mcrypt-5.2.5-66.1.i586.rpm
Preparing... ########################################### [100%]
1:php5-mcrypt ########################################### [100%]
site:/media/SU1100.001/suse/i586 # ls -l |grep mbstring
-r--r--r-- 6 xxxxx root 434373 Jun 7 2008 php5-mbstring-5.2.5-66.1.i586.rpm
site:/media/SU1100.001/suse/i586 # rpm -ivh php5-mbstring-5.2.5-66.1.i586.rpm
Preparing... ########################################### [100%]
1:php5-mbstring ########################################### [100%]
site:/media/SU1100.001/suse/i586 # /etc/init.d/apache2 restart
Syntax OK
Shutting down httpd2 (waiting for all children to terminate) done
Starting httpd2 (prefork) done


regards,
tolahtoleh.com™

I am surrender,

I am surrender,
bear me,
I am lost in thus pathetic fate,
alone, around roaring wisdom.

I have dreamed of joy departed

surrender —v. 1 hand over; relinquish. 2 submit, esp. to an enemy. 3 refl. (foll. by to) yield to a habit, emotion, influence, etc. 4 give up rights under (a life-insurance policy) in return for a smaller sum received immediately. 5 abandon (hope etc.). —n. act of surrendering.  surrender to bail duly appear in court after release on bail. [Anglo-French: related to *sur-1]

moment angle lighting

When I decide to take any photo I will consider this three aspect,
You might find this is silly, OK I take it, it just my opinion, you have yours, sorry, hope it could increase my pagerank

1. Moment
2. Angle
3. Lighting (source)

Relax, once you find a AWB button, you could start it .
Those three component are equal, they play their own part in order to address your camera capture your event/object.

1. Moment, Why do we need a moment?,.. Hm,.. You need it, it shows how your intention, passion and your feeling, otherwise your object’s. Sure you need learn from a Famous fotographer, but you have to find your own style, you have your own way to create your own photography, I said, “even a great photographer never capture your moment, why? they don’t even there where/when you capture it,. haha,..”. Trust me, even they said your picture is a miss-conduct of any photographic technique, still they couldn’t seize yours, I mean your moment

2. Angle, Hm,.. angle yeah, angle I mean How you serve/order you object through your camera. You may take it above, below, or behind the object. The space between your camera and your object will describe how Your creativity to reserve a great ingredients of your camera ability – name it F-stop, shutter speed, DOF (depth of field), Focal length, etc.

3. Lighting , You need a light to take a photo, otherwise you paint it black or white, no more color . Light source define your color. You need to understand how your camera works over the light source. Some [digital] camera produce more green, blue, or red than others, I mean for each camera has a tendency to proudce thus color. To obtain better color, sometimes photographer using a filter, attached to their lenses. Sorry I have no idea about filter, you have to search it by yourself.
Further explanation about lighting source, you must try it by yourself,

Any suggestion to complete the definition above? contact me, angus@tolahtoleh.com

Your camera didn’t take the picture, You did,..!!!  work with what you got. you might amaze yourself.

Some people find themselves feeling more artistic when wearing a beret and smoking clove cigarettes. I doubt the clothing changes the paint around on the canvas. , But using a camera type obsessively out of some dislike for other sorts doesn’t make much sense,.. see you soon,..

_____________

regards,
tolahtoleh.com™

dump-restore postgre sql

As a newbie, I write this tips, as I did earlier. It work on my postgtre sql.

DUMP DATA

============================
| DUMP DATA |
============================

pg_dump -U userName -d db_bonus > db_bonus.sql

—1—–2—3——4—-5——–6–

1. pg_dump= function from postgresql
2. -U = Option for Username in data base
3. userName= username, use your active user on postgresql
4. -d = Option for dump database
5. db_bonus= here my database name is db_bonus
6. db_bonus.sql = filename, as result from dump

============================
| RESTORE DATA |
============================
psql -U bonususr -d db_bonus -f backup_3.sql

1—2—3——4—5——6—-7—-

1. psql= function from postgreSql
2. -U = Option for Username in data base
3. userName= username, use your active user on postgresql
4. -d = option for database
5. db_bonus= here my database name is db_bonus
6. -f = from file
7. backup_3.sql = file name. Ypu may locate your filename fro its path, eg. /home/angus/backup_3.sql

note:

I am using PostgreSQL 8.1.11. Runing on linux Ubuntu

psql only works smoothly with servers of the same version. That does
not mean other combinations will fail outright, but subtle and not-
so-subtle problems might come up. Backslash commands are particularly
likely to fail if the server is of a different version.

regards,
tolahtoleh™

blog walking

Hello,

Do we oftently surf through someone else blog? commonly, we do. I could figure it out, because I did it also, he he he. Then, what wrong with blog walking? nothing wrong, it is our right to read article that posted. But, sometimes, we had to appreciate what did the owner think about. Also we might caught that we had read their article. Obviously, it is not a joke.

how do they know we’ve been there? I just browse it,
Yeah, you and I just the same, we like to read. Here a simple explanation, assume, that the blog or their article is a museum. Of course we don’t need to pay the ticket, but, we might identify ourself as a member of the museum, or just a visitor. For a member, we have a kind of member card, that we called a login. Then, during login session, we might walking through the museum and see around, take some picture, etc. Basic feature of its member card is, we automatically recorded for each item we saw/observe. You might reject it, but this is a basic feature, and you couldn’t remove it, as a consequence being a member. Don’t worry, there no criminal act here,

The record[s], unofficially, guide the blog owner to classify which article/section attract audience/blog viewer more. By indentifying it hits, owner will be granted to post related topic, otherwise, it detemines what blog owner consider on.

Ethically, there are no written rules-it just an understanding, that we may leave a comment addressed to its article. But, what if I don’t want to leave any comment? No prob, relax,… it is your right to leave a comment or not, Your presence at their post are appreciated more, I assume you login, and leave a record as visitor.

But, it will be a more appreciation if you leave a comment. At least, you may say, “a great post”, or “nice post”, “thx for share”, etc.

Think about how we courage the blog owner, to post some thing more. Even if its article is bad, you may criticize it. But, I hope you didn’t mean to destroy blog owner, make it a better solution. Courage the blog owner to make a better post,..

See you,..

regards,
tolahtoleh

Question of faith

Johan, lelaki seperempat abad yang sedang menganggur. Johan tidak dengan suka rela menganggur, memang johan sedang tidak beruntung. Mungkinkah karena keterlambatannya dalam kuliah? bisa jadi, tapi untunglah johan tetap optimis dengan kemampuannya. Johan juga yakin bahwa suatu saat, dia akan bekerja di kantor, layaknya pekerjaan yang di idamkan kebanyakan orang.

Akhir minggu lalu, aku ketemu Johan, ya, Johan bukan orang asing bagi-ku. Saat aku ga ada uang, Johan dengan suka rela mentraktirku, bukan untuk hitungan sekali ato dua kali, bisa jadi sampe seminggu. Sungguh aku berhutang budi padaJohan, sehingga seolah, tanpa Johan aku tidak akan pernah bisa lulus kuliah. Walaupun saat ini aku juga sedang menganggur, setidaknya aku punya pekerjaan sampingan, memberikan les private kepada anak SD. Jadi, pada dasarnya aku dan Johan tidak jauh beda.

Dulu kami sempat satu kos, tapi karena uang kos naek, dan kebetulan Johan kedatangan sepupunya, Adi, akhirnya mereka pun kontrak bersama. Johan kontrak beberapa saat setelah aku keluar dari tempat kos.

Tidak sengaja aku ketemu Johan di tempat kami biasanya ngopi, dan kamipun mulai ngobrol serius. Tanpa basa-basi, Johan sekali ketemu, bisa langsung meluapkan amarahnya, tentang semua orang yang ada di sekitarnya. Yup, tipikal Johan memang orang yang terlalu jujur, bahkan cenderung ga bisa berbohong. Tapi kayaknya hanya untuk beberapa orang saja Johan berpendpat, karena Johan lebih suka diam pada orang yang baru dikenalnya.

regards.

tolahtoleh