Has anyone gotten this configuration to work?

Peccavi

I use it for development and testing.

Win2000 + XAMPP 1.4.9 + XOOPS 2.0.7.3/2.0.9-beta

Could you describe your problem in more detail?

Xamp uses PHP 5 by default. You'll either need to change the settings to use PHP 4 or use XOOPS 2.0.9. For information on how to select between versions of PHP, see the Xamp documentation.

Also....
Quote:

Quote:

Hello Dave_L (and others in this thread)

I think I have the same problem as Peccavi: XOOPS with Xampp on Win xp: install seemingly OK, until the first login: where the links for login are DEAD. The Xampp is seemingly working fine, e.g. switching between php5 and 4 is just a matter of a click, but when I start mysqladmin (in xampp/mysql/bin/ ) only one database (called "test") is listed. Without being able to understand why, I do have the feeling, that the problem is NOT in the configuration of xoops, but in the way MySQL is registered by win xp. I tried to read on the MySQL Documentation site, but the writing there largely surpasses my tecnical abilities.

So to conclude a question: How is MySQL registered by win xp ? (I know it has to be running as a "service" but what does this mean, and how can I check my settings and change them if necessary?

Grateful for any clues (or links to writing on the topic)

Per

I'm not a programmer, but searching around for info

Quote:

Do you mean mysql, rather than mysqladmin?

That happens for me too, if I don't specify a username when running mysql. If I invoke MySQL as "mysql -u root", then all the databases show up.

If the MySQL service were not running, you'd get an error about not being able to connect to the MySQL server.

You could also try running phpMyAdmin by browsing to http://localhost/phpmyadmin/

This sounds like you may not have the right MySQL login info in the XOOPS mainfile.php. Check that the following constants in mainfile.php have the right values:

XOOPS_DB_TYPE
XOOPS_DB_PREFIX
XOOPS_DB_HOST
XOOPS_DB_USER
XOOPS_DB_PASS
XOOPS_DB_NAME

Running Xampp 1.4.10a on Win XP

I currently have 5 other CMS engines running properly...
Something is right with Apache 2.0.52 PHP 4.3.9 SQL 4.1.7

I do not have the same problem as per_t !!

MySQL db has 31 Tables, currently with 280 records.

Turned on debugging
https://xoops.org/modules/smartfaq/faq.php?faqid=80

I get the following errors:

Warning [Xoops]: Smarty error: unable to read template resource: "db:system_block_login.html" in file Xoops_Physical_Path\class\smarty\Smarty.class.php line 1042

Warning [Xoops]: Smarty error: unable to read template resource: "db:system_block_mainmenu.html" in file Xoops_Physical_Path\class\smarty\Smarty.class.php line 1042

In class/smarty/Smarty.class.php I turned on debugging
var $debugging = true;

Smarty finds these includes

default/theme.html
default/theme_blockleft.html
default/theme_blockleft.html

but fails to find these

db:system_block_login.html
db:system_block_mainmenu.html

Someone told me the missing file in templates_c is ...
db%3Asystem_block_mainmenu.html

Where is this created?

Help? Ideas? Suggestions? Anything... PLZ

Should I need to drop back to Xampp 1.4.9?

Peccavi

(sorry, Peccavi, for obscuring your topic

Dave_L,
Thank's for your reply. I actually mean mysqladmin...

Maybe the problem is in my use of the WAMPP-installer and its GUI ? it is supposed to take care of all the wamp-components; however it doen't seem to register MySQL in win xp (proffessional) the right way.

Since I don't know exately what to ask, I'll keep up trying something

My XAMPP-package has the following README, and since I used the WAMPP-Installer programm, I did not follow the noted steps. Still, the directives might give a clue:
(If a moderator regards this volume-posting to be too much, feel free to delete the whole message)

ApacheFriends XAMPP (basic package) version 1.4.10a (win32)

+ Apache 2.0.52
+ MySQL 4.1.7
+ PHP 5.0.3RC2-dev + PHP 4.3.9 + PEAR
+ PHP-Switch win32 1.0 (von Apachefriends, man nehme die "php-switch.bat")
+ XAMPP Security 1.0
+ MiniPerl 5.8.3
+ SQLite 2.8.15
+ PHPMyAdmin 2.6.0 pl3
+ ADODB 4.52
+ Mercury Mail Transport System for Win32 and NetWare Systems v4.01a
+ FileZilla FTP Server 0.9.4d
+ Webalizer 2.01-10
+ Zend Optimizer 2.5.7

* System Requirements:

+ 64 MB RAM (recommended)
+ 115 MB free Fixed Disk
+ Windows 98, ME, XP Home
+ Windows NT, 2000, XP Professional (Recommended)

QUICK INSTALLATION:

[Step 1: Unpack the package to your usb stick or a partition of your choice.
There it must be on the highest level like E:\ or W:\. It will
build E:\xampp or W:\xampp or something like this. Please do not
use the "setup_xampp.bat" for an USB stick installation!]

Step 1: Unpack the package into a directory of your choice. Please start the
"setup_xampp.bat" and beginning the installation. Note: xampp makes no
entries in the windows registry and no settings for the system variables.

Step 2: If installation ends successfully, start the Apache 2 with
"apache_start".bat", MySQL with "mysql_start".bat". Stop the MySQL
Server with "mysql_stop.bat". For shutdown the Apache HTTPD, only
close the Apache Command (CMD).

Step 3: Start your browser and type http://127.0.0.1 or
http://localhost in the location bar. You should see our pre-made
start page with certain examples and test screens.

Step 4: PHP (with mod_php, as *.php, *.php4, *.php3, *.phtml), Perl
by default with *.cgi, SSI with *.shtml are all located in
=> \...\xampp\htdocs\.
Beispiele (Examples):
=> \...\xampp\htdocs\test.php => http://localhost/test.php
=> \...\xampp\myhome\test.php => http://localhost/myhome/test.php

Step 5: XAMPP UNINSTALL? Simply remove the "xampp" Directory.
But before please shutdown the apache and mysql.

---------------------------------------------------------------
PASSWORDS

1) MySQL

user: root
password:
(means no password!)

2) FileZilla FTP

