Login problems

[Pol]

hallo

I just installed the Freesms but can not login. It does not accept the login/passwd: freesms_user/freesms or freesms/freesms

Do you have an hints?

Thanks
Polat

[Shaffin Bhanji]

Can you verify that you can login into the database using MySQL Administrator or any other tool? If so, than you have make sure that the credentials are reflected into the configuration file. I have noticed that some setting in MySQL may prevent using a zero character password, you need to set one. It is also recommended to set a password for the root user.

Shaffin.

[Shaffin Bhanji]

When you created the database (using the install scipt) did you specify the userid and password for the default administrator user?? If not then I would recommend you to run the scipt again else send me the error information!

Shaffin.

[bbevel]

I cannot find where or when it asks for this information. Can you specify?

[Shaffin Bhanji]

Try using the following:

Username: shaffin_bhanji@yahoo.ca
Password: shaffin

This will log you in as administrator, hope that helps.

Shaffin.

[bbevel]

Okay, I found that it's shaffin_bhanji@yahoo.ca in the crc_database_setup.sql, but now I'm getting this error when accessing the ADMINISTRATION area:
Warning: main(../../common/crc_menu.html): failed to open stream: No such file or directory in /var/www/html/freesms/pages/data/crc_admin_main.html on line 17

Warning: main(): Failed opening '../../common/crc_menu.html' for inclusion (include_path='.:/usr/share/pear') in /var/www/html/freesms/pages/data/crc_admin_main.html on line 17

[Shaffin Bhanji]

On line 17 of the crc_admin_main.html file, the include file is suppose to be "../common/crc_menu.html" and not "../../common/crc_menu.html"

[bbevel]

That did it! Thanks!

[Masud Hasan]

i cant login i have no database password, i have changeed

GRANT SELECT,INSERT,UPDATE,DELETE ON crcdb. TO 'user'@'localhost' IDENTIFIED BY '';
GRANT SELECT,INSERT,UPDATE,DELETE ON crcdb. TO 'user'@'%' IDENTIFIED BY '';

and

PDATE mysql.user SET Password = OLD_PASSWORD('') WHERE User = 'user';
FLUSH PRIVILEGES;

and
define('APP_PATH', '//');

define('MYSQL_SERVER', 'localhost');    
define('MYSQL_PORT', '3306');   
define('MYSQL_DB', 'crcdb');    
define('MYSQL_USER', 'user');   
define('MYSQL_PASS', '');

what is wrong i did pls help me

[Agent Anon]

see that u've matching username and password of the db in the config file

[Masud Hasan]

I cant solv my problem yet

[Masud Hasan]

No one can help me i cant login

Masud

[Masud Hasan]

I cant solv my problem yet

[Masud Hasan]

i m useing wamp and i have nothing changed for mysql database
i have changed

define('MYSQL_SERVER', 'localhost');    
define('MYSQL_PORT', '3306');   
define('MYSQL_DB', 'crcdb');    
define('MYSQL_USER', 'root');   
define('MYSQL_PASS', '');

and

GRANT SELECT,INSERT,UPDATE,DELETE ON crcdb. TO 'root'@'localhost' IDENTIFIED BY '';
GRANT SELECT,INSERT,UPDATE,DELETE ON crcdb. TO 'root'@'%' IDENTIFIED BY 'freesms';

We need to do this because the authentication

scheme has changes from MySQL 4.1+ with a newer

password hashing algorithm

UPDATE mysql.user SET Password = OLD_PASSWORD('freesms') WHERE User = 'root';
FLUSH PRIVILEGES;

[Masud Hasan]

i have no password for database and i have no changed user name or anything . i m useing wamp server

Pls help me

Masud

[Masud Hasan]

Pls help me i cant solve

masud

[Masud Hasan]

no can help me ?

Masud

[Masud Hasan]

GRANT SELECT,INSERT,UPDATE,DELETE ON crcdb. TO 'root'@'localhost' IDENTIFIED BY '';
GRANT SELECT,INSERT,UPDATE,DELETE ON crcdb. TO 'root'@'%' IDENTIFIED BY 'freesms';

We need to do this because the authentication

scheme has changes from MySQL 4.1+ with a newer

password hashing algorithm

UPDATE mysql.user SET Password = OLD_PASSWORD('') WHERE User = 'root';
FLUSH PRIVILEGES;

[Masud Hasan]

sorry
GRANT SELECT,INSERT,UPDATE,DELETE ON crcdb. TO 'root'@'localhost' IDENTIFIED BY '';
GRANT SELECT,INSERT,UPDATE,DELETE ON crcdb. TO 'root'@'%' IDENTIFIED BY '';

We need to do this because the authentication

scheme has changes from MySQL 4.1+ with a newer

password hashing algorithm

UPDATE mysql.user SET Password = OLD_PASSWORD('') WHERE User = 'root';

[Masud Hasan]

any one can help me

[Renan Birro]

I have a similar problem. I'm getting this error when accessing the
ADMINISTRATION area or any other area:

Fatal error: Cannot redeclare crc_profile::$m_roleid in
C:\XAMPP\htdocs\freesms\classes\crc_profile.cls.php on line 49

Renan

[Shaffin Bhanji]

Just comment out line 49 of the code in file crc_profile and you should be
fine.

shaffin.

[surmad umar]

But its still not working

and now after commenting

Deprecated: Function session_register() is deprecated in
D:\wamp\www\FreeSMS\pages\crc_login.php on line 9

[Shaffin Bhanji]

What version of PHP are you using?

[surmad umar]

PHp 5.3.0

apache 2.2.11

mysql 5.1.36