Discussion:
[Citrusdb-users] New Install
Rakesh Kotha
2012-09-11 16:22:49 UTC
Permalink
Am installing CitrusDB on Windows XP with WAMP Server 2.2

I got Apache, MQSQL, PhpMyAdmin worked.

Now stared configuring CitrusDB.
Copied the bineried to WWW folder in WAMP.
When i tried http://localhost/citrus am getting below error:

Fatal error: Call to a member function RowCount() on a non-object in
C:\wamp\www\citrus\include\database.inc.php on line 58

below is the line 58 in the file:
$attempts = $result->RowCount();

I haven't changed anything in this file but not sure why am getting this.

Am stuck and tried googling but NO luck.

Could someone help me configuring it.

Thanks in advance
bryan
2012-09-12 08:06:07 UTC
Permalink
Rakesh Kotha,

Could you clarify if you setup the Privileges for the citrus DB in
PhpMyAdmin?
Its the tab at the top. Once there check for the citrus DB user. If
it isn't there click on the "Add a new User" below the table.

That username and password need to be set in the citrus configuration
file.
C:\wamp\www\citrus\include\config.inc.php

But if you already did that then it may be another problem.
Because a nonobject usually means the link to the DB wasn't established
for some reason.

Bryan
Post by Rakesh Kotha
Am installing CitrusDB on Windows XP with WAMP Server 2.2
I got Apache, MQSQL, PhpMyAdmin worked.
Now stared configuring CitrusDB.
Copied the bineried to WWW folder in WAMP.
Fatal error: Call to a member function RowCount() on a non-object in
C:\wamp\www\citrus\include\database.inc.php on line 58
$attempts = $result->RowCount();
I haven't changed anything in this file but not sure why am getting this.
Am stuck and tried googling but NO luck.
Could someone help me configuring it.
Thanks in advance
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond.
Discussions
will include endpoint security, mobile security and the latest in
malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Rakesh
2012-09-12 08:38:16 UTC
Permalink
Thank you Bryan for quick reply.
I do setup the id and pass from phpmyadmin and mentioned it config file.

I tested the connectivity to db using those id and pass from command prompt and it worked well.

For some reason while i access phpmyadmin, it is not asking me any id or pass to logon. Not sure if that is an issue.

Please let me know if you want any other details.

Thanks again

Sent from my iPod
Post by bryan
Rakesh Kotha,
Could you clarify if you setup the Privileges for the citrus DB in
PhpMyAdmin?
Its the tab at the top. Once there check for the citrus DB user. If
it isn't there click on the "Add a new User" below the table.
That username and password need to be set in the citrus configuration
file.
C:\wamp\www\citrus\include\config.inc.php
But if you already did that then it may be another problem.
Because a nonobject usually means the link to the DB wasn't established
for some reason.
Bryan
Post by Rakesh Kotha
Am installing CitrusDB on Windows XP with WAMP Server 2.2
I got Apache, MQSQL, PhpMyAdmin worked.
Now stared configuring CitrusDB.
Copied the bineried to WWW folder in WAMP.
Fatal error: Call to a member function RowCount() on a non-object in
C:\wamp\www\citrus\include\database.inc.php on line 58
$attempts = $result->RowCount();
I haven't changed anything in this file but not sure why am getting this.
Am stuck and tried googling but NO luck.
Could someone help me configuring it.
Thanks in advance
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond.
Discussions
will include endpoint security, mobile security and the latest in
malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
bryan
2012-09-12 09:08:53 UTC
Permalink
Rakesh Kotha,

By default PhpMyAdmin doesn't ask for the username or password to log
into it.
Since it is localhost that doesn't really matter.

Click on the citrus DB listed on the left in the DB list column. To
make sure you are using the citrus one and not mysql.
Then check the Privileges tab on the right.

If there is no citrus user here then click on the "Add a new User".
User name: citrus
Host: localhost
Password:
Retype:

The option to "Grant all privileges on database 'citrus'" should
already be selected for you (if not, select it).
(If it doesn't say citrus there then you're in the wrong database
privileges).

Sorry to be so picky about the details but computers are picky too :-)
Post by Rakesh
Thank you Bryan for quick reply.
I do setup the id and pass from phpmyadmin and mentioned it config file.
I tested the connectivity to db using those id and pass from command
prompt and it worked well.
For some reason while i access phpmyadmin, it is not asking me any id
or pass to logon. Not sure if that is an issue.
Please let me know if you want any other details.
Thanks again
Sent from my iPod
Post by bryan
Rakesh Kotha,
Could you clarify if you setup the Privileges for the citrus DB in
PhpMyAdmin?
Its the tab at the top. Once there check for the citrus DB user.
If
it isn't there click on the "Add a new User" below the table.
That username and password need to be set in the citrus
configuration
file.
C:\wamp\www\citrus\include\config.inc.php
But if you already did that then it may be another problem.
Because a nonobject usually means the link to the DB wasn't
established
for some reason.
Bryan
Post by Rakesh Kotha
Am installing CitrusDB on Windows XP with WAMP Server 2.2
I got Apache, MQSQL, PhpMyAdmin worked.
Now stared configuring CitrusDB.
Copied the bineried to WWW folder in WAMP.
Fatal error: Call to a member function RowCount() on a non-object in
C:\wamp\www\citrus\include\database.inc.php on line 58
$attempts = $result->RowCount();
I haven't changed anything in this file but not sure why am getting this.
Am stuck and tried googling but NO luck.
Could someone help me configuring it.
Thanks in advance
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond.
Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond.
Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Rakesh Kotha
2012-09-12 13:44:48 UTC
Permalink
Hi Bryan,

