Hi Igor Realized that and finally now reinstalled with MySQL 5.1. Will check for a couple of days and let you know.
The > PHP 5.3.5 and MySQL 5.1 installation is a nightmare as ready RPMs are not available (PHP 5.3.x are mostly with MySQL 5.5). I finally compiled everything from source and it looks to be running now. Will post the results in a couple of days if things have improved :) Thanks Srini On Thursday, March 15, 2012 5:30:38 PM UTC+5:30, DicsyDel wrote: > > Srini, > > Scalr was never tested on MySQL 5.5 . This mentions in our wiki - > scalr requires MySQL 5.1.X. Maybe this is an issue. > > Regards, > Igor > > On 14 March 2012 15:50, Srini <> wrote: > > Once my scalr server runs for a day or so, instance always remained in a > > pending state. After trouble shooting various touch points, I finally > > figured out it is a strange issue with MySQL. > > > > Here is what happens: > > > > 1. The message sent from the scalarizr on the instance is received by the > > scalr server. > > 2. The message is also logged in the syslog table. > > 3. The control queue handler runs an insert statement on the database > table > > messages. > > 4. The insert is successful and there is no exception, BUT the data is > not > > present in the messages table! > > > > I ran phpmysqladmin and connected to the database. Then ran the sql > > statement to insert the data. A successful message was displayed and row > id > > was displayed. However the DATA WAS NOT IN the table, select * returned > > empty table. > > > > I then restarted mysqld and everything was fine! The issue seems to be > > inserts into the messages table are not succeeding for some reason once > > mysqld has been running for some time (typically overnight) > > > > My setup: Centos 5.6, PHP 5.3.10 and MySQL 5.5.20 (I got the php from the > > remi repo and the mysql-libs from remi have a dependency on mysql5 from > the > > remi repo, so had to install the mysql 5.5 server from there) > > > > The my.cnf file had minimum settings as below: > > > > ------------------------------------------ > > [mysqld] > > user=mysql > > > > datadir=/var/lib/mysql > > socket=/var/lib/mysql/mysql.sock > > # Disabling symbolic-links is recommended to prevent assorted security > risks > > symbolic-links=0 > > > > [mysqld_safe] > > log-error=/var/log/mysqld.log > > pid-file=/var/run/mysqld/mysqld.pid > > > > > -------------------------------------------------------------------------- > > > > Any ideas? Thanks for your help on this, really appreciate it. Unless I > fix > > this I am stuck :( > > > > Cheers > > Srini > > > > -- > > You received this message because you are subscribed to the Google Groups > > "scalr-discuss" group. > > To view this discussion on the web visit > > https://groups.google.com/d/msg/scalr-discuss/-/XCr2cBaVcFgJ. > > 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. > > -- You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To view this discussion on the web visit https://groups.google.com/d/msg/scalr-discuss/-/YSIBjnpNPSoJ. 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.
