Smartcoin Linux mining administration. [MULTI-MACHINE SUPPORT NOW IN!]

[dishwara]

Dump again. I did as you said, added miner in 6, even though their is phoenix.
still in main screen nothing is mining.
I already removed & reinstalled smartcoin & also created one worker as you said.
no mining is happening.

Code:

-- MySQL dump 10.13  Distrib 5.1.54, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: smartcoin
-- ------------------------------------------------------
-- Server version	5.1.54-1ubuntu4

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `current_profile`
--

DROP TABLE IF EXISTS `current_profile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `current_profile` (
  `fk_machine` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  UNIQUE KEY `fk_machine` (`fk_machine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `current_profile`
--

LOCK TABLES `current_profile` WRITE;
/*!40000 ALTER TABLE `current_profile` DISABLE KEYS */;
INSERT INTO `current_profile` VALUES (1,-1);
/*!40000 ALTER TABLE `current_profile` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device`
--

DROP TABLE IF EXISTS `device`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device` (
  `pk_device` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `device` int(11) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_device`),
  UNIQUE KEY `fk_machine_2` (`fk_machine`,`device`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device`
--

LOCK TABLES `device` WRITE;
/*!40000 ALTER TABLE `device` DISABLE KEYS */;
/*!40000 ALTER TABLE `device` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `machine`
--

DROP TABLE IF EXISTS `machine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `machine` (
  `pk_machine` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `server` varchar(100) DEFAULT NULL,
  `ssh_port` int(11) DEFAULT NULL,
  `username` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_machine`),
  UNIQUE KEY `name` (`name`,`server`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `machine`
--

LOCK TABLES `machine` WRITE;
/*!40000 ALTER TABLE `machine` DISABLE KEYS */;
INSERT INTO `machine` VALUES (1,'localhost','127.0.0.1',22,'dishwara00',1,0);
/*!40000 ALTER TABLE `machine` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `macro`
--

DROP TABLE IF EXISTS `macro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macro` (
  `pk_macro` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_macro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `macro`
--

LOCK TABLES `macro` WRITE;
/*!40000 ALTER TABLE `macro` DISABLE KEYS */;
/*!40000 ALTER TABLE `macro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `macro_map`
--

DROP TABLE IF EXISTS `macro_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macro_map` (
  `pk_macro_map` int(11) NOT NULL AUTO_INCREMENT,
  `fk_macro` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  `fk_machine` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk_macro_map`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `macro_map`
--

LOCK TABLES `macro_map` WRITE;
/*!40000 ALTER TABLE `macro_map` DISABLE KEYS */;
/*!40000 ALTER TABLE `macro_map` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `miner`
--

DROP TABLE IF EXISTS `miner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `miner` (
  `pk_miner` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `launch` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `default_miner` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_miner`),
  UNIQUE KEY `fk_machine` (`fk_machine`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `miner`
--

LOCK TABLES `miner` WRITE;
/*!40000 ALTER TABLE `miner` DISABLE KEYS */;
INSERT INTO `miner` VALUES (1,1,'phoenix','phoenix.py -v -u http://arawhsid.0:dish1979@api.bitcoin.cz:8332/ -k phatk device=0workze=256 vectors aggression=12 bfi_int','/home/dishwara00/Downloads/phoenix-1.48/phoenix.pyn/home/dishwara00/desktop/phoenix-1.48/phoenix.pyn/home/dishwara00/desktop/phoenix-1.50/phoenix.pyn/home/dishwara00/phoenix/phoenix.pyn/home/dishwara00/phoenix/trunk/',1,0);
/*!40000 ALTER TABLE `miner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pool`
--

DROP TABLE IF EXISTS `pool`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool` (
  `pk_pool` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `server` varchar(32) DEFAULT NULL,
  `alternateServer` varchar(32) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `timeout` int(11) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_pool`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pool`
--

LOCK TABLES `pool` WRITE;
/*!40000 ALTER TABLE `pool` DISABLE KEYS */;
INSERT INTO `pool` VALUES (1,'DeepBit','deepbit.net',NULL,8332,60,1,0),(2,'Bitcoin.cz (slush)','mining.bitcoin.cz',NULL,8332,60,1,0),(3,'BTCGuild','btcguild.com',NULL,8332,60,1,0),(4,'BTCMine','btcmine.com',NULL,8332,60,1,0),(5,'Bitcoins.lc','bitcoins.lc',NULL,8080,60,1,0),(6,'SwePool','swepool.net',NULL,8337,60,1,0),(7,'Continuum','continuumpool.com',NULL,8332,60,1,0),(8,'MineCo','mineco.in',NULL,3000,60,1,0),(9,'Eligius','mining.eligius.st',NULL,8337,60,1,0),(10,'CoinMiner','173.0.52.116',NULL,8347,60,1,0),(11,'ZABitcoin','mine.zabitcoin.co.za',NULL,8332,60,1,0),(12,'BitClockers','pool.bitclockers.com',NULL,8332,60,1,0),(13,'MtRed','mtred.com',NULL,8337,60,1,0),(14,'SimpleCoin','simplecoin.us',NULL,8337,60,1,0),(15,'Ozco','ozco.in',NULL,8332,60,1,0),(16,'EclipseMC','us.eclipsemc.com',NULL,8332,60,1,0),(17,'BitP','pool.bitp.it',NULL,8334,60,1,0),(18,'BitcoinPool','bitcoinpool.com',NULL,8334,60,1,0),(19,'EcoCoin','ecocoin.org',NULL,8332,60,1,0),(20,'BitLottoPool','bitcoinpool.com',NULL,8337,60,1,0),(21,'X8S','pit.x8s.de',NULL,8337,60,1,0);
/*!40000 ALTER TABLE `pool` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profile`
--

DROP TABLE IF EXISTS `profile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile` (
  `pk_profile` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_profile`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile`
--

LOCK TABLES `profile` WRITE;
/*!40000 ALTER TABLE `profile` DISABLE KEYS */;
/*!40000 ALTER TABLE `profile` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profile_map`
--

DROP TABLE IF EXISTS `profile_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile_map` (
  `pk_profile_map` int(11) NOT NULL AUTO_INCREMENT,
  `fk_device` int(11) DEFAULT NULL,
  `fk_miner` int(11) DEFAULT NULL,
  `fk_worker` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk_profile_map`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile_map`
--

LOCK TABLES `profile_map` WRITE;
/*!40000 ALTER TABLE `profile_map` DISABLE KEYS */;
/*!40000 ALTER TABLE `profile_map` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `pk_settings` int(11) NOT NULL AUTO_INCREMENT,
  `data` varchar(32) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pk_settings`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'donation_time','5','Hashpower donation minutes per day'),(2,'donation_start','1936','Time to start hashpower donation each day');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-06-26 11:56:04

[1714130140]

1714130140

[gyzer]

When I go ahead and install I get an error at the point where it looks like the installer is trying to give permissions to the mysql database user smartcoin but it cannot. Afterwards it looks like it does load the schema, but it never creates the tables.

Any idea on what could cause that to happen?

[burp]

Why not use sqlite? It seems much more appropriate for this project.

[jondecker76]

hipaulshi:

line 940 of  smartcoin_control.sh

Hmm, not sure or how that line got in there - maybe a rogue copy/paste or something.

I removed the offending line, you should svn update to bring the change in locally

[jondecker76]

dishwara:
Looking at your database dump, I see 2 problems:
1) The entry for the miner is incorrect.  It needs to have the special <#user#>,<#pass#> etc tags where your real information would normally go.  These values are filled in by smartcoin depending on the pool/worker that is being processed. Also, it looks like you have 3 different phoenix installs, which confuses the installer.  You will want to manually edit the path as well, to the one you want to use.

2)  You device table is empty - got to configure devices and add them in. You can name them what you want, but by default they would have been named GPU[0].... etc

[jondecker76]

burb:

Why not use sqlite? It seems much more appropriate for this project.

I may have to consider it.. While I've been maintaining and working  MySQL servers for a very long time,  i guess I shouldn't assume that users will be as familiar with it - and in fact I'm sure a lot of failed installations will be related to the server not being set up correctly at install (not remembering the password set, etc)

[jondecker76]

gyzer:

When I go ahead and install I get an error at the point where it looks like the installer is trying to give permissions to the mysql database user smartcoin but it cannot. Afterwards it looks like it does load the schema, but it never creates the tables.

Any idea on what could cause that to happen?

Sounds like a mysql password issue (did you use the same password you set up mysql with?)
What exactly is the error?

[jondecker76]

I've been doing some test this morning,  and as suggested, I'm going to add sqLite support.  This will make it easier to install for those that haven't used MySQL before!

I estimate a couple of hours, and i'll have the changes checked in. I'll update here once its done!

[gyzer]

Can you include full directions on how to fully remove mysql when you get sqllite support?

[Clipse]

Can you include full directions on how to fully remove mysql when you get sqllite support?

apt-get --purge remove sqlite

[gyzer]

Damn, I was missing the purge flag...THANKS!

[ptshamrock]

You also need to make sure that your $LD_LIBRARY_PATH for the ATI sdk is set in the environment



how can i acess this ?

[gyzer]

You also need to make sure that your $LD_LIBRARY_PATH for the ATI sdk is set in the environment



how can i acess this ?

I know what it is, but not where it is...

I hadn't gotten far enough to see if that was going to be a problem for me or not.

[jondecker76]

Ok, the new beta is up, now using sqLite3
People using the old beta, you should completely uninstall and do it fresh:

Code:

cd ~/
sudo rm -r smartcoin
sudo apt-get --purge remove mysql-server mysql-client

Here are the new install instructions:

Code:

cd ~/
mkdir smartcoin
cd smartcoin
svn checkout http://smartcoin.googlecode.com/svn/branches/beta1/smartcoin ./
./smartcoin_install.sh

For those having $LD_LIBRARY_PATH problems, enter this at the terminal before running smartcoin:

Code:

export $LD_LIBRARY_PATH="/home/your_username_here/AMD-APP-SDK-v2.4-lnx32/lib/x86/:$LD_LIBRARY_PATH"

(You must have your own correct path entered above, of course.  Please check the location on your own machine before adding it to $LD_Library_Path

I will likely add some detection in the installer, store the path in the database, and update LD_LIBRARY_PATH in code eventually.



KNOWN ISSUES:
All of my old queries that used CONCAT are no longer suppored in sqlite3
I have to go over all of them and change them to a syntax that sqlite likes. So if you get errors about CONCAT, thats why.
I'll fix them later tonight, I have a graduation party to go to now. EDIT: FIXED!

[gyzer]

I'm having problems with your export command. What file does that need to be changed in?

[gyzer]

Ok so I already have the LD_LIBRARY_PATH set and when I go to install it says that it isn't. I'm using a 64bit version of Ubuntu 10.04 and I'm using sdk 2.1 not 2.4. My phoenix miners work so my LD_LIBRARY_PATH in .bashrc is correct.

What am I doing wrong here?

[jondecker76]

sorry, i made a type:
it should be:

Code:

export LD_LIBRARY_PATH="/home/your_username_here/AMD-APP-SDK-v2.4-lnx32/lib/x86/:$LD_LIBRARY_PATH"

Also, its a common misconception that you already have LD_LIBRARY path set because your miners work.  Its difficult to explain, but it can still work if launched manually from the right directory. However, it doesn't work the same if being launched from another program or subshell, as they have there own idea of what the current directory is

[malavita]

sorry, i made a type:
it should be:

Code:

export LD_LIBRARY_PATH="/home/your_username_here/AMD-APP-SDK-v2.4-lnx32/lib/x86/:$LD_LIBRARY_PATH"

Also, its a common misconception that you already have LD_LIBRARY path set because your miners work.  Its difficult to explain, but it can still work if launched manually from the right directory. However, it doesn't work the same if being launched from another program or subshell, as they have there own idea of what the current directory is

What about 64bits on Ubuntu 11.04 - just change the path accordingly?

Thx!

[Clipse]

This will work for 64bit:

Code:

export LD_LIBRARY_PATH="/home/your_username_here/AMD-APP-SDK-v2.4-lnx64/lib/x86_64/:$LD_LIBRARY_PATH"

[gyzer]

I ran the corrected export command and it worked. But still when I go to run the smartcoin_install.sh I get the following error:

Code:

It appears that the AMD APP SDK is not in your LD_LIBRARY_PATH
This is required for smartcoin to work properly!
Please add the AMD APP SDK path to LD_LIBRARY_PATH and try again.

Now is this looking specifically for the AMD APP SDK 2.4? Because I'm using the ati app sdk 2.1. Is this a problem?