RegLinUsr Posted March 11, 2011 Report Share Posted March 11, 2011 I am beginning with a clean UniServer Nano5.7.4 and default Joomla 1.5.22 install. I changed all of the UniServer security name/password [user01/open4me] combinations and set the mySQL password as above. I created my database, joom1, via phpMyAdmin. I then go to setup Joomla and get as far as the database configuration screen. - Database Type: mySQL - Host Name: localhost [and tried 127.0.0.1] - Username: user01 - Password: open4me - Database Name: joom1 At that point, I get the following error upon attempting to submit my configuration choices. Error: Could not connect to the database. Connector returned number: Unable to connect to the database:Could not connect to MySQL Any ideas as to what the issue may be? Did I miss anything? Thanks! ================== UNIFORM SERVER STATUS ================== Your Internet IP Address = ###.###.###.### Accessible from Internet = NO Cron run status = Not running PHP INI: php.ini file = Production APACHE SERVER: Apache port = 80 Apache SSL port = 443 Apache executable name = Apache.exe Apache service name = ApacheS1 Apache SSL server = Enabled Apache run status = Running Apache install status = Installed as a standard program MySQL SERVER: MySQL port = 3306 MySQL executable name = mysqld-opt.exe MySQL service name = MySQLS1 MySQL run status = Running MySQL install status = Installed as a standard program PORT STATUS: Apache port = 80 In use by this server Apache SSL port = 443 In use by this server MySQL port = 3306 In use by this server Press any key to continue . . . Quote Windows 7 Ultimate (Version 6.1 Build 7600) UniServer NANO 5.7.4 Joomla 1.5.22 Link to comment Share on other sites More sharing options...
Shyokou Ouyou Posted March 11, 2011 Report Share Posted March 11, 2011 As if another instance of the IP stack priority in Windoze se7en, where IPv6 is preferred over IPv4 ... Please refer to either this or that as well as further references, if you like ... I am beginning with a clean UniServer Nano5.7.4 and default Joomla 1.5.22 install. I changed all of the UniServer security name/password [user01/open4me] combinations and set the mySQL password as above. I created my database, joom1, via phpMyAdmin. I then go to setup Joomla and get as far as the database configuration screen. - Database Type: mySQL - Host Name: localhost [and tried 127.0.0.1] - Username: user01 - Password: open4me - Database Name: joom1 At that point, I get the following error upon attempting to submit my configuration choices. Error: Could not connect to the database. Connector returned number: Unable to connect to the database:Could not connect to MySQL Any ideas as to what the issue may be? Did I miss anything? Thanks! ================== UNIFORM SERVER STATUS ================== Your Internet IP Address = ###.###.###.### Accessible from Internet = NO Cron run status = Not running PHP INI: php.ini file = Production APACHE SERVER: Apache port = 80 Apache SSL port = 443 Apache executable name = Apache.exe Apache service name = ApacheS1 Apache SSL server = Enabled Apache run status = Running Apache install status = Installed as a standard program MySQL SERVER: MySQL port = 3306 MySQL executable name = mysqld-opt.exe MySQL service name = MySQLS1 MySQL run status = Running MySQL install status = Installed as a standard program PORT STATUS: Apache port = 80 In use by this server Apache SSL port = 443 In use by this server MySQL port = 3306 In use by this server Press any key to continue . . . Quote Link to comment Share on other sites More sharing options...
RegLinUsr Posted March 12, 2011 Author Report Share Posted March 12, 2011 As if another instance of the IP stack priority in Windoze se7en, where IPv6 is preferred over IPv4 ... Please refer to either this or that as well as further references, if you like ... None of that has anything to do with my problem. I am able to access both the UniServer and the Joomla installation via browsing to either http://localhost/ and http://localhost/joomla/ or http://127.0.0.1/ and http://127.0.0.1/joomla/ in Firefox. As well, my C:\WINDOWS\system32\drivers\etc\hosts is already set to "127.0.0.1 localhost" with both of these lines commented out by default; "#127.0.0.1 localhost" & "#::1 localhost" I have since deleted the entire UniServer and then completed a clean install using Nano 5.7.4. In this install, I created my new MySQL database but used a new MySQL user instead of ROOT but did not grant global access, only granting full database privileges. Upon getting to the Joomla Database Configuration screen, I used the following settings. - Database Type: mySQL - Host Name: 127.0.0.1 - Username: user01 - Password: open4me - Database Name: user01 Now I get a completely different error upon configuration submission. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8` I searched some more and found information about V55_Joomla_1_5_15a.exe buried in an older announcements post. I then tried the Uniform Server Joomla plugin as listed on the Uniform Server 5.5-Nano, Released Announcements page. Upon using this plugin, I'm able to have a working Joomla. So, what gives?! Why is it that it seems that Joomla can be setup to run on the UniServer but we can't actually do so ourselves? Quote Windows 7 Ultimate (Version 6.1 Build 7600) UniServer NANO 5.7.4 Joomla 1.5.22 Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.