well ... i have a problem with phpmyadmin .... 1) i set up a default DB on mysequoia.conf 2) i don't set up a default DB on confic.inc.php from phpmyadmin 3) i access web interface of phpmyadmin ... and i can see all DBs ... i select one of it ...and i trie to browse the only one table from this DB ... the table is "users" and it's InnoDB ... and i have this error
--- snip ---- Error SQL query SHOW KEYS FROM `users` MySQL said #2000 - getLargeData: Value at row 0 column 2 is not of type blob, clob or byte array --- snip --- in log file from libmysequoia is empty ---- mysequoia.conf ---- [EMAIL PROTECTED]:/var/www/phpmyadmin# cat /etc/mysequoia/mysequoia.conf [client] database = test1DB ------------------------------------- ---- logger.conf --------- [EMAIL PROTECTED]:/var/www/phpmyadmin# cat /etc/mysequoia/logger.conf log4j.rootLogger=debug, file log4j.appender.file=org.apache.log4j.RollingFileAppender log4j.appender.file.File=/var/log/mysequoia.log log4j.appender.file.MaxFileSize=10MB log4j.appender.file.MaxBackupIndex=3 log4j.appender.file.layout=org.apache.log4j.PatternLayout log4j.appender.file.layout.ConversionPattern=%d %p %t %c (%F:%L) - %m%n # Print only messages of level ERROR or above in the namespace MySQLAPI. log4j.logger.LibMySequoia=ERROR ---------------------------------------------------------------- from sequoia console i can run the SQL sintax from above localhost:1090 > sql client jdbc:sequoia://localhost:25322/test1DB Login > vuser Password > jdbc:sequoia://localhost:25322/test1DB (vuser) > SHOW KEYS FROM `users` +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | users | false | PRIMARY | 1 | number | A | 15 | | | | BTREE | | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ Query executed in 0 s 31 ms . jdbc:sequoia://localhost:25322/avangateDB (vuser) > in the sequoia log file is something like this --- snip --- 2007-03-30 18:58:46,931 INFO controller.loadbalancer.RAIDb1 Request 45 failed (Request SHOW MASTER LOGS failed on backend 10.0.0.3 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 18:58:46,932 WARN sequoia.controller.cache Unable to remove pending query vuser,SHOW MASTER LOGS 2007-03-30 18:58:46,932 WARN controller.RequestManager.test1DB Failed to execute request SHOW MASTER LOGS because of (Request SHOW MASTER LOGS failed on backend 10.0.0.3 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 18:58:46,932 WARN controller.virtualdatabase.test1DB Request '45' failed (Request SHOW MASTER LOGS failed on backend 10.0.0.3 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 18:58:46,933 WARN virtualdatabase.VirtualDatabaseWorkerThread.test1DB Error during command execution (Request SHOW MASTER LOGS failed on backend 10.0.0.3 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 19:00:13,300 INFO controller.loadbalancer.RAIDb1 Request 110 failed (Request SHOW MASTER LOGS failed on backend 10.0.0.2 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 19:00:13,300 WARN sequoia.controller.cache Unable to remove pending query vuser,SHOW MASTER LOGS 2007-03-30 19:00:13,300 WARN controller.RequestManager.test1DB Failed to execute request SHOW MASTER LOGS because of (Request SHOW MASTER LOGS failed on backend 10.0.0.2 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 19:00:13,302 WARN controller.virtualdatabase.test1DB Request '110' failed (Request SHOW MASTER LOGS failed on backend 10.0.0.2 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 19:00:13,302 WARN virtualdatabase.VirtualDatabaseWorkerThread.test1DB Error during command execution (Request SHOW MASTER LOGS failed on backend 10.0.0.2 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 19:00:16,200 INFO controller.loadbalancer.RAIDb1 Request 156 failed (Request SHOW MASTER LOGS failed on backend 10.0.0.2 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 19:00:16,200 WARN sequoia.controller.cache Unable to remove pending query vuser,SHOW MASTER LOGS 2007-03-30 19:00:16,200 WARN controller.RequestManager.test1DB Failed to execute request SHOW MASTER LOGS because of (Request SHOW MASTER LOGS failed on backend 10.0.0.2 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 19:00:16,200 WARN controller.virtualdatabase.test1DB Request '156' failed (Request SHOW MASTER LOGS failed on backend 10.0.0.2 (Access denied; you need the SUPER privilege for this operation)) 2007-03-30 19:00:16,201 WARN virtualdatabase.VirtualDatabaseWorkerThread.test1DB Error during command execution (Request SHOW MASTER LOGS failed on backend 10.0.0.2 (Access denied; you need the SUPER privilege for this operation)) ---- snip ---- On Fri, 2007-03-30 at 17:51 +0200, Gilles Rayrat wrote: > Yes, no problem. > The only issue this tip solves it that you can connect to a mysql > server without specifying any DB, with sequoia you just can't > > Mihai Costache wrote: > > > > > > > ok .. let say that i put a default database in mysequoia.conf and i > > have more than one database .... let say 5 databases > > virtualdatabase ... and the name of this virtualdatabase are > > identical with real databases ? can i see the other 4 databases ? > > > > thanks > > > > > > > > On Fri, 2007-03-30 at 17:32 +0200, Gilles Rayrat wrote: > > > > > Hi Mihai, > > > phpmyadmin works under certain conditions: > > > . use identical name for virtual database and real (backend) > > > database > > > . connect with virtual database username / pass > > > . don't issue commands modifying users (add/remove users) and > > > databases (add or drop db) > > > . put a default database to connect to > > > in /etc/mysequoia/mysequoia.conf (eg. in [client] section: > > > database=<yourdb>) > > > > > > Hope these help > > > Cheers > > > Gilles. > > > > > > PS: these tips should also apply to other admin apps you would > > > find. > > > > > > Mihai Costache wrote: > > > > > > > so ... > > > > > > > > can you point me to a web application (php) for db management on > > > > top of this sequoia cluster ? > > > > > > > > thanks > > > > > > > > On Fri, 2007-03-30 at 10:37 +0200, Gilles Rayrat wrote: > > > > > > > > > Glad it worked! > > > > > Thanks for the feedback, > > > > > Cheers > > > > > Gilles. > > > > > > > >
_______________________________________________ Carob mailing list [email protected] https://forge.continuent.org/mailman/listinfo/carob
