The php pages aren't showing any worker stats
sounds like the workers.php cronjob isn't running.
Nah, it's like the database for pushpool can't see the database for simplecoin and vice versa
Ah, pushpool & simplecoin should be using the same database.
they are, i called it sc and a user called pushpool was granted all permissions on it. Both simplecoin and pushpool use 'pushpool'@'localhost' as the database login, and i know pushpool can see the database because it allows my worker to login via -u genewitch.1 --pass=x.
what actually has the accounting, pushpool? Maybe i can dig through your PHP to see where the accounting database calls are and try the queries in a mysql prompt to see if there are the correct values in there. If you need any of my json or config files i can provide them.
Thanks for helping me, by the way. I'm setting this up for #xkcd on foonetic. :-)
mysql> show tables;
+----------------+
| Tables_in_sc |
+----------------+
| accountBalance |
| networkBlocks |
| pool_worker |
| settings |
| shares |
| shares_history |
| webUsers |
+----------------+
7 rows in set (0.00 sec)
mysql> select * from sc.accountBalance;
+----+--------+---------+------------------------------------+------+-----------+
| id | userId | balance | sendAddress | paid | threshold |
+----+--------+---------+------------------------------------+------+-----------+
| 1 | 1 | 0 | 1CfUcB7yKKWpco3BPjzHjveyrR1rBmvmEp | 0 | 0 |
+----+--------+---------+------------------------------------+------+-----------+
1 row in set (0.00 sec)
mysql> select * from sc.shares;
Empty set (0.00 sec)
mysql> select * from sc.shares_history;
Empty set (0.00 sec)
Edit: hey, am i supposed to add anything to pushpool to take care of accounting? like add sql commands somewhere or something? Or does simplecoin use logs to determine shares and activity and set the mysql stuff itself? I know all the frontend (for payments) is NOT handled by pushpool stock install, so maybe i missed a step where i move a config file from simplecoin to somewhere else.
I did run mysql sc