Calem Community Forum
General => Setup => Topic started by: fortune on July 13, 2007, 02:15:00 am
-
I installed CalemEAM. And all my install step went perfect. When I try to login to CalemEAM using admin/admin,
I get those error:
1. after input admin/admin:
Get following error message:
Warning: require_once(SOAP/Base.php) [function.require-once]: failed to open stream: No such file or directory in D:\wamp\www\CalemEAM\server\include\core\CalemSoapRequest.php on line 31
Fatal error: require_once() [function.require]: Failed opening required 'SOAP/Base.php' (include_path='.;D:\wamp\php\pear') in D:\wamp\www\CalemEAM\server\include\core\CalemSoapRequest.php on line 31
2. And I went to http://pear.php.net to down SOAP-0.11.0.tgz package,
after download this , unzip and rename it as SOAP ,put it to WAMP/PHP/PEAR/
re-login,get following error message:
Warning: require_once(XML/Serializer.php) [function.require-once]: failed to open stream: No such file or directory in D:\wamp\www\CalemEAM\server\include\core\CalemSoapRequest.php on line 32
Fatal error: require_once() [function.require]: Failed opening required 'XML/Serializer.php' (include_path='.;D:\wamp\php\pear') in D:\wamp\www\CalemEAM\server\include\core\CalemSoapRequest.php on line 32
3. And I went to http://pear.php.net to down XML_Serializer-0.18.0.tgz package,
after download this , unzip and rename it as XML ,put it to WAMP/PHP/PEAR/
re-login,get following error message:
Warning: require_once(XML/Util.php) [function.require-once]: failed to open stream: No such file or directory in D:\wamp\php\PEAR\XML\Serializer.php on line 35
Fatal error: require_once() [function.require]: Failed opening required 'XML/Util.php' (include_path='.;D:\wamp\php\pear') in D:\wamp\php\PEAR\XML\Serializer.php on line 35
4. So, I went to http://pear.php.net to down XML_Util-1.1.4.tgz package,
after download this , unzip it and copy all of file to WAMP/PHP/PEAR/XML
re-login,get following error message but mention that ERROR username or password.
5. I login mysql and use calemeam database,then update admin user password as 'admin'
and re-login.but still mention me error username or password.
Why??
How can I do??
-
I have solved this problem.
It is password error.after I change admin's password ,I can login it.
Following is step by step :
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| calemeam |
| mysql |
| phpmyadmin |
| test |
+--------------------+
5 rows in set (0.14 sec)
mysql> use calemeam
Database changed
mysql> show tables;
..............
mysql> select * from users;
................
mysql> update users set password=md5('admin') where username='admin';
Query OK, 1 row affected (0.13 sec)
Rows matched: 1 Changed: 1 Warnings: 0
-
Instalation went good, but I cannot login. I use ubuntu-server and I installed all SOAP and XML through apt-get. When I try to login I simply get:
"Login failed. Please check your user name/password and try again."
my log file shows:
2007-08-08 19:31:05,697 DEBUG main - sid=; Post data=username=admin&password=admin&calemAction=LoginAction
2007-08-08 19:31:05,697 INFO MysqlHandler - calem db connection: user=calemeam, password=***, , connection=mysql:host=localh
2007-08-08 19:31:05,697 DEBUG CalemDbo - fetchBySqlParam: select * from users where username=?, param='admin'
2007-08-08 19:31:05,697 DEBUG CalemPDOStatement - Query time:0.001, the query=select * from users where username=?, params=ar
1 => 'admin',
)
2007-08-08 19:31:06,697 INFO main - Received request to launch: client/launchpad/CalemLoginLite.php
-
Default login is:
admin/admin_password
Note: password for admin is 'admin_password'.
-
I've installed the system on Linux and i'm trying to log with 'admin' and 'admin_password' but i can't.
Any help?
-
Take a look at logs. It might tell what were wrong.
- php error logs
- calem logs (under CalemEAM/logs/calem.log)
-
I have no errors logs in de php logs.
Then, there's no file under CalemEAM/logs/ (the directory is empty).
I did a "updatedb && locate calem.log" with no result.
thanks.
-
Check out CalemEAM/etc/log4php.properties, does this file exist?
It's generated by CalemEAM/bin/setup.sh
-
CalemEAM/etc/log4php.properties EXISTS
-
Ok, let's check the access log and Apache error log, see if there's any clue.
By the way, what's the linux os? When you login with admin/admin_password, what's showing on the browser? Any error msg?
-
access_log:
10.0.8.9 - - [12/Sep/2007:14:39:35 -0300] "GET /CalemEAM HTTP/1.1" 301 402
10.0.8.9 - - [12/Sep/2007:14:39:35 -0300] "GET /CalemEAM/ HTTP/1.1" 200 7178
10.0.8.9 - - [12/Sep/2007:14:39:35 -0300] "GET /CalemEAM/client/themes/favicon.ico HTTP/1.1" 200 1150
10.0.8.9 - - [12/Sep/2007:14:39:35 -0300] "GET /CalemEAM/client/themes/image/hiRes/dwtimgs.css HTTP/1.1" 200 35247
10.0.8.9 - - [12/Sep/2007:14:39:35 -0300] "GET /CalemEAM/client/themes/login.css HTTP/1.1" 200 1749
10.0.8.9 - - [12/Sep/2007:14:39:36 -0300] "GET /CalemEAM/client/themes/image/hiRes/dwt/Critical_32.gif HTTP/1.1" 200 1458
10.0.8.9 - - [12/Sep/2007:14:39:36 -0300] "GET /CalemEAM/client/themes/calemeam.png HTTP/1.1" 200 2905
10.0.8.9 - - [12/Sep/2007:14:39:48 -0300] "POST /CalemEAM/index.php HTTP/1.1" 200 7263
error_log:
[Wed Sep 12 11:55:54 2007] [notice] caught SIGTERM, shutting down
[Wed Sep 12 11:56:04 2007] [notice] suEXEC mechanism enabled (wrapper: /opt/lampp/bin/suexec)
[Wed Sep 12 11:56:04 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Wed Sep 12 11:56:04 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Wed Sep 12 11:56:05 2007] [notice] Digest: generating secret for digest authentication ...
[Wed Sep 12 11:56:05 2007] [notice] Digest: done
[Wed Sep 12 11:56:06 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Wed Sep 12 11:56:06 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Wed Sep 12 11:56:06 2007] [notice] Apache/2.2.4 (Unix) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e PHP/5.2.3 mod_apreq2-20051231/2.5.7 mod_perl/2.0.2 Perl/v5.8.7 configured -- resuming normal operations
Message from system, nothing from browser.
Login failed. Please check your user name/password and try again.
Thanks for your time.
-
I've forgot de os, I'm using ubuntu 7.04.
-
It seems the app is running. open CalemEAM/etc/log4php.properties, what's the property's value: log4php.appender.F1.File?
The log file might be in an odd place.
-
_CALEM_LOG_PATH_
-
Go to CalemEAM/bin, run setup.bat (or setup.sh),
which should replace the constant with a file name. Make sure this is the case after running the setup.sh (in linux case). Then, do another login, the log file should be generated.
-
The constant was replaced: "log4php.appender.F1.File=/opt/lampp/htdocs/CalemEAM/logs/calem.log"
Then I tried to log in but I couldn't. The calem.log wasn't generated.
After that I did a "locate calem.log" with no result.
What I'm doing wrong???
-
Login error indicates that data loading may not be successful. But it's going to be difficult without logging working. You may check apache/php error logs again. Maybe file access rights prevented log file being created.
Also, try to set up database again. Follow the setup guide's "5. Database setup".
-
Finally, I've got my calem.log, however I can't get in and I paste you the log report from calem.log.
2007-09-13 11:39:11,611 DEBUG main - sid=; Post data=username=admin&password=admin_password&calemAction=LoginAction
2007-09-13 11:39:11,611 INFO MysqlHandler - calem db connection: user=calemeam, password=***, , connection=mysql:host=10.0.8.9;dbname=calemeam, persistent connection=Array
2007-09-13 11:39:11,611 ERROR main - Exception in processing login. Error msg=#0 /opt/lampp/htdocs/CalemEAM/server/include/core/database/CalemPdo.php(53): PDO->__construct('mysql:host=10.0...', 'calemeam', 'calemeam', Array)
#1 /opt/lampp/htdocs/CalemEAM/server/include/core/database/mysql/MysqlHandler.php(148): CalemPdo->__construct('mysql:host=10.0...', 'calemeam', 'calemeam', Array)
#2 /opt/lampp/htdocs/CalemEAM/server/include/core/database/CalemDbo.php(75): MysqlHandler->getCalemConnection()
#3 /opt/lampp/htdocs/CalemEAM/server/include/core/CalemFactory.php(133): CalemDbo->__construct()
#4 /opt/lampp/htdocs/CalemEAM/server/include/core/CalemFactory.php(98): CalemFactory::createInstance(Array)
#5 /opt/lampp/htdocs/CalemEAM/server/modules/admin/CalemUserDbo.php(48): CalemFactory::getDbo('users')
#6 /opt/lampp/htdocs/CalemEAM/server/modules/admin/CalemSecurityBo.php(62): CalemUserDbo::findByUsername('admin')
#7 /opt/lampp/htdocs/CalemEAM/server/modules/admin/soap/CalemLoginSo.php(68): CalemSecurityBo->verifyLogin('admin', 'admin_password')
#8 /opt/lampp/htdocs/CalemEAM/index.php(56): CalemLoginSo::doLogin('admin', 'admin_password')
#9 {main}
Thanks again for your time.
-
The logs look like a pdo issue, see the following thread.
http://www.calemeam.com/apps/phpbb/viewtopic.php?t=171
-
It seems that I have the same problem, but I just write down "extension=php_pdo.so" and "..._mysql.so" in my php.ini to enable them??
-
Correct! (see http://www.calemeam.com/support_setup.html section 2.)
-
I wrote down this in my php.ini:
extension="php_pdo.so"
extension="php_pdo_mysql.so"
and I restarted xampp
when start it says that can't load dynamic library
Stopping XAMPP for Linux 1.6.3b...
XAMPP: Stopping Apache with SSL...
PHP Warning: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/php_pdo.so' - /opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/php_pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/php_pdo_mysql.so' - /opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/php_pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
XAMPP: Stopping MySQL...
XAMPP: Stopping ProFTPD...
XAMPP stopped.
Starting XAMPP for Linux 1.6.3b...
PHP Warning: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/php_pdo.so' - /opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/php_pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/php_pdo_mysql.so' - /opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/php_pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
I look for that files with no result.
-
Checked my XAMPP for Linux 1.6.1 on Fedora 6. I didn't have the extensions enabled for pdo.so and pdo_mysql.so either. XAMPP has PDO included in it. So you may remove the two extensions. But I don't why PDO is not picked up in your installation.
-
You may ask the author of this article why go through the trouble installing each item individually including PDO and PDO for mySQL, instead of XAMPP 1.6.3. Maybe he knows some about PDO on XAMPP for Ubuntu.
http://www.theatons.com/blog/2007/07/01/ubuntu-install-php5-mysql-apache2-ssl-pdo-pdo_mysql/
-
Well, finally the system is working, congratulations for your work it's really a great one.
If you want and have it planed i can translate it to spanish, i need to do it for my work.
-
That's would be great if you can translate CalemEAM to Spanish. You may create a project for it so others may not duplicate the effort. See the instructions to add a language at http://www.calemeam.com/apps/wiki/index.php?title=CalemLanguagePack
Congratulations for getting CalemEAM to work in Ubuntu and thanks for the update. Do you mind sharing what you did to overcome the PDO issue?
-
I had problems with the pear installation, for instance i was executing pear and what i need to execute was "/opt/lampp/..pear ...", and the packages were installed in ohter place.
Thank you for your help and i get to work to translate it.