user: newuser
password: wampp

user: anonymous
password: some@mail.net

3) Mercury:
Postmaster: postmaster (postmaster@localhost) und Admin (Admin@localhost)

Testuser: newsuser
password: wampp

4) WEBDAV:

user: wampp
password: xampp

---------------------------------------------------------------
ONLY FOR NT SYSTEMS
(NT4 | windows 2000 | windows xp professional)

\...\xampp\apache\apache_installservice.bat =
==> Install Apache 2 as service

\...\xampp\apache\apache_uninstallservice.bat =
==> Uninstall Apache 2 as service

\...\xampp\apache\mysql_installservice.bat =
==> Install MySQL as service

\...\xampp\apache\mysql_uninstallservice.bat =
==> Uninstall MySQL as service

==> After all Service (un)installations, better restart system!
----------------------------------------------------------------


Apache Notes:

(1) In contrast of apache 1.x, you can not stop the apache2
with the command "apache -k shutdown". These functions only for
an installations as service by NT systems. So, simply close
the Apache START command for shutdown.

(2) To use the experimental version of mod_auth_mysql remove the # in
the httpd.conf. Detailed information about this topic can be found on
the left menu of xampp, once you started it.

(3) To use Mod_Dav load the Modules
mod_dav.so + mod_dav_fs.so in the httpd.conf by removing the # on
the beginning of their lines. Then try http://127.0.0.1:81 (not
for Frontpage, but for Dreamweaver)


MYSQL NOTES:

(1) The MySQL server can be started by double-clicking (executing)
mysql_start.bat. This file can be found in the same folder you installed
xampp in, most likely this will be C:\xampp\.
The exact path to this file is X:\xampp\mysql_start.bat, where
"X" indicates the letter of the drive you unpacked xampp into.
This batch file starts the MySQL server in console mode. The first
intialization might take a few minutes.

Do not close the DOS window or you'll crash the server!
To stop the server, please use mysql_shutdown.bat, which is located in the same
directory.

(2) To use the MySQL Daemon with "innodb" for better performance,
please edit the "my" (or "my.cnf") file in the /xampp/mysql/bin
directory or for services the c:\my.cnf for windows NT/2000.
In there, activate the "innodb_data_file_path=ibdata1:30M"
statement. Attention, "innodb" is not recommended for 95/98/ME/XP Home.

To use MySQL as Service for NT/2000/XP Professional, simply copy the "my"
/ "my.cnf" file to C:\my, or C:\my.cnf. Please note that this
file has to be placed in C:\ (root), other locations are not permitted. Then
execute the "mysql_installservice.bat" in the MySQL folder.


(3) MySQL starts with standard values for the user id and the password. The preset
user id is "root", the password is "" (= no password). To access MySQL via PHP
with the preset values, you'll have to use the following syntax:
mysql_connect("localhost","root","");
If you want to set a password for MySQL access, please use of mysqladmin.
To set the passwort "secret" for the user "root", type the following:
C:\xampp\mysql\bin\mysqladmin -u root password secret

After changing the password you'll have to reconfigure PHPMyAdmin to use the
new password, otherwise it won't be able to access the databases. To do that,
open the file config.inc.php in \xampp\phpmyadmin\ and edit the
following lines:

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['auth_type'] = 'http'; // HTTP authentificate

So first the 'root' password is queried by the MySQL server, before PHPMyAdmin
may access.

---------------------------------------------------------------
Have a lot of fun! Viel Spaß! Bonne Chance!
Last revised version 08.12.2004 Kay Vogelgesang

Quote:

Hello Peccavi
(Thanks for sending me the above personal note Since it might be, that other newbees than me could benefit from this exchange, I am taking it back to the forum. Hope this is fine with you.)

I did now manage to install xampp, and get the right connection between XOOPS and mysql. The default 31 tables are created. Clue was - as you suggested - to install apache and MySQL as service. Thanks alot!! first apache, then reboot, then mysql, reboot.

BUT: when leaving the autoinstall of XOOPS, (and while everything sofar ran fine) I get the following message: "Parse error, unexpected T_CLONE especting T-STRINGC:\....\xampp\htdocs\xoops\kernel\object.php line 528"
What could this be???

Best spirits from Berlin: by the way, due to X-mas I will be off-line.. maybe even untill Jan 2, so: Happy New Year (hmm, you are in China, right?? NewYear in March, I heard.. Anyway, cheers and good luck with your solutions!!

Quote:Xoops 2.0.7.3 is not compatible with PHP 5
Either turn XAMPP into using PHP 4 (there should be a PHP version changer included in XAMPP - there is in my version of it) or use Xoops 2.0.9 beta (it's just a beta, but quite a number of sites use it without problems)

Thanks, I searched the topic on the forum and realized my mistake. I did the 1-click change to php 4 in XAMPP, returned to the index, but then got the "infamous" error

Error(XOOPS): Unable to connect to database in file C:\apachefriends\wampp\htdocs\xoops\class\database\databasefactory.php line 34

(I have seen people on this forum stumble over the message, I did however, not find the clue. )