Re: [sqlalchemy] MariaDB and SQLAlchemy

2015-05-20 Thread Margaret Tilton 

Michael,

Thanks for the response. The configuration of the username was indeed the 
problem!

Meg



On Tuesday, May 19, 2015 at 5:04:21 PM UTC-6, Michael Bayer wrote:

  

 On 5/19/15 6:53 PM, Margaret Tilton wrote:
  
 Hello, 

  If there is documentation on this that I missed, please let me know. 

  I have code that worked fine when I was using a MySQL database. My 
 organization has switched to using MariaDB, which I was told was virtually 
 identical to MySQL. It seems can connect to a MariaDB db using the 
 following statement, which doesn't generate any errors:

  engine = 
 create_engine('mysql+pymysql://[user]:[password@[server]/[db]', 
 pool_recycle=3600)
  
  Then the script tries to execute a simple select statement that worked 
 fine on MySQL:
   
 check_for_table = SELECT * FROM tb_metadata
  table_result = session.execute(check_for_table)
  
  At this point the script throws an error 
 (sqlalchemy.exc.OperationalError: (OperationalError) (1045, uAccess 
 denied for user XXX)
  

 that issue is not within SQLAlchemy, it has to do with the configuration 
 of the username which you are connecting with as well as the host 
 configuration.  You should try testing first with the mysql command 
 line client.Take a look at 
 https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/
  
 for configuration instructions.



  
  Any ideas? I would like to keep using SQLAlchemy if possible.

  Thank you,

  Meg
  -- 
 You received this message because you are subscribed to the Google Groups 
 sqlalchemy group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to sqlalchemy+...@googlegroups.com javascript:.
 To post to this group, send email to sqlal...@googlegroups.com 
 javascript:.
 Visit this group at http://groups.google.com/group/sqlalchemy.
 For more options, visit https://groups.google.com/d/optout.


  

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

[sqlalchemy] MariaDB and SQLAlchemy

2015-05-19 Thread Margaret Tilton 
Hello,

If there is documentation on this that I missed, please let me know. 

I have code that worked fine when I was using a MySQL database. My 
organization has switched to using MariaDB, which I was told was virtually 
identical to MySQL. It seems can connect to a MariaDB db using the 
following statement, which doesn't generate any errors:

engine = 
create_engine('mysql+pymysql://[user]:[password@[server]/[db]', 
pool_recycle=3600)

Then the script tries to execute a simple select statement that worked fine 
on MySQL:
  
check_for_table = SELECT * FROM tb_metadata
table_result = session.execute(check_for_table)

At this point the script throws an error (sqlalchemy.exc.OperationalError: 
(OperationalError) (1045, uAccess denied for user XXX)

Any ideas? I would like to keep using SQLAlchemy if possible.

Thank you,

Meg

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Re: [sqlalchemy] MariaDB and SQLAlchemy

2015-05-19 Thread Mike Bayer 



On 5/19/15 6:53 PM, Margaret Tilton wrote:

Hello,

If there is documentation on this that I missed, please let me know.

I have code that worked fine when I was using a MySQL database. My 
organization has switched to using MariaDB, which I was told was 
virtually identical to MySQL. It seems can connect to a MariaDB db 
using the following statement, which doesn't generate any errors:


engine = 
create_engine('mysql+pymysql://[user]:[password@[server]/[db]', 
pool_recycle=3600)


Then the script tries to execute a simple select statement that worked 
fine on MySQL:

check_for_table = SELECT * FROM tb_metadata
table_result = session.execute(check_for_table)

At this point the script throws an error 
(sqlalchemy.exc.OperationalError: (OperationalError) (1045, uAccess 
denied for user XXX)


that issue is not within SQLAlchemy, it has to do with the configuration 
of the username which you are connecting with as well as the host 
configuration.  You should try testing first with the mysql 
command line client.Take a look at 
https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/ 
for configuration instructions.






Any ideas? I would like to keep using SQLAlchemy if possible.

Thank you,

Meg
--
You received this message because you are subscribed to the Google 
Groups sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to sqlalchemy+unsubscr...@googlegroups.com 
mailto:sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com 
mailto:sqlalchemy@googlegroups.com.

Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.


--
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.