I have all of them in place: Below is copy from phpmyadmin

Users having access to "citrus"
User Host Type Privileges
Grant Action
citrus localhost database-specific ALL PRIVILEGES No Edit Privileges

Below is my config file:
$sys_dbhost = 'localhost';
$sys_dbuser = 'citrus';
$sys_dbpasswd = 'citrus';
$sys_dbname = 'citrus';

Below one shows user "citrus" have access to mysql server.

C:\wamp\bin\mysql\mysql5.5.24\bin>mysql -u citrus -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49
Server version: 5.5.24-log MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Still getting the same error. Please let me know what else i need to check at.
Fatal error: Call to a member function RowCount() on a non-object in
C:\wamp\www\citrus\include\database.inc.php on line 58

Thank you
Post by bryan
Rakesh Kotha,
By default PhpMyAdmin doesn't ask for the username or password to log
into it.
Since it is localhost that doesn't really matter.
Click on the citrus DB listed on the left in the DB list column. To
make sure you are using the citrus one and not mysql.
Then check the Privileges tab on the right.
If there is no citrus user here then click on the "Add a new User".
User name: citrus
Host: localhost
The option to "Grant all privileges on database 'citrus'" should
already be selected for you (if not, select it).
(If it doesn't say citrus there then you're in the wrong database
privileges).
Sorry to be so picky about the details but computers are picky too :-)
Post by Rakesh
Thank you Bryan for quick reply.
I do setup the id and pass from phpmyadmin and mentioned it config file.
I tested the connectivity to db using those id and pass from command
prompt and it worked well.
For some reason while i access phpmyadmin, it is not asking me any id
or pass to logon. Not sure if that is an issue.
Please let me know if you want any other details.
Thanks again
Sent from my iPod
Post by bryan
Rakesh Kotha,
Could you clarify if you setup the Privileges for the citrus DB in
PhpMyAdmin?
Its the tab at the top. Once there check for the citrus DB user.
If
it isn't there click on the "Add a new User" below the table.
That username and password need to be set in the citrus
configuration
file.
C:\wamp\www\citrus\include\config.inc.php
But if you already did that then it may be another problem.
Because a nonobject usually means the link to the DB wasn't
established
for some reason.
Bryan
Post by Rakesh Kotha
Am installing CitrusDB on Windows XP with WAMP Server 2.2
I got Apache, MQSQL, PhpMyAdmin worked.
Now stared configuring CitrusDB.
Copied the bineried to WWW folder in WAMP.
Fatal error: Call to a member function RowCount() on a non-object in
C:\wamp\www\citrus\include\database.inc.php on line 58
$attempts = $result->RowCount();
I haven't changed anything in this file but not sure why am getting this.
Am stuck and tried googling but NO luck.
Could someone help me configuring it.
Thanks in advance
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond.
Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Paul Yasi
2012-09-12 14:31:56 UTC
Permalink
I'm guessing you may not have the default database from the citrus.sql
file - this needs to be imported into your empty citrus database, you
can do that with phpmyadmin or on the mysql cmd line.

Paul
Post by Rakesh Kotha
Am installing CitrusDB on Windows XP with WAMP Server 2.2
I got Apache, MQSQL, PhpMyAdmin worked.
Now stared configuring CitrusDB.
Copied the bineried to WWW folder in WAMP.
Fatal error: Call to a member function RowCount() on a non-object in
C:\wamp\www\citrus\include\database.inc.php on line 58
$attempts = $result->RowCount();
I haven't changed anything in this file but not sure why am getting this.
Am stuck and tried googling but NO luck.
Could someone help me configuring it.
Thanks in advance
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
Rakesh Kotha
2012-09-12 15:28:51 UTC
Permalink
Hi Paul,

You made my day!!

Am not getting that error after importing the citrus.sql file.
Surprisingly i don't see that step in the installation document.

I have this in my config file:
$url_prefix = "http://localhost/citrus";
$ssl_url_prefix = "https://localhost/citrus";

after giving user "admin", pass "test", am getting "page can't be
displayed" error.
below is the url am getting redirected to after entering the id and pass;

https://localhost/citrus/index.php

Anything else am i missing?

Do i need to delete the lines after "$ssl_url_prefix =
"https://localhost/citrus";" if i don't want to use any encryption or
so, Firstly i want to bring up the basic Citrus application, later i
can think of adding more security.

Thank you in advance.
Post by Paul Yasi
I'm guessing you may not have the default database from the citrus.sql
file - this needs to be imported into your empty citrus database, you
can do that with phpmyadmin or on the mysql cmd line.
Paul
Post by Rakesh Kotha
Am installing CitrusDB on Windows XP with WAMP Server 2.2
I got Apache, MQSQL, PhpMyAdmin worked.
Now stared configuring CitrusDB.
Copied the bineried to WWW folder in WAMP.
Fatal error: Call to a member function RowCount() on a non-object in
C:\wamp\www\citrus\include\database.inc.php on line 58
$attempts = $result->RowCount();
I haven't changed anything in this file but not sure why am getting this.
Am stuck and tried googling but NO luck.
Could someone help me configuring it.
Thanks in advance
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Continue reading on narkive:
Loading...