Welcome to Geeklog, Anonymous Wednesday, December 25 2024 @ 10:38 pm EST
Geeklog Forums
Goofy database access issue
rob
Anonymous
Hello
I had my server fry (literally) and am rebuilding a new server with Mandrake9.1/mysql 4.x/php4.3/and gl1.3.8..
gl /admin/install/check.php says life is good.
I made a clean database
the user has ALL permissions in mysql for all databases
initial check seems it is working fine, but.....
after logging in, I try to GET PUBLISHED and try to add NEW STORY, nothing happens, no fields are shown. If I try to add a poll entry all I get is the poll entries, not the results.
The only thing I noticed is the REGISTER GLOBALS OFF warning in the admin/install.php section. I changed both php.ini-recommended and php.ini-dist files to REGISTER GLOBALS ON, with a full reboot, but gl still thinks globals are off.
I have gl 1.3.7 running (backup of my old site) and it is behaving the same way, no database modifications allowed. I am completely out of ideas.
http://www.orgdotslash.com/geeklog for 1.3.7
http://www.orgdotslash.com/gl2/ for a new 1.3.8 install
any ideas are most appreciated
rob.bair At covad.net
I had my server fry (literally) and am rebuilding a new server with Mandrake9.1/mysql 4.x/php4.3/and gl1.3.8..
gl /admin/install/check.php says life is good.
I made a clean database
the user has ALL permissions in mysql for all databases
initial check seems it is working fine, but.....
after logging in, I try to GET PUBLISHED and try to add NEW STORY, nothing happens, no fields are shown. If I try to add a poll entry all I get is the poll entries, not the results.
The only thing I noticed is the REGISTER GLOBALS OFF warning in the admin/install.php section. I changed both php.ini-recommended and php.ini-dist files to REGISTER GLOBALS ON, with a full reboot, but gl still thinks globals are off.
I have gl 1.3.7 running (backup of my old site) and it is behaving the same way, no database modifications allowed. I am completely out of ideas.
http://www.orgdotslash.com/geeklog for 1.3.7
http://www.orgdotslash.com/gl2/ for a new 1.3.8 install
any ideas are most appreciated
rob.bair At covad.net
11
6
Quote
rob
Anonymous
I found one thing. I renamed the php.ini-dist file to php.ini, which should be picked up by php upon restart. still no 'register globals=on' error on the /install/install.php page when they are clearly on in the ini file.
rob
rob
10
12
Quote
rob
Anonymous
More info for anyone.
I ran a scritp and get a nice data dump. it says mysql is enabled, the register globals are truly off and the default php.ini location is /etc.
Aha! I copied the php.ini-recommended to /etc/php.ini and restarted apache.
the phpinfo command above has globals turned on, but all mysql connectivity is lost. I have mysql.sock pathed correctly. There appears to be something in this php.ini file that is not enabling mysql. Any ideas?
I ran a scritp and get a nice data dump. it says mysql is enabled, the register globals are truly off and the default php.ini location is /etc.
Aha! I copied the php.ini-recommended to /etc/php.ini and restarted apache.
the phpinfo command above has globals turned on, but all mysql connectivity is lost. I have mysql.sock pathed correctly. There appears to be something in this php.ini file that is not enabling mysql. Any ideas?
11
6
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by rob: but all mysql connectivity is lost.
It would probably help if you could be more specific. Do you get any errors. If so, what are they? Is there a MySQL section in the phpinfo output? Are you sure MySQL is running?
bye, Dirk
12
9
Quote
rob
Anonymous
Okay, figured it out. It is kind of hard to ask a question when one is unsure of the problem.
The default install of Mandrake 9.1 has the ADVX setup with apache/php and other services by default. The default settings work well for other php/mysql scripts (ie, phprecipebook) but GL would not work correctly (no error message, just would not 'include' some php items)
My hint was an error "register_globals = off, must turn on'. I found a couple of files named php.ini and modified the global setting correctly. but had no effect. I made a page containg a phpinfo() command which gave me the default location for the php.ini file.(and a lot of other interesting data) I place the default php.ini file in /etc/php.ini but that only made things worse. It broke ALL php and mysql commands on my site, not just GL.
As the default php settings are working fine, except for the one global setting, I created a file /etc/php/global.ini simply containing the text "register_globals = on". restarting apache picked up that one change and GL is now working wonderfully.
The default install of Mandrake 9.1 has the ADVX setup with apache/php and other services by default. The default settings work well for other php/mysql scripts (ie, phprecipebook) but GL would not work correctly (no error message, just would not 'include' some php items)
My hint was an error "register_globals = off, must turn on'. I found a couple of files named php.ini and modified the global setting correctly. but had no effect. I made a page containg a phpinfo() command which gave me the default location for the php.ini file.(and a lot of other interesting data) I place the default php.ini file in /etc/php.ini but that only made things worse. It broke ALL php and mysql commands on my site, not just GL.
As the default php settings are working fine, except for the one global setting, I created a file /etc/php/global.ini simply containing the text "register_globals = on". restarting apache picked up that one change and GL is now working wonderfully.
7
24
Quote
All times are EST. The time is now 10:38 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content