Skip to main content

Wordpress serialize config data in Database

Image
By
alpha.abcdefgh-dev.pw
alpha.abcdefg-hiet.cp

Two domain name has same length.
In wordpress, whole config, setting and plugin is store in wp_options.
So when I change domain name setting for FaceBook Authentication plugin named Gianism (a japanese WP plugin) I found that it work well on localhost.
But when I put it on live server abcdefgh-dev.pw, it not working. Thank God, after messing about 30 minutes I found that it caused by Serialize (or JSON) I've hardcoded in my Database:

...
login_url";s:36:"https://abcdefgh-dev.pw/login/";s:15:"after_login_url";s:30:"https://abcdefgh-dev.pw/";s:16:"after_logout_url";s:30:"https://abcdefgh-dev.pw/"
...

login_url";s:36:"https://abcdefgh-dev.pw/login/";

The s:36 as we know is the length of following string with length of 36 characters.
So when 2 above domain is same length and my local server work well, I was messed in live server not work.

Hope this help you in some case.


More about my situation is that:
I need deploy old server with Gianism plugin installed. As you know, without gianism correctly configured, you can't login to New server Admin to setting new server domain, App Id and App Secret of New Facebook app to make Gianism work.
So I need hardcode it in DB:
the wp_gianism_setting (or similar) in wp_options:

I find that it has API Key and App secret. So I hardcode new API key and secret to that. I also change new domain as above.

And new server .......... NOT WORK !

I need some more digging into source of Gianism, and frontend_user_admin(other WP plugin), a noddle file with around 8500K LOC in single file with PHP, HTML and more mixed. The problem with me is that I can't show Form for Login. Anh other way of show form didn't work ( I think because of access_token or crsf or other sercurity reason) that your inserted login form not work.
Gianism has one file that match the form login. And plugin loaded it over file called:
frontend_user_admin.php. After 1-2 day messing about this source, finally I found some line load thing that after load login form (step-login.php) ...
So I enable it (force enable over if(1) :)

then It work as normal.



Comments

Post a Comment

Popular posts from this blog

AWS Elasticache Memcached connection

By
https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/accessing-elasticache.html#access-from-outside-aws http://hourlyapps.blogspot.com/2010/06/examples-of-memcached-commands.html Access memcached https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/GettingStarted.AuthorizeAccess.html Zip include hidden file https://stackoverflow.com/questions/12493206/zip-including-hidden-files phpmemcachedadmin ~ phpMyAdmin or phpPgAdmin ... telnet mycachecluster.eaogs8.0001.usw2.cache.amazonaws.com 11211 stats items stats cachedump 27 100 https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/VPCs.EC.html https://lzone.de/cheat-sheet/memcached VPC ID Security Group ID (sg-...) Cluster: The identifier for the cluster memcached1 Creation Time: The time (UTC) when the cluster was created January 9, 2019 at 11:47:16 AM UTC+7 Configuration Endpoint: The configuration endpoint of the cluster memcached1.ahgofe.cfg.usw1.cache.amazonaws.com:11211 St...
44 comments
Read more

Simulate Fail2ban on Apache request spam with mod_evasive limitipconn ...

By
https://en.wikipedia.org/wiki/Manchu_alphabet https://en.wikipedia.org/wiki/Sweet_potato https://en.wikipedia.org/wiki/New_World_crops https://www.mdpi.com/journal/energies http://www.cired.net/publications/cired2007/pdfs/CIRED2007_0342_paper.pdf https://www.davidpashley.com/articles/writing-robust-shell-scripts/ trap command https://en.wikipedia.org/wiki/Race_condition https://unix.stackexchange.com/questions/172541/why-does-exit-1-not-exit-the-script exit 1 not work it seem { } brace bound fixed it. cat access_log | cut -d ' ' -f 1 > ip1 sort -n -t. -k1,1 -k2,2 -k3,3 -k4,4 | uniq -c | sort -n -r -s https://unix.stackexchange.com/questions/246104/unix-count-unique-ip-addresses-sort-them-by-most-frequent-and-also-sort-them https://stackoverflow.com/questions/20164696/how-to-block-spam-and-spam-bots-for-good-with-htaccess  Code: ------------------------------------------------------------------- #Block Spam Bots and Spam on your website #Block proxies...
5 comments
Read more

Notes Windows 10 Virtualbox config, PHP Storm Japanese, custom PHP, Apache build, Postgresql

By
 cmd => Ctrl + Shift + Enter mklink "C:\Users\HauNT\Videos\host3" "C:\Windows\System32\drivers\etc\hosts" https://www.quora.com/How-to-create-a-router-in-php https://serverfault.com/questions/225155/virtualbox-how-to-set-up-networking-so-both-host-and-guest-can-access-internet 1 NAT + 1 host only config https://unix.stackexchange.com/questions/115464/how-to-properly-set-up-2-network-interfaces-in-centos-running-in-virtualbox DEVICE=eth0 TYPE=Ethernet #BOOTPROTO=dhcp BOOTPROTO=none #IPADDR=10.9.11.246 #PREFIX=24 #GATEWAY=10.9.11.1 #IPV4_FAILURE_FATAL=yes #HWADDR=08:00:27:CC:AC:AC ONBOOT=yes NAME="System eth0" [root@localhost www]# cat /etc/sysconfig/network-scripts/ifcfg-eth1 # Advanced Micro Devices, Inc. [AMD] 79c970 [PCnet32 LANCE] DEVICE=eth1 IPADDR=192.168.56.28 <= no eff => auto like DHCP #GATEWAY=192.168.56.1 #BOOTPROTO=dhcp BOOTPROTO=static <= no eff ONBOOT=yes HWADDR=08:00:27:b4:20:10 [root@localhost www]# ...
Post a Comment
Read more