[RESOLVED] How to Install GD2 ....

anoopd

Hi
I am using PHP Version 4.4.0 with IIS 5.1 .when i tried phpinfo it is not showing anything with GD as heading .I downloaded GD 2.0.33 but dont know how to install it..Please somebody help me.I dont even have the extentions folder in the PHP directory.Should i create one?There are no dll files in the download.Please somebody make it clear

Houdini

You most likely already have GD2 it is in the php/tex/ or php/extensions look at your php.ini which with IIS probably is in Windows/system/ or Windows/system32
just uncomment by removing the semicolon e.g.

;extension=php_fribidi.dll
extension=php_gd2.dll//this is uncommented

Then just restart the server and so a phpinfo() and recheck gd enabled ought to now have its own table right after FTP (if it is enabled).

anoopd

I dont have extentions folder in c:\php .When i tried to uncomment that line it showed a warning unable to load dynamic library php_gd2.dll.I have tried this and failed misserabbly.I have to install that dll i just want to know that procedure🙁

Houdini

find out where all your dll's are PHP comes with a PHP folder so if it is in c:\php\ the within that folder there should be c:\php\ext\ and a whole bunch of dll's you need to find your 'active' php.ini. PHP come with two php.ini files they are php.ini-dist and php.ini-recommended they are in the /php/ wherever you or the installation program put it, 4.3.0 came with the gd2 dll so you already have it. you might want to reinstall php then pay attention as to where your php folder is placed, the php.ini-dist is very restricted and no extensions are enabled whereas php.ini-recommended has no extensions loaded either this is up to you. Do a search on your hard drive and find the "acitve" php.ini you will come up with at least the two above mentioned but PHP looks for php.ini (not php.ini-dist or php.ini-recommended) usually you set your php.ini the way you want your install and place it in the c:\windows\system[/B] for Window98. Also look for your php folder and within it you should see the ext folder and within it you should see the php_gf2.dll along with about 32 others.

anoopd

Hi,
I tried a search for dll files starting with php (php*.dll) and i got three files php4ts.dll,
php_mysql.dll and php_mysqli.dll.Is there is some problem with my installation ?should i reinstall my php?

Houdini

To save yourself the headaches of moving stuff around and editing and putting here and moving there and all that either reinstall or get an Apache server with PHP MySQL PHP 4 and 5 phpMyAdmin Perl a FTP server and a mail server with XAMPP it will install all that properly and then all you need to do to have bd is uncomment the php_gd2.dll line in apache/bin/php.ini. It install in about 5 minutes although it is a large file over 20 meg. I have not used IIS since 2002 since I found XAMPP. For more info or to download see XAMPP home page

anoopd

As you ve said i downloader the Xampp installer and installed it but still when i try that php info it is showing version 4.4.0.should i uninstall the previous version?Apache is also having some probs .. i think that s cause IIS is already there ... (I have to change the port settings right?).Please help

Houdini

Turn off the IIS and forget about it, it will fight with Apache, make sure that apache is running and IIS is off or disabeled. Then if you have the latest version of XAMPP the php.ini is located in the apache/bin/ folder at c:\Program Files\xampp\apache\bin[/B] Web servers normally use port 80. You should have a control panel for XAMPP where you control Apache MySQL FileZilla and the Mercury mailserver.

Return a post when you have Apache running and IIS turned off.

You should have a control Panel that looks kind of like this one with XAMPP
XAMPP CP

When XAMPP is running then you should have a screen like this when clicking the Admin of the XAMPP Control Panel.
XAMPP Home Page

anoopd

Yes i have done that i am getting the new page rightnow! Thanks for the help.I have GD installed (i got it in php infor and the xamp examples).The problem i am facing is with mysql.I had a username and password for mysql but now xamp shows i dont have one for root ... that was right. I had lots of dbs in this username and pass but right now phpmyadmin is not showing anyone... Why is it so ..... ?

Houdini

Because when phpMyAdmin is set up on a new XAMPP install it uses the same default values of username = root and no password. So If you are using this on your local PC them that is OK, but to use phpMyAdmin you must either put those values into the config.inc.php file that looks like this

// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
// $cfg['Servers'][0]. You can disable a server config entry by setting host
// to ''. If you want more than one server, just copy following section
// (including $i incrementation) serveral times. There is no need to define
// full server array, just define values you need to change.
$i++;
$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']   = 'pma';          // MySQL control user settings

Or through the admin to MySQL add a user with all privledges and a password. Since you are the only one using the system then it would be better to just leave it alone as is and alter your code to reflect a userneame of root
e.g.

