Re: problem trying to import a 3.4m database with phpmyadmin
Well guess what--I fixed it. In /etc/php5-6.ini, a semi-colon is used for comment lines. I used a colon. It misparses things when you do that. Silently. I need to clean my eyeballs now... Sorry for the noise, but at least you can remember this. (reason 416 to not be crazy about php...) --STeve Andre' On 08/15/16 05:41, STeve Andre' wrote: This is on an amd64 -current system updated/compiled as of Aug 8 7am; using the 8/13 packages. I'm trying to use phpMyAdmin to import a database into maria. in /etc/php-5.6ini I've set memory_limit to 256m, post_max_size to 16m and upload_max_filesize to 8m. The db I'm trying to import is 3.4m. Under import in phpmyadmin it says (max 2,048k) for importing, hence my doing what php faq 1.16 said about the above three params in php.ini. Now I notice that suhosin says in /var/log/messages ALERT - script tried to disable memory_limit by setting it to a negative value -1 bytes which is not allowed (attacker '10.0.0.5', file '/u/php/www/import.php', line 296) So, I am wondering how suhosin is seeing this, and how one gets phpmyadmin to deal with > 2M files. That is always says 2,048K says I'm not changing things correctly? I've restarted apache and even rebooted but I always get the 2M max notice. Any ideas? I'm pressed for time on this, sigh. Pointers would be much appreciated. --STeve Andre'
problem trying to import a 3.4m database with phpmyadmin
This is on an amd64 -current system updated/compiled as of Aug 8 7am; using the 8/13 packages. I'm trying to use phpMyAdmin to import a database into maria. in /etc/php-5.6ini I've set memory_limit to 256m, post_max_size to 16m and upload_max_filesize to 8m. The db I'm trying to import is 3.4m. Under import in phpmyadmin it says (max 2,048k) for importing, hence my doing what php faq 1.16 said about the above three params in php.ini. Now I notice that suhosin says in /var/log/messages ALERT - script tried to disable memory_limit by setting it to a negative value -1 bytes which is not allowed (attacker '10.0.0.5', file '/u/php/www/import.php', line 296) So, I am wondering how suhosin is seeing this, and how one gets phpmyadmin to deal with > 2M files. That is always says 2,048K says I'm not changing things correctly? I've restarted apache and even rebooted but I always get the 2M max notice. Any ideas? I'm pressed for time on this, sigh. Pointers would be much appreciated. --STeve Andre'
Re: phpMyAdmin
On 2012-10-25, Tony Berth tonybe...@googlemail.com wrote: I'm trying to run phpMyAdmin on a 5.1 box (i386) with MySQL 5.1.60 installed from the OpenBSD packages. ah, phpMyAdmin, that popular cross-site-scripting and local file inclusion toolkit with a sideline in web-based database access. you might like to try chive instead.
phpMyAdmin
Dear group, I'm trying to run phpMyAdmin on a 5.1 box (i386) with MySQL 5.1.60 installed from the OpenBSD packages. When I try to login I get: #2002 Cannot log in to the MySQL server Please note that the same mysql user is able to login remotely via the MySQL GUI workbench! Now, I came across the following posting: http://marc.info/?l=openbsd-miscm=116902953505548w=2 and did apply the suggested solution but didn't work! I also have to mention that my sock file is located in: /var/run/mysql/mysql.sock could that be a problem with the chrooted apache? Thanks T
Re: phpMyAdmin
On Thu, Oct 25, 2012 at 10:40 PM, Richard Toohey richardtoo...@paradise.net.nz wrote: On 10/26/12 09:35, Tony Berth wrote: Dear group, I'm trying to run phpMyAdmin on a 5.1 box (i386) with MySQL 5.1.60 installed from the OpenBSD packages. When I try to login I get: #2002 Cannot log in to the MySQL server Please note that the same mysql user is able to login remotely via the MySQL GUI workbench! Now, I came across the following posting: http://marc.info/?l=openbsd-**miscm=116902953505548w=2http://marc.info/?l=openbsd-miscm=116902953505548w=2 and did apply the suggested solution but didn't work! I also have to mention that my sock file is located in: /var/run/mysql/mysql.sock could that be a problem with the chrooted apache? Thanks T chrooted Apache might not be able to resolve localhost, so you can try fixing that, or use 127.0.0.1 instead of localhost. You *may* also have to grant privileges to the user@127.0.0.1, but first just try changing the phpMyAdmin to point to 127.0.0.1. Not replying to the list because I haven't got my asbestos pants on today. correct! That indeed was the problem. Replacing localhost with 127.0.0.1 did work. Thanks a lot T
error : pkg add phpMyAdmin
Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. Thanks. J-F
Re: error : pkg add phpMyAdmin
On Tue, 14 Apr 2009 18:14:35 +0200, Jean-Francois wrote ... Can't install php5-gd-5.2.6: lib not found X11.11.1 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. I assume so graphic means no graphic You need to install the X libraries. Based on your lack of experience, , I recommend you follow the step-by-step instructions for installing xbase44.tgz in FAQ 4.10.
Re: error : pkg add phpMyAdmin
Jean-Francois wrote: Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. Looks like you're missing xbase44.tgz. -- Cezary Morga If everything seems under control, you're not going fast enough (Mario Andretti)
Re: error : pkg add phpMyAdmin
On Tue, 14 Apr 2009, Jean-Francois wrote: Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. Not again! Can't people read?? When buying something you don't know how it works. Do you wait someone to come home and fix it for you or do you read the manual? -- Antoine
Re: error : pkg add phpMyAdmin
On Tue, 14 Apr 2009 18:14:35 +0200 Jean-Francois jfsimon1...@gmail.com wrote: Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 ^^ Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. Thanks. J-F rtfm it's in the faq you dont have xbase44.tgz installed - Robert
Re: error : pkg add phpMyAdmin
Hi Did you set PKG_PATH correctly so that pkg_add can fetch dependencies ? No, I just use the standard configuration out of the box, which until now installed most packages without any problem. Did you install de xbase44.tgz packages? I guess no, I did not install X, I run console. This is a server. Is it mandatory for this package ? phpMyAdmin requires X ? Thanks Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. Thanks. J-F
Re: error : pkg add phpMyAdmin
Jean-Francois wrote: Did you install de xbase44.tgz packages? I guess no, I did not install X, I run console. This is a server. Is it mandatory for this package ? phpMyAdmin requires X ? xbase44.tgz doesn't contain complete X system, but it do contain X libraries required by some graphic-related packages, like php5-gd. -- Cezary Morga The average, healthy, well-adjusted adult gets up at seven-thirty in the morning feeling just plain terrible. (Jean Kerr)
Re : error : pkg add phpMyAdmin
Hi, That's why i asked the man ref / link, i could'nt find anything. But i see some do not understand what being patient with begininers mean. It's only few months i now use this system but it's really not easy thought theres a lot of documentations sometimes it's not easy to find where, is'nt it ?! Regards. 2009/4/14, Antoine Jacoutot ajacou...@bsdfrog.org: On Tue, 14 Apr 2009, Jean-Francois wrote: Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. Not again! Can't people read?? When buying something you don't know how it works. Do you wait someone to come home and fix it for you or do you read the manual? -- Antoine
Re: Re : error : pkg add phpMyAdmin
On Tue, 14 Apr 2009, Jean-Frangois SIMON wrote: Hi, That's why i asked the man ref / link, i could'nt find anything. But i see some do not understand what being patient with begininers mean. It's only few months i now use this system but it's really not easy thought theres a lot of documentations sometimes it's not easy to find where, is'nt it ?! Common, it has nothing to do with being a beginner. Did you read the FAQ, i.e Frequently Asked Questions? You call me impatient but you have been using this system only few months. How much time should I wait? A couple of years? This pissed me off because there are very talented people writing very fine documentation and there are other people translating it into most major languages. I'm sorry but there is no excuse not to read or at least refer to the FAQ when you encounter an issue. People give their time for this. -- Antoine
Re: error : pkg add phpMyAdmin
Jean-Frangois SIMON wrote: Hi, That's why i asked the man ref / link, i could'nt find anything. But i see some do not understand what being patient with begininers mean. Get used to it. Honestly :) It's only few months i now use this system but it's really not easy thought theres a lot of documentations sometimes it's not easy to find where, is'nt it ?! No. It's all here: http://www.openbsd.org/faq/index.html. -- Cezary Morga Indecision may or may not be my problem. (Jimmy Buffett)
Re: error : pkg add phpMyAdmin
Hi, I totally agree. I think I just missed it from where the info is available either in the man pages or directly in the FAQ itself. Le mardi 14 avril 2009 20:17:30, vous avez icrit : On Tue, 14 Apr 2009, Jean-Frangois SIMON wrote: Hi, That's why i asked the man ref / link, i could'nt find anything. But i see some do not understand what being patient with begininers mean. It's only few months i now use this system but it's really not easy thought theres a lot of documentations sometimes it's not easy to find where, is'nt it ?! Common, it has nothing to do with being a beginner. Did you read the FAQ, i.e Frequently Asked Questions? You call me impatient but you have been using this system only few months. How much time should I wait? A couple of years? This pissed me off because there are very talented people writing very fine documentation and there are other people translating it into most major languages. I'm sorry but there is no excuse not to read or at least refer to the FAQ when you encounter an issue. People give their time for this.
Re: error : pkg add phpMyAdmin
On 2009-04-14, Jean-Francois jfsimon1...@gmail.com wrote: Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. Thanks. J-F personally i'd just install xbase. but there is another possibility. there's also a php5-gd-...-no_x11, try pkg_add -i php5-gd. i don't remember what the tradeoff is, probably something with font support (maybe it will make it suck, maybe it will totally break it, either way i don't know whether that's a problem for phpMyAdmin). we distribute freetype in the xbase tarball; it doesn't make sense to put it in base, but having to install ports to run X would be much less acceptable than having to install parts of X to run some ports.
Re: error : pkg add phpMyAdmin
Tue, Apr 14, 2009 at 06:14:35PM +0200, Jean-Francois may have written: Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 phpMyAdmin needs php5 and the php5 GD extension. There are two versions of that extension, one that needs X libraries and one that doesn't. By default, pkg_add is picking the one that needs those libraries. Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. I'll assume here you meant no graphic support, and by that you mean that you did not install the X sets. Since pkg_add picked the GD extension package that needs X libraries, you get the error. Use: $ sudo pkg_add -i phpMyAdmin and pkg_add will recognize that there are two versions of the php5 GD extension package available and ask you which one to install. Use the one whose name includes no_x11. Alternatively, you can install package php5-gd-5.2.6-no_x11.tgz manually first, then install phpMyAdmin. Matt. -- With your own code to haunt you, who needs users? -- Maarten Wiltink
Re: error : pkg add phpMyAdmin
Thanks for that hint, it helped. Rgs, JF Le mardi 14 avril 2009 23:29:51 Matthew Clarke, vous avez icrit : Tue, Apr 14, 2009 at 06:14:35PM +0200, Jean-Francois may have written: Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 phpMyAdmin needs php5 and the php5 GD extension. There are two versions of that extension, one that needs X libraries and one that doesn't. By default, pkg_add is picking the one that needs those libraries. Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. I'll assume here you meant no graphic support, and by that you mean that you did not install the X sets. Since pkg_add picked the GD extension package that needs X libraries, you get the error. Use: $ sudo pkg_add -i phpMyAdmin and pkg_add will recognize that there are two versions of the php5 GD extension package available and ask you which one to install. Use the one whose name includes no_x11. Alternatively, you can install package php5-gd-5.2.6-no_x11.tgz manually first, then install phpMyAdmin. Matt.
Re: error : pkg add phpMyAdmin
It looks like right after installing there is a problem : at http://localhost/phpMyAdmin/index.php : a red line with phpMyAdmin - Erreur Erreur lors du do?=marrage de la session, veuillez vo?=rifier les erreurs indiquo?=es par PHP ou dans le fichier to?=moin du serveur web, et configurer PHP correctement. Then from apache error log : [Wed Apr 15 00:17:04 2009] [error] PHP Warning: session_start() [a href='function.session-start'function.session-start/a]: open(/tmp//sess_kt447gtf9i2qj3f74b3jve2abdf8fgi8, O_RDWR) failed: Permission denied (13) in /phpMyAdmin/libraries/session.inc.php on line 87 [Wed Apr 15 00:17:04 2009] [error] PHP Warning: Unknown: open(/tmp//sess_kt447gtf9i2qj3f74b3jve2abdf8fgi8, O_RDWR) failed: Permission denied (13) in Unknown on line 0 [Wed Apr 15 00:17:04 2009] [error] PHP Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0 I made the sym link as stated - did I miss something ? What are basic tests to find the root ? any idea ? Thank you. Le mardi 14 avril 2009 23:54:50, vous avez C)crit : Thanks for that hint, it helped. Rgs, JF Le mardi 14 avril 2009 23:29:51 Matthew Clarke, vous avez C)crit : Tue, Apr 14, 2009 at 06:14:35PM +0200, Jean-Francois may have written: Hello, Can you please help me with this : $ sudo pkg add phpMyAdmin-2.11.7.1.tgz Can't install php5-gd-5.2.6: lib not found X11.11.1 phpMyAdmin needs php5 and the php5 GD extension. There are two versions of that extension, one that needs X libraries and one that doesn't. By default, pkg_add is picking the one that needs those libraries. Dependencies for php5-gd-5.2.6 resolve to: jpeg-6bp3, php5-core-5.2.6, t1lib-5.1.0p1, png-1.2.28 Full dependency tree is libiconv-1.12,jpeg-6bp3,libxml-2.6.32p1,php5- core-5.2.6,t1lib-5.1.0p1,gettext-0.17,png-1.2.28 Can't install php5-gd-5.2.6: lib not found Xpm.8.0 Can't install php5-gd-5.2.6: lib not found freetype.16.1 Can't install phpMyAdmin-2.11.7.1: can't resolve php5-gd-5.2.6 FYI box is 4.4 fresh install, i386, working as a server, so graphic support. I'll assume here you meant no graphic support, and by that you mean that you did not install the X sets. Since pkg_add picked the GD extension package that needs X libraries, you get the error. Use: $ sudo pkg_add -i phpMyAdmin and pkg_add will recognize that there are two versions of the php5 GD extension package available and ask you which one to install. Use the one whose name includes no_x11. Alternatively, you can install package php5-gd-5.2.6-no_x11.tgz manually first, then install phpMyAdmin. Matt.
Re: error : pkg add phpMyAdmin
On Wed, 15 Apr 2009, Jean-Francois wrote: It looks like right after installing there is a problem : at http://localhost/phpMyAdmin/index.php : a red line with phpMyAdmin - Erreur Erreur lors du do?=marrage de la session, veuillez vo?=rifier les erreurs indiquo?=es par PHP ou dans le fichier to?=moin du serveur web, et configurer PHP correctement. Then from apache error log : [Wed Apr 15 00:17:04 2009] [error] PHP Warning: session_start() [a href='function.session-start'function.session-start/a]: open(/tmp//sess_kt447gtf9i2qj3f74b3jve2abdf8fgi8, O_RDWR) failed: Permission denied (13) in /phpMyAdmin/libraries/session.inc.php on line 87 [Wed Apr 15 00:17:04 2009] [error] PHP Warning: Unknown: open(/tmp//sess_kt447gtf9i2qj3f74b3jve2abdf8fgi8, O_RDWR) failed: Permission denied (13) in Unknown on line 0 [Wed Apr 15 00:17:04 2009] [error] PHP Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0 I made the sym link as stated - did I miss something ? What are basic tests to find the root ? any idea ? You need to give write permissions to your webserver on the /var/www/tmp directory. -- Antoine
Re: error : pkg add phpMyAdmin
On Wed, Apr 15, 2009 at 12:24 AM, Jean-Francois jfsimon1...@gmail.com wrote: [Wed Apr 15 00:17:04 2009] [error] PHP Warning: session_start() [a href='function.session-start'function.session-start/a]: open(/tmp//sess_kt447gtf9i2qj3f74b3jve2abdf8fgi8, O_RDWR) failed: Permission denied (13) in /phpMyAdmin/libraries/session.inc.php on line 87 [Wed Apr 15 00:17:04 2009] [error] PHP Warning: Unknown: open(/tmp//sess_kt447gtf9i2qj3f74b3jve2abdf8fgi8, O_RDWR) failed: Permission denied (13) in Unknown on line 0 [Wed Apr 15 00:17:04 2009] [error] PHP Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0 I made the sym link as stated - did I miss something ? Man, have you at least looked at the output of pkg_add?!? The error message is pretty clear... $ pkg_info -M php5-core [...] Don't forget that the default OpenBSD httpd is chrooted into /var/www by default, so you may need to create support directories such as /var/www/tmp for PHP to work correctly. -- Mattieu Baptiste /earth is 102% full ... please delete anyone you can.
Re: mysql + phpmyadmin
If you are running the phpmyadmin locally with the mysql server, and you are using the socket, not tcp, as your connection to the db server, then ps aux | grep mysql should reveal a --socket=/path/to/socket Then in the phpmyadmin config.inc.php file you would place the following- $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket']= '/path/to/socket'; $cfg['Servers'][$i]['connect_type'] = 'socket'; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['compress'] = FALSE; Keep in mind that if running phpmyadmin in a chrooted apache then it will perceive the /var/www/ as the root of it's directory structure. In one of my particular setups, I created '/var/www/var/run/mysql.sock' as the place the mysql socket is created, and then the socket path (the '/path/to/socket' shown above) according to phpmyadmin is '/var/run/mysql.sock'. Otherwise, if you are using tcp to establish the db connection instead of the local socket (['connect_type'] = 'tcp';), then in the ['port'] section you would list '3306' (or whatever port you have it running on.) Then of course you could try telnetting to localhost on 3306 to see if a connection is established. You should get something similiar this- # telnet localhost 3306 Trying ::1... telnet: connect to address ::1: Connection refused Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 8 5.0.18-log2wxwm;~+X,X35QvUpS/1Connection closed by foreign host. If you don't, then perhaps your local firewall or hosts.allow file isn't properly configured to allow a connection from localhost itself (just a guess.) Hope this helps, Dan Farrell Applied Innovations [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeroen Massar Sent: Tuesday, January 16, 2007 8:23 PM To: Der Engel Cc: misc@openbsd.org Subject: Re: mysql + phpmyadmin Der Engel wrote: Hi, Installed mysql+phpmyadmin on OBSD 4.0, when doing http://host/phpMyAdmin/index.php i get the following error: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) I can connect remotely just fine using mysql query browser tool, anyone have had this problem? any ideas on how to resolve it? I tried #httpd -u but same error. When using a socket device, check permissions of the MySQL socket and the path leading up to it. When using a network socket, check if you can telnet into it. Also note that Apache (you only mentioned httpd) might be in a chroot or running as a different user than what you expect it to be. and of course check firewall rules etc. Greets, Jeroen [demime 1.01d removed an attachment of type application/pgp-signature which had a name of signature.asc]
mysql + phpmyadmin
Hi, Installed mysql+phpmyadmin on OBSD 4.0, when doing http://host/phpMyAdmin/index.php i get the following error: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) I can connect remotely just fine using mysql query browser tool, anyone have had this problem? any ideas on how to resolve it? I tried #httpd -u but same error. Thanks, Der
Re: mysql + phpmyadmin
Der Engel wrote: Hi, Installed mysql+phpmyadmin on OBSD 4.0, when doing http://host/phpMyAdmin/index.php i get the following error: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) I can connect remotely just fine using mysql query browser tool, anyone have had this problem? any ideas on how to resolve it? I tried #httpd -u but same error. When using a socket device, check permissions of the MySQL socket and the path leading up to it. When using a network socket, check if you can telnet into it. Also note that Apache (you only mentioned httpd) might be in a chroot or running as a different user than what you expect it to be. and of course check firewall rules etc. Greets, Jeroen [demime 1.01d removed an attachment of type application/pgp-signature which had a name of signature.asc]
Problems with MySQL/phpMyAdmin in 3.6/3.7
Hi everybody! For a some days, I tried to install a server with the typically software for a current server (PHP, MySQL, phpMyAdmin...). But I have a great problem with MySQL, because I can't access to phpMyAdmin from other PC of my LAN, but when I try access to the mysql shell I can enter correctly. For enter from other hosts I add to the database a other user with all privileges without host, as the following example: GRANT ALL PRIVILEGES ON *.* TO root@'' IDENTIFIED BY 'password' WITH GRANT OPTION; I've tried to install from scratch the servers some times with OpenBSD 3.6 and OpenBSD 3.7 but always occur the same problem. I don't know that I can do now :(, I search on Google without any result. Thanks for all. Regards, Carlos Mantero. -- Carlos Mantero [EMAIL PROTECTED] Bomb, terrorism, Bin Laden, antrax, nuclear bomb... Hello Echelon!!!
Re: Problems with MySQL/phpMyAdmin in 3.6/3.7
On Mon, Jul 04, 2005 at 10:41:01AM +0200, Carlos Mantero wrote: Hi everybody! For a some days, I tried to install a server with the typically software for a current server (PHP, MySQL, phpMyAdmin...). But I have a great problem with MySQL, because I can't access to phpMyAdmin from other PC of my LAN, but when I try access to the mysql shell I can enter correctly. For enter from other hosts I add to the database a other user with all privileges without host, as the following example: GRANT ALL PRIVILEGES ON *.* TO root@'' IDENTIFIED BY 'password' WITH GRANT OPTION; I've tried to install from scratch the servers some times with OpenBSD 3.6 and OpenBSD 3.7 but always occur the same problem. I don't know that I can do now :(, I search on Google without any result. Thanks for all. I never installed such software on my servers, but I think you must have a look at the chrooted apache of OpenBSD, or start the httpd daemon with the -u option (unsecure). Just a wild guess, since I suppose that mysql is installed somewhere out of /var/www/... no? -- Thanos Tsouanas .: Sians http://thanos.sians.org/ .: http://www.sians.org/
Re: Problems with MySQL/phpMyAdmin in 3.6/3.7
Hi, I've just sussed out similar problems too. FIrst of all check the domain you are granting is exactly the same as what mysql has complained about. It will translate things according to /etc/hosts. I didnt use WITH GRANT OPTION on my setup. not sure if that helps. Also are you aware of chroot? Edd On 7/4/2005, Carlos Mantero [EMAIL PROTECTED] wrote: Hi everybody! For a some days, I tried to install a server with the typically software for a current server (PHP, MySQL, phpMyAdmin...). But I have a great problem with MySQL, because I can't access to phpMyAdmin from other PC of my LAN, but when I try access to the mysql shell I can enter correctly. For enter from other hosts I add to the database a other user with all privileges without host, as the following example: GRANT ALL PRIVILEGES ON *.* TO root@'' IDENTIFIED BY 'password' WITH GRANT OPTION; I've tried to install from scratch the servers some times with OpenBSD 3.6 and OpenBSD 3.7 but always occur the same problem. I don't know that I can do now :(, I search on Google without any result. Thanks for all. Regards, Carlos Mantero. -- Carlos Mantero [EMAIL PROTECTED] Bomb, terrorism, Bin Laden, antrax, nuclear bomb... Hello Echelon!!! -- This email has been verified as Virus free Virus Protection and more available at http://www.plus.net
