2. PHPRunner General questions
  3. [SOLVED]  libmysql.dll quandry
This topic is locked
[SOLVED]

 libmysql.dll quandry

 		5/7/2005 12:42:15 PM
PHPRunner General questions
author

Thank you, Sergey. I was successful in getting things working with Apache2/PHP/mySQL.
I'm now experienceing the same problem Peter was dealing with. I copied the libmysql.dll file from C:\WebServ\mySQL\bin to C:\WebServ\php\dlls and \Windows\SYSTEM32. I still encountered the following mesage:

_

PHP error happened
Technical information

Error type 2

Error description mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client

URL localhost/crms/publicationslist.php

Error file C:\WebServ\wwwroot\htdocs\crms\include\dbconnection.php

Error line 9

SQL query


On further research I discovered that I have several versions of libmysql.dll.

  1. C:\WebServ\php 228KB 9/23/04 11:31am
  2. C:\WebServ\apache2\bin 228KB 7/13/04 8:00pm
  3. C:\WebServ\mySQL\bin 240KB 9/08/04 3:56pm
  4. C:\WebServ\mySQL\mysqladmin 916KB 6/04/04 12:03pm

    5: C:\WebServ\php\dlls 240KB 9/08/04 3:56am

    6: C:\My Downloads\php-5.0.4-Win32.zip contains one 1044KB dated 3/31/05 2:52am
    I would think they should all be the same but I'm really not sure which one I should use.
    Can you offer any help? I'm befuddled!
    Thanks,

    Roy
pplaut 5/9/2005

Hey,
I ran into a strange problem with database connectivity.

In my PHP.ini at one point I had to comment out the following because mysql is now supported another way? I dunno, but it worked.
;Windows Extensions

;Note that MySQL and ODBC support is now built in, so no dll is needed for it.

;
;extension=php_msql.dll
Hope this helps.
Peer
Admin 5/10/2005

Roy,
as far as PHPRunner works you may take libmysql.dll file from C:\Program Files\PHPRunner and copy it here: C:\Windows\SYSTEM32.
To avoid confusion in future you can delete libmysql.dll file from these locations:

  1. C:\WebServ\php 228KB 9/23/04 11:31am
  2. C:\WebServ\apache2\bin 228KB 7/13/04 8:00pm
  3. C:\WebServ\mySQL\bin 240KB 9/08/04 3:56pm
  4. C:\WebServ\mySQL\mysqladmin 916KB 6/04/04 12:03pm

    5: C:\WebServ\php\dlls 240KB 9/08/04 3:56am
    or replace them by libmysql.dll file from C:\Program Files\PHPRunner too.
roy 5/11/2005

Thanks, Sergey.
I got rid of WebServ, which is an all-in-one install for Apache2/mySQL/PHP, and reinstalled the applications independently. Problem solved!
There are a couple of question that remain unanswered, though.
I would like to eliminate the search banner at the top of many of the screens. I've deactivated all the search and advanced search fields in PHPRunner, but the banner is still there. It simply limits the search to "any field." If it can't be eliminated, can you show me how to move it to the bottom of the screen?
Additionally, I'm having some issues with display format. I'll try to describe what's happening for one of the tables. I am having the problem with a couple of tables. I have a table called "CONTRACTS" and it contains the following columns: busid int(5), zone tinyint(3), volume tinyint(3), issue tinyint(3), section varchar(15) and adsize varchar(15). I'm displaying it horizontally and the volume and issue columns are displaying way too wide and the section and ad_size are displaying too narrow. In the display the busid is being replaced by the busname (varchar(30)) from a lookup table in the database ("Businesses") and the zone is being replaced by the zonedesc (varchar(25)) from a lookup table in the database ("Zones"), both columns are being displayed way too narrow. Now comes the kicker! The columns for "edit" and "delete" are so wide that they each take up about a third of the screen. That only leaves a third of the screen for the "real" data.
Roy
Admin 5/16/2005

Hi,
you can eliminate the search banner using new update of PHPRunner 2.0.

Please download it here.
You can set the column width on the Formatting tab in PHPRunner.