Execute the following query: alter table `events` add column `event_object` text NULL after `short_message`, add column `event_id` varchar(36) NULL after `event_object`;
Also, You could install the latest version (in which this bug and a few other were fixed) from SVN trunk: http://code.google.com/p/scalr/source/browse/#svn/trunk On Feb 18, 9:33 am, Bertand <[email protected]> wrote: > Thanks all for the help, > > it turns out to be a problem with libssh as supplied by the ubuntu > package, it is quite outdated version 0.18. Uninstall the ubuntu > package and the pecl package > > Download form libssh from source, compile, install. Then reinstall the > pecl package and it works. This is on karmic so likely affects > previous versions of ubuntu. Hope this helps you jason. > > I now have a new problem however, an SQL error > > Cannot store event in database: mysql error: [1054: Unknown column > 'event_object' in 'field list'] in EXECUTE("INSERT INTO events > SET ...... > > Any ideas? > > Bert > > On Feb 17, 10:22 am, "jasonjunkmail.misc" > > > > <[email protected]> wrote: > > Yes, I did. From 8.04 through 9.10. > > > Never figured out why either, and didn't have much too time to figure things > > out. > > > Now it could be one of two highly possible issues, either your php ssh2 > > library is faulty (known to be inconsistent for ubuntu) or rndc configs are > > bad. > > > If it's #1, try another OS. > > For #2 check:http://ubuntuforums.org/showthread.php?t=281393 > > > I moved from scalr to writing my own small custom application to handle my > > ec2/euca cloud scaling (for my specific type of application) because of the > > issue. Again, just didn't have the time to continue xdebugging and running > > ssh2 dev. > > > That and feel sometimes the support in this group can go through slow > > cycles, which was probably the case back then. > > > I still subscribe to these forums to help people out though. > > > Having said that hope this helps > > > On Wed, Feb 17, 2010 at 11:52 AM, Bertand <[email protected]> wrote: > > > Yes I am, Karmic > > > > Do you have the same issue > > > > On Feb 16, 1:36 pm, "Jasonjunkmail.misc" > > > <[email protected]> wrote: > > > > Running ubuntu by any chance? > > > > > -Jason > > > > > On Feb 16, 2010, at 12:59 PM, Bertand <[email protected]> wrote: > > > > > > Hi Nick, > > > > > > Thanks for the quick reply. > > > > > > SSH is configured properly, I tested it with the code attached below. > > > > > I also have a succesful ssh auth from scalr host in my log files on > > > > > the dns server. > > > > > Creating a zone works fine once logged in > > > > > It really does seem to hang on the rndcstatus() fucntion which should > > > > > not be problem based on the output of rndc status attached below. > > > > > > Bert > > > > > > On Feb 16, 1:02 am, Nickolas Toursky <[email protected]> wrote: > > > > >> Hi Bert, > > > > > >> If you look at the backtrace, you'll see Scalr cannot write zone data > > > > >> to bind configuration. > > > > > >> This could happen due to numerous reasons: no connect to port 22, > > > > >> wrong user password, wrong path to BIND config files or wrong > > > > >> permissions. Please check you are able to do this by hands (ssh into > > > > >> the server with user/pass configured, add zone definition to the > > > > >> named.conf, create zone file, execute 'rndc reload'). > > > > > >> Regards, > > > > >> Nick > > > > > >> On 16 February 2010 10:06, Bertand <[email protected]> wrote: > > > > > >>> Hi All, > > > > > >>> Working through the install of scalr. Everything works except that > > > > >>> on > > > > >>> creation of a new farm/app the following error comes up > > > > > >>> BIND is not running on 123.123.123.123 > > > > > >>> bind is most definetly running and answering queries > > > > >>> rndc status returns > > > > >>> version: 9.6.1-P2 > > > > >>> CPUs found: 4 > > > > >>> worker threads: 4 > > > > >>> number of zones: 15 > > > > >>> debug level: 0 > > > > >>> xfers running: 0 > > > > >>> xfers deferred: 0 > > > > >>> soa queries in progress: 0 > > > > >>> query logging is OFF > > > > >>> recursive clients: 0/0/1000 > > > > >>> tcp clients: 0/100 > > > > >>> server is up and running > > > > > >>> ssh connection was tested with the following code > > > > >>> <?php > > > > >>> if (!function_exists("ssh2_connect")) die("function ssh2_connect > > > > >>> doesn't exist"); > > > > >>> // log in at server1.example.com on port 22 > > > > >>> if(!($con = ssh2_connect("server1.example.com", 22))){ > > > > >>> echo "fail: unable to establish connection\n"; > > > > >>> } else { > > > > >>> // try to authenticate with username root, password > > > > >>> secretpassword > > > > >>> if(!ssh2_auth_password($con, "root", "secretpassword")) { > > > > >>> echo "fail: unable to authenticate\n"; > > > > >>> } else { > > > > >>> // allright, we're in! > > > > >>> echo "okay: logged in...\n"; > > > > > >>> // execute a command > > > > >>> if(!($stream = ssh2_exec($con, "ls -al" )) ){ > > > > >>> echo "fail: unable to execute command\n"; > > > > >>> } else{ > > > > >>> // collect returning data from command > > > > >>> stream_set_blocking( $stream, true ); > > > > >>> $data = ""; > > > > >>> while( $buf = fread($stream,4096) ){ > > > > >>> $data .= $buf; > > > > >>> } > > > > >>> fclose($stream); > > > > >>> } > > > > >>> } > > > > >>> } > > > > >>> ?> > > > > > >>> The error seems to be in the rdncstatus() fucntion. > > > > > >>> Tehe backtrace is below. Any ideas? > > > > > >>> Thanks, > > > > >>> Bert > > > > > >>> * /var/scalr/app/src/class.LoggerAppenderScalr.php:182 > > > > >>> Debug::Backtrace() > > > > >>> * /var/scalr/app/src/Lib/IO/Logging/log4php/src/main/php/ > > > > >>> LoggerAppenderSkeleton.php:254 > > > > >>> LoggerAppenderScalr->append(Object(LoggerLoggingEvent)) > > > > >>> * /var/scalr/app/src/Lib/IO/Logging/log4php/src/main/php/ > > > > >>> Logger.php:131 > > > > >>> LoggerAppenderSkeleton->doAppend(Object(LoggerLoggingEvent)) > > > > >>> * /var/scalr/app/src/Lib/IO/Logging/log4php/src/main/php/ > > > > >>> Logger.php:135 > > > > >>> Logger->callAppenders(Object(LoggerLoggingEvent)) > > > > >>> * /var/scalr/app/src/Lib/IO/Logging/log4php/src/main/php/ > > > > >>> Logger.php:217 > > > > >>> Logger->callAppenders(Object(LoggerLoggingEvent)) > > > > >>> * /var/scalr/app/src/Lib/IO/Logging/log4php/src/main/php/ > > > > >>> Logger.php:169 > > > > >>> Logger->forcedLog("LoggerCategory", Null, Object(LoggerLevel), > > > > >>> "BIND is not running on 123.123.123.123") > > > > >>> * /var/scalr/app/src/LibWebta/library/NET/API/BIND/ > > > > >>> class.RemoteBIND.php:173 > > > > >>> Logger->error("BIND is not running on 209.20.94.250") > > > > >>> * /var/scalr/app/src/LibWebta/library/NET/API/BIND/ > > > > >>> class.RemoteBIND.php:132 > > > > >>> RemoteBIND->InitTransport() > > > > >>> * /var/scalr/app/src/class.DNSZoneController.php:228 > > > > >>> RemoteBIND->__construct("123.123.123.123", "22", Array(3), "/ > > > > >>> usr/ > > > > >>> sbin/rndc", "/etc/bind/named.conf.local", "/etc/bind", "zone > > > > >>> "{zone}" { type master; file "{db_filename}"; a...") > > > > >>> * /var/scalr/app/www/sites_add.php:438 > > > > >>> DNSZoneControler->Update("4") > > > > > >>> -- > > > > >>> You received this message because you are subscribed to the Google > > > > >>> Groups "scalr-discuss" group. > > > > >>> To post to this group, send email to [email protected]. > > > > >>> To unsubscribe from this group, send email to > > > [email protected]<scalr-discuss%2bunsubscr...@googlegroups.com> > > > > >>> . > > > > >>> For more options, visit this group athttp://groups.google.com/ > > > > >>> group/scalr-discuss?hl=en. > > > > > > -- > > > > > You received this message because you are subscribed to the Google > > > > > Groups "scalr-discuss" group. > > > > > To post to this group, send email to [email protected]. > > > > > To unsubscribe from this group, send email to > > > [email protected]<scalr-discuss%2bunsubscr...@googlegroups.com> > > > > > . > > > > > For more options, visit this group athttp:// > > > groups.google.com/group/scalr-discuss?hl=en > > > > > . > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "scalr-discuss" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<scalr-discuss%2bunsubscr...@googlegroups.com> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/scalr-discuss?hl=en.- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en.