$connect = mysql_connect('localhost', 'root');

anoopd

Hi
I am able to use my old databases now 🙂.Ty so much.But right now i just cant create new dbs🙁 .I tried with the old phpmyadmin (2.7.0) but it says missiong parameter:db error.In my new one(2.8.03) i dont have that create db textbox!!I will upload how my phpmyadmin page looks .What s the problem now ?.Still i dont have root password for mysql whenever i try to set it it is giving an error.

Houdini

You phpMyAdmin is showing a username of scott on the localhost, and apparantly that user has no privlidges so to fix that first go to the config.inc file in the xampp/phpmyadmin folder and make sure that it looks exactly as below

$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']   = 'pma';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
                                                    // and "mysql/db" tables).
                                                    // The controluser is also
                                                    // used for all relational
                                                    // features (pmadb)
$cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                    // with 'config' auth_type)
$cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
                                                    // this db is displayed in left frame
                                                    // It may also be an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb']         = 'phpmyadmin';          // Database used for Relation, Bookmark and PDF Features
                                                    // (see scripts/create_tables.sql)
                                                    //   - leave blank for no support
                                                    //     DEFAULT: 'phpmyadmin'

Since you are using this on a local PC then there is no need to have a password protected account, unless a whole bunch of people have access to your machine and they don't necessarily like you. You can then run phpMyAdmin normally and assign privlidges for a new user then go back to the config.inc file and amend it after you have created a new user account with full privlidges. Apparently right now the MySQL server does not have a username of scott so this is why you are getting the page as it is.

anoopd

Hi
I have username with scott and a password for that and i loged in using that username and password.I did got all the dbs i have set before using this username and pass(The Databases combo box is there in the left)But i just cant create new dbs there...🙁. I just tried to edit that config.inc file as u said but even then i cant set privilage for a new user... i just tried this querry

GRANT USAGE ON mysql.* TO admin@localhost IDENTIFIED BY "j823kfg2ld";

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 admin@localhost;

GRANT SELECT ON mysql.db TO admin@localhost;

GRANT SELECT ON mysql.host TO admin@localhost;

GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO admin@localhost;

to get the error below
#1044 - Access denied for user: '@' to database 'mysql'

Please help

Houdini

It almost sounds like you have two instances of MySQL, let me think, have you tried to go to privlidges as root and set privlidges for the username?

anoopd

Yes i tried to set privilages by loging in as root🙁

Houdini

First do you now have the GD2 problem fixed? Second go to phpMyAdmin select the mysql database then run this query

SELECT * FROM users

This will show all users that are allowed by MySQL and the provlidges, edit the ones there but leave root alones it has full permissions then set the permisssions as you desire for any other users. On my local machine I just use my own, but keep in mind that if you change the root to have a password you MUST make changes in the conf.inc file of phpMyAdmin or it will not connect.

If you can make a dump of all your databases and save them in a temporary directory or one just for database backups. Now if you have forgotten what name and what passwords that you have given what permission to then you are the only one that can fix that. MySQL comes by default with root as a super user with every privlidge that is possible, and if for some reason (possibly seeing the little warning which you should disregard in phpMyAdmin about having an insecure database) you added a password to root which by default has none you will have to recollect that password or wipe out the MySQL altogether (remember you have saved your databases elsewhere) and possibly reinstall XAMPP and go into each mysql folder that is on your hard drive and delete it in its entirety, after chutting down all servers apache IIs and MySQL then just do a reinstall of XAMPP and everything will be just fine. Otherwise you will forever be chasing ghosts trying to get your server to behave so you can write code.

anoopd

Hi
I tried uninstalling php,mysql.phpmyadmin and xampp and then deleted php.ini from windows.Then i reinstalled xampp but during installation it said "mysql seems to be already installed" and aborted setup.rest went fine but when i checked the status it said mysqldatabase deactivated ...how should i rectify this???

Houdini

Before you reinstall XAMPP you should go to the XAMPP folder and manually delete all the phpMyAdmin, PHP and MySQL folders and files. Most likely you did not do a fresh clean reinstall that directory must be empty, if you can not delete a folder like the MySQL directory it is because the MySQL server is running, you can not delete a file that is in use. When the XAMPP directory is completely empty then reinstall XAMPP.

anoopd

I tried that too but in vain🙁.Think i should go back to the old one .... just GD was my problem but now i just cant run a single script with db ...so i think i should use my old IIS with php and mysql .. anyway thanks a lot for your time and help ..

Houdini

Probably the MySQL from the IIS is still running, you can only have one running at a time that is part of you problem, you can run one or the other but not